Information Technology      Technology of THAT About


The Spreadsheet
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.calculation leaf

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.



We show to a bar of tasks of Calc where the most habitual operations as to open the program or to create a new document they are realised in the same way that in writer (text processor of openoffice).


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.

screen of calc


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).

We have already seen ours first formula.  So that in a cell some calculation takes place, it is necessary to use a formula.

Steps to follow to generate an operation:

1º. The cursor is placed in the cell that is going to show the result.

2º. We write the formula that we needed for the calculation. It always must begin with the equal sign (=).


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.

category in the functions

When selecting the assistant, we have a window as the following one:

functions 3

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

format cell

In order to modify the format of cells, we must go a   Format > soon to - > Cells… and appears the following window:


date calc

 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.

Very adapted to protect some cells, being allowed us to work in a spreadsheet without fear to the loss of formulas that we used.

Steps to protect the cell:

1º step. To protect the spreadsheet using the route:

Tools > Proteger document > Spreadsheet

2º step. To select the cell that we needed to protect. Later to go to Format of cells - > eyelash - to >Proteger cell).

to protect cell


We show an image where they detail the route to protect the cell

To insert diagrams.

If we want to graphically represent the data that the spreadsheet offers to us, with a few steps we will have diverse models to choose so that of a look we become idea of the work, as for example, that social network more is used or than team of the league but it is admired. The process to insert the diagram is the following one:

Steps to incorporate the diagram:

1º. We select the cells that will comprise of the diagram.

2º. To go to menu To insert - > Diagram

diagram in calc


3º. To form the fields that to us the diagram asks for, as, titles of axes, names of the graph…

Activity as data base

basedatos in calc


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).

to print calculation leaf


The aspect of the leaf can be formed in the option Format > Page in the menu bar.


In order to finalize, to realise the activities of the electrical consumption

Design PCB