• Create BookmarkCreate Bookmark
• Create Note or TagCreate Note or Tag
• PrintPrint

### Using Common Functions

Functions are shortcuts for common calculations that would be difficult or impossible for you to create yourself with a basic formula. After you've had a chance to learn how they work, see Table 11.2 for some common functions.

To total a column with the Sum function:

1.
Click the cell in which you want the sum to appear (Figure 11.7).

##### Figure 11.7. Click the cell in which you want the formula to appear.

2.
Enter an equal sign (=) to start the formula (Figure 11.8).

##### Figure 11.8. start a formula with the equal sign.

3.
Type the word sum (Figure 11.9).

##### Figure 11.9. Type sum.

4.
Type an open parenthesis () (Figure 11.10).

##### Figure 11.10. Type an open parenthesis.

5.
Drag down the column of numbers to be totaled (Figure 11.11).

##### Figure 11.11. Drag across the range of cells being summed, in this case form B2 to B6.

6.
Press (Figure 11.12).

##### Figure 11.12. Press to complete the formula.Type an open parenthesis.

PREVIEW

Not a subscriber?

Start A Free Trial

• Create BookmarkCreate Bookmark
• Create Note or TagCreate Note or Tag
• PrintPrint