Thursday 27 November 2014

CALC (Spreadsheets)

CALC(Spreadsheets)



CARLOS CAÑAS GARCÍA-MORENO
Calc is a program  informatic of libre office. It is a spreadsheet in which you can do all sorts of formulas and operation.

What is a spreadsheet? It is a document that can be manipulated to perform operations with numbers and letters, all composed of cells. The cell is the most important part of calc, since everything is divided into them, and operations are done according to the cell.


As I said before Calc is a spreadsheet which can do all kinds of activities, but in this course we are taught basic:

1 In the first year alone we operations such as add, multiply or divide. This was the result:


2 In the second, already started making percentages, and use fixed cells. Also started using cell formats, this is because changing the format so that it can be put in hours, rates etc. So this is the result:



3 In this exercise was to use the previous year, only had to add what was the richest, the poorest and the average Wealth, all this with formula:


4In this and started making conditional use if ... also teach us to use conditional formatting, which serves to distinguish yna boxes depending on condition. This was the result:


5In this exercise we learned something very important, the graphics. They are made from year two. First select the data, and then insert, you can already make the graph. There are many kinds, but we used the bar and the cheeses. This was the result:




6This was the last thing we did, and served us to know several things:
- To find spending numbers from Arabic to Roman system and vice versa.
- To count the days from one date to another.
- To choose a number to luck.
- To series of numbers in arithmetic or geometric, or dates, whether years, days, or months etc.


All these were the exercises we did learn some of the endless formulas and operations that can be done with this awesome tool.