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.

Figure 3-11

Function Arguments dialog box

required arguments

appear in bold

cell values in

the selected

range

optional arguments

appear in regular type

preview of the

value
returned

by the function

description of the fu
nction

preview of the valu
e

displayed in the active cell

description of the selected

argument

◗

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.