Excel-Exercise-Free

1. Let us continue with the current example. The fixed expenses of the grocery store are set to 9000 euros for the year. Therefore, the fixed expenses spread over the year will be 9000 divided by 12.

2. In Excel, all formulas begin with the equal sign =.

In this example, position yourself in cell B2 and divide the annual fixed expenses by the number of months in a year.
The formula, therefore, is

Formule de la cellule

3. Note that the number 750 appears in cell B2 but not in the formula bar. Instead, the formula bar displays the formula used to obtain that figure. Notice that since it is a figure, it is thus located near the right margin of the cell.

4. Be careful not to erase or modify the content of a cell without first checking whether it is the result of a formula.

5. If you modify the value in cell B3 by changing it to 800, for example, you will notice that the formula bar does not display the formula any longer.

6. The variable expenses in January are 500 euros; type this figure in cell B4.

7. In cell B5, you will calculate the sum of the expenses. It is possible to type in the result of the sum, 1250, directly into the cell but it would entirely defeat the purpose of using Excel and its functions.

8. To solve the sum, follow the next steps. Highlight cell B5 and start your formula with '='

Formule de la cellule

9. Then, with your mouse or keyboard arrows, move to activate cell B3. The active cell is now bordered with animated dotted lines. This is called the selection box.

Formule de la cellule

10. After that, press the + .
The animated dotted line around the cell B3 disapered.

Formule de la cellule

11. To finish the formula, move onto cell B4 using the same method and then press “Enter”.

Formule de la cellule

12. The contents in cell B5 display a figure which is the result of a formula.

13. Unlike for the monthly fixed expenses' formula (B3) which is a standard calculation, we obtained here the total result of January's expenses by simply re-using the information in the worksheet.

14. If you modify the value within a cell, the total result of the expenses will be modified at the same time.

For example, if you replace 500 by 600, the result of the expenses will be equal to 1350 after validation. This is what was referred to earlier as the automatic reaction principle of Excel.

15. To finish the calculations for January, we will display the results that our company will carry out during that month.

The current income will be the difference between the sales and the total of the expenses within that period. The subtraction equation will be built similarly to the addition's equation.

16. Highlight cell B6 and type in the = . sign and then select cell B2.

17. Once you are positioned, type in the sign - .

18. To finish the formula, move onto cell B5 and then press « Enter »

Formule de la cellule

19. And for this formula, the result is :

20. We have just seen that a worksheet contains raw data (as in the income), calculated data (as in the fixed expenses) and referred data, which is a result of the information previously registered.

Whatever calculations you will carry out, they will be based on one of the cases mentioned above.