Microsoft Office Tutorials and References
In Depth Information
Inserting a Function
Figure 3-13
Insert Function dialog box
description of the
function
functions that match
the description (your
list might differ)
syntax and description
of the selected
function
click to access online
help about the selected
function
4. Verify that AVERAGE is selected in the Select a function box, and then click the
OK button. The Function Arguments dialog box opens with the arguments for the
AVERAGE function. A range reference for a cell directly above this cell already
appears for the Number1 argument.
5. Select the range reference in the Number1 argument box, and then select the
range C21:N21 in the worksheet.
6. Click the OK button. The dialog box closes, and the formula =AVERAGE(C21:N21)
is entered in cell F10, which displays the value 4,250—the couple’s average
monthly income.
How does the couple’s average monthly income compare to their average monthly
expenses? To fi nd out, you’ll use the AVERAGE function again. Because the function
has already been used in your workbook, you can select it from a list of recently used
functions.
To calculate the average monthly expenses:
1. Click cell F14 . This is the cell where you want to calculate the average monthly
expenses.
2. On the formula bar, click the Insert Function button
. The Insert Function
dialog box opens.
3. If necessary, click the Or select a category arrow, and then click Most Recently
Used . The most recently used functions, sorted in order of recent use, appear
in the Select a function box. The AVERAGE function is at the top followed by the
SUM function.
4. Verify that AVERAGE is selected in the Select a function box, and then click the
OK button.
5. Select the range C32:N32 in the worksheet to insert the range reference C32:N32
in the Number1 box.
Search JabSto ::




Custom Search