Microsoft Office Tutorials and References
In Depth Information
Excel’s Statistical functions
4. Click AVERAGE in the list, and then click the OK button. The Function Arguments dialog
The Function Arguments dialog box provides the syntax of the selected function in an
easy-to-use form. You can enter the values needed for the arguments in the reference
boxes by typing them or by selecting the cell range from the worksheet. To select a cell
range in the worksheet, you can click the Collapse Dialog Box button located to the right
of each argument reference. Clicking this button reduces the size of the dialog box so you
can see more of the worksheet. The Collapse Dialog Box button is a toggle button and,
when clicked, changes to the Expand Dialog box button, which you click to restore the
dialog box to its original size.
Although Amanda’s salary did not change during the past year, she wants to use this
workbook as a model for the next couple of years. If her salary changes in the future, the
formula to calculate the average income will be in place.
You will use the Insert Function dialog box to enter the formula to calculate the average
value of the cells in the range B6:M6, which contains Amanda’s monthly salary amount.
To insert values into the AVERAGE function:
1. Click the Collapse Dialog Box button located to the right of the Number1 argument ref-
erence box. The Function Arguments dialog box reduces in size to let you see more of the
worksheet, and the Collapse Dialog Box button changes to the Expand Dialog Box button.
Trouble? If the collapsed dialog box is still in the way of the range you need to select,
drag the dialog box to another location on the worksheet.
2. Select the range B6:M6 on the worksheet, and then click the Expand Dialog Box button
to restore the Function Arguments dialog box to its original size, as shown in Figure 2-15.