• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 11. Entering Calculations > Using Common Functions

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


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