Lesson 19ª

 

 

 

 

 

   

 

ADDING WITH EXCEL

Excel is mainly a calculating sheet. It is used to perform different mathematical or financial operations. Thus, as a calculating worksheet, it has several functions we will learn little by little.

ADDING OPERATIONS WITH EXCEL (SUM)

There are two ways in which you can add with Excel: one is used mainly when adding continuous numeric ranges, and the other for any situation in which you need to add.

A Common Sum:

Lets take the budget we have prepared in previous lessons. For example, if we wanted to add the salaries for four months, we would do the following:

1. We click on the cell where we want to visualize the result of the sum of all these quantities.

2. For Excel to recognize any operation, we need to use the equal sign (=). This indicates that a number calculation will be performed on this cell.

3. Lets see how the formula bar recognizes the equal sign in this cell.

4. Since we want to add the budget form January, February, March and April, we will mark these four cells. How do we do this? Lets see...

After having written the equal sign, with the mouse, locate the first quantity (corresponding to January), mark it and then write the plus sign (+). Mark the second quantity (again, using your mouse) and we write another plus sign. Mark the third quantity

This would be the sum up to now.

5. After marking the third quantity, write another plus sign and then mark the fourth quantity.

Lets see the formula bar. It shows everything that is being done to the selected cell:

6. When we have marked the last (fourth) quantity to be added, press Enter on your keyboard. We will get the result of the sum.

Important: remember that to mark each one of the quantities to be added, we need to locate them with your mouse and click on them. We can see how each one of the gets marked by showing a dotted coloured border around the cell.

, in this case, the border of the cell with the quantity of 10,000 is dotted. This means it is selected (marked).