Page 74 - Excel Data Analysis

05 537547 Ch04.qxd 3/4/03 11:52 AM Page 60

EXCEL DATA ANALYSIS

ADD A FUNCTION VIA THE INSERT

FUNCTION DIALOG BOX

unctions, which are pre-built formulas, help you You use the Function Arguments dialog box to define the
analyze data because you can quickly insert values you want to use for arguments. Excel displays each
F calculations without manually entering them. Using required argument in bold, as well as an argument
the Insert Function dialog box is the easiest method for description at the bottom of the dialog box. If the cells
inserting functions because it alphabetically lists all of the surrounding the active cell contain values, Excel places
functions available in Excel along with their arguments. default cell references in the first argument field. You must
Arguments are the values you must provide for the function provide a value for each required argument. You can either
to return the result. All you have to do is select a function, enter a constant value in the cell or specify a cell reference
provide the appropriate arguments, and Excel does the rest. for the argument.
You can search for a specific function using the Search field Excel also calculates the results of the formula based upon
or select from one of Excel's pre-set categories. When you the specified arguments, and indicates that result at the
select a function, its description appears at the bottom of bottom of the dialog box. When you see the appropriate
the dialog box along with any arguments. See Appendix D result, you can close the Function Arguments dialog box
for more information about arguments and functions. and Excel pastes the function in the selected cell.

ADD A FUNCTION VIA THE INSERT FUNCTION DIALOG BOX

PRODUCT

⁄ Click the cell where you ¤ Click Insert ➪ Function. ■ The Insert Function dialog ‹ Click a function.
want to place the function. box displays.
■ You can also click the ■ Excel displays a
Insert Function button. ■ You can search for a description of the function.
specific function using the
search function. ■ Excel provides arguments
for the function.
■ You can select a category.
› Click OK.
60