Microsoft Office Tutorials and References
In Depth Information
Inserting a Function
Inserting a Function
Functions are organized in the Function Library group on the Formulas tab on the
Ribbon. In the Function Library, you can select a function from a function category or
you can open the Insert Function dialog box to search for a particular function. When
you select a function, the Function Arguments dialog box opens, listing all the arguments
associated with that function. Required arguments are in bold type; optional arguments
are in normal type.
You’ll use the SUM function to add the total income and expenses for the year in
Diane’s proposed budget.
To calculate annual income and expenses with the SUM function:
1. Click cell to select it. F9
2. Click the Formulas tab on the Ribbon.
3. In the Function Library group, click the Math & Trig button. An alphabetical
listing of all the math and trigonometry functions opens.
You can click the Collapse
Dialog Box button to shrink
the Function Arguments
dialog box to see more of
the worksheet, select the
range, and then click the
Expand Dialog Box button
to restore the dialog box.
4. Scroll down the list, and then click SUM . The Function Arguments dialog box
opens, listing all of the arguments associated with the SUM function.
5. Click in the worksheet, and then select the range C21:N21 . The dialog box
reduces to its title bar as you select the range. The range reference, which
includes all the monthly income amounts, appears as the value of the Number1
argument. See Figure 3-11.
Function Arguments dialog box
appear in bold
cell values in
appear in regular type
preview of the
by the function
description of the fu nction
preview of the valu e
displayed in the active cell
description of the selected
6. Click the OK button. The formula =SUM(C21:N21) is inserted into cell F9, which
displays the value 51,000. This represents Diane and Glenn’s total annual income.
7. Click cell F13 . This is where you want the SUM function to add the monthly
expenses for the year.
8. In the Function Library group on the Formulas tab, click the Math & Trig button,
and then click SUM . The Function Arguments dialog box opens. You’ll enter the
monthly expenses stored in the range C32:N32 for the argument.