Spreadsheets (Using Microsoft Excel)  -  1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21
 Exercise 1  Exercise 2  Exercise 3  Exercise 4
Community Learning Homepage

<< PREVIOUS   15 - Adding a range of cells (SUM)   NEXT >>

The formula you create will appear in the cell and also in the formula bar as you create it and also when the answer appears.

1. Click the cell you want the answer to appear in and type an equal = sign.
2. Type the word SUM, followed by open brackets.
3. Click the first cell reference in the range.
4. Type a colon.
5. Click the last cell reference in the range.
6. Type a closed bracket

<< PREVIOUS   -   NEXT >>