Microsoft Office Tutorials and References
In Depth Information
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
category list box
list of recently
description of th e
click to view online
Help about the
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.