Excel-Exercise-Free

1. Take the following example.It's the most common function used and often the first one made by the beginner ;-)
In this section, I will explain - step by step - how this function is made. But if you are not a beginner, you can go straight to the end to to make quickly a function SUM

2. So, to start your formula, you write the word SUM with the sign '=' before.
The sign is essential to inform EXCEL that we are creating a function or a formula.

3. Then, a parenthesis is opened.
When a parenthesis is opened, this means that we give parameters to the function.

4. For a function SUM, you just have to select the range of cell to add ; here B3:B8.
The sign ':' means that EXCEL will read all the cells between B3 and B8.

Let's change the ':' by ';' and see what that means !

5. Then, you just have to close the parenthesis and that's all.
Press 'Enter' and the result is displayed in B9.

GREAT ! You have writen your first function.

6. Now, we will see how to write this function quickly with this icon.

7. Activate the cell B9 and clic on the icon SUM

8. Automaticaly, the range of cells B3 to B8 are selected.

Magic ! No, EXCEL

9. Now, go in B13, clic on the icon SUM and the cells between B3 to B12 that are selected.

10. And Now, Ladies and Gentleman, the highpoint of the show.
Fisrt you select your range of cells (B3:B8), and then you clic on the icon SUM

11. In B9, the function is created immediately.