The spreadsheet is a software whose function is to conduct mathematical operations from data had in the cells the tables.
He is much more powerful that a calculator because it allows to conduct many operations simultaneously and it is but easy to include the data in the table that in the calculator. While the calculator only executes data in an object, the table does simultaneously in multiple.
In addition, if we were mistaken when introducing a data, we can modify it very easy without repeating all the process.
Just by to change a field, allows us to realise simulations.
Another one of the advantages is that to be used in the creation of graph, data bases and document.
Perhaps the well-known one is Microsoft Excel, although the one that we are going to use is Calc, integrated in OpenOffice. All is very similar.
Elements of a spreadsheet.
Calc, the opened being, shows bars of tools where as much menus are included as icons of access to the functions of the program. To look more down.
A very important element is the cells that the small grids where we introduce the data and where they are going away to show the results of the operations once applied the formula that we have chosen, for example sum cell E2 + E4 cell and it is in E6 cell.
Operators, data and formulas.
One of the advantages that it has Calc is that it simplifies the repetition of operations, that is to say, if we want that it calculates a data on a data set, we can do the same on another set without having to repeat the process
In addition we do not have to repeat the operations when we modified a data. This is the difference that is between the calculator and the data base. The calculator takes a real data, for example the 27 and spreadsheets take the reference from the cell, for example B2. If B2 has value 27, it formulates it that there is later took the value that has B2. If soon B2 takes another value, it formulates it applies it of automatic form
We put an example
Calculator: - > 2 xs 27 = 54
CAL: - > B1 x B2 = (if 2 B1 and B2 gives 54).
Example: =B5*9 (it multiplies the content of the B5 cell by 9).
To use the functions.
We have seen a very simple case of operations between two squares. For more complex operations, they are used some of the functions within the bookstore that has calc. One of them is function =SUMA (B1: B90) that would add the terms that are located from the B1 cell to the B90.
Function =PRODUCTO (B1: B10) does the same but now it multiplies the terms that go from the B1 to the B10.
To open the program and to throw a look to the assistant for the functions, to choose the function between the diverse categories that come built-in the program.
When selecting the assistant, we have a window as the following one:
We see some example to calculate the M.C.D of several numbers. We will have:
In the right part we have the cells that we must select. When puncturing in them, the program it sends us to the spreadsheet to choose it or we can write it directly if we know his coordinates.
The assistant of functions offers other types to us of very useful functions for engineers, economists, lawyers etc.
Some examples of functions are
1. =CONTAR.SI (D10: D40; “>=5”) - > Cuenta the squares whose S-value superior to 5 (is only worth to count the approved ones in a class).
2. =CONTAR.SI (D10: D40; “>=5”)/TO COUNT (D10: D40). In this case, to calculate the percentage of approved.
3. =PROMEDIO (D10: D40) Calculates the arithmetic mean.
4. ==COS (D1). It gives the cosine us of the D1 square
The number of functions is very high and is better than we see it in the application. The selected being, in the same window it shows a message to us with the task that realises
Format of the cells.
With the format of the cells we can define as much aesthetic aspects as technicians of the different cells from our spreadsheet. It is an important aspect because it can give errors us if well it is not formed
In order to modify the format of cells, we must go a Format > soon to - > Cells… and appears the following window:
In the previous image we can observe that several categories exist: currency, date, hour, science,… According to the concept that we are trying, thus we must put the format of the cell. We show a pair of windows where one is but details:
As protecting the cells.
We show an image where they detail the route to protect the cell
To insert diagrams.
3º. To form the fields that to us the diagram asks for, as, titles of axes, names of the graph…
Activity as data base
For the following point, to realise an example where we have at least 10 registries of 10 friendly as one is in the following image. It is necessary to complete it with another field that sex indicates and another one but with the present age. Later to make a graph that represents whatever they are friendly and whichever friendly
To print a spreadsheet.
In order to print the file of calc we must go a: File > Imprimir. (to see the first preliminary Vista to see as it is).
The aspect of the leaf can be formed in the option Format > Page in the menu bar.