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.
Search JabSto ::




Custom Search