


4: Formulae
When you enter a calculation into a spreadsheet, this is called a 'Formula'.
This spreadsheet contains 6 different values in the coloured cells. To add them together, a formula has been used.
Cell E9 contains the formula.
This formula is visible in the 'Formula Bar' just above the C, D and E columns (=A1+C2+E4+ B5+A7+D7).
The formula is telling the spreadsheet to add together all of the values contained in those cells and display the answer in cell E9 (21).
A formula always begins with an equals = symbol.
Copyright © www.teach-ict.com