Microsoft Office Tutorials and References

In Depth Information

**Inserting a Function**

◗

9.
Click in the worksheet, and then select the range
C32:N32
.

◗

10.
In the Function Arguments dialog box, click the
OK button. The formula

=SUM(C32:N32) is inserted in cell F13, which displays the value 45,150. This

represents the total projected expenses for the upcoming year. See Figure 3-12.

Figure 3-12

Total annual income and expenses

SUM function

formula returns the

total annual expenses

total annual income

total annual expenses

values added in

the SUM function

formula in cell F9

Diane projects that she and Glenn will earn roughly $6,000 more than they will

spend throughout the year. It’s easier for Diane to plan her budget if she knows how

much, on average, the couple earns and spends each month. You can use the AVERAGE

function to do this calculation using the same method you used for the SUM function.

If you aren’t sure of the function’s name or category, you can use the Insert Function

dialog box. The Insert Function dialog box organizes all of the functions by category and

includes a search feature for locating functions that perform particular calculations.

To calculate the couple’s average monthly income:

◗

1.
Click cell
F10
. This is the cell in which you want to enter the AVERAGE function

formula.

◗

2.
In the Function Library group on the Formulas tab, click the
Insert Function

button. The Insert Function dialog box opens.

You can also click the

Insert Function button

on the formula bar to

open the Insert Function

dialog box.

◗

3.
In the Search for a function box, type
Calculate an average value
, and then click

the
Go button. Functions for calculating an average appear in the Select a

function box. See Figure 3-13.