Microsoft Office Tutorials and References

In Depth Information

**Session 2.1**

From these calculations, Amanda can quickly see that her family’s yearly income is

$41,400, whereas their yearly expenses total $35,004. Their largest expense is rent—a total

of $10,200 per year.

Using the Insert Function Dialog Box

It’s easier for Amanda to plan a budget if she knows approximately how much the family

makes and spends each month. So your next task is to add a column that calculates the

monthly averages for each of the income and expense categories. Rather than typing the

function directly into the cell, you may find it helpful to use the Insert Function button on

the Formula bar. Clicking this button displays a dialog box from which you can choose the

function you want to enter. Once you choose a function, another dialog box opens, which

displays the function’s syntax. In this way, Excel makes it easy for you to avoid making mis-

takes. Try this now by entering the AVERAGE function using the Insert Function dialog box.

To insert the AVERAGE function:

1.
Click cell
C28
, type
Average
, and then press the
Enter
key.

2.
Click cell
C30
and then click the
Insert Function
button

on the Formula bar. The Insert

Function dialog box opens. See Figure 2-13.

Insert Function dialog box

Figure 2-13

category list box

list of recently

used functions

description of th
e

selected function

click to view online

Help about the

selected function

The Insert Function dialog box shows a list of the most recently used functions. As you can

see from Figure 2-13, one of these is the AVERAGE function. However, your list may be dif-

ferent and might not include the AVERAGE function. You can display a different function list

using the category list box. Try this now to display a list of the Statistical functions sup-

ported by Excel.

3.
Click the
Or select a category
list arrow, and then click
Statistical
. Excel displays a list of

Statistical functions. See Figure 2-14.