Excel 2016 Introduction

Lesson – Creating Simple Formulas

Excel 2016

Using the Function Arguments dialog box

NOTE If the cells you wish to select are not hidden by the Function Arguments dialog box, you do not have to collapse the dialog box to select the cells. You can also type the range address in the relevant edit box in the Function Arguments dialog box, if desired. Typing an equal sign into a cell displays the name of the most recently used function in the Functions area to the left of the Formula Bar normally occupied by the Name Box . If you click the name of the displayed function, it is entered in the Active Cell and the Function Arguments dialog box opens. Clicking the list arrow at the right of the Functions area displays a list of other recently used functions. Selecting a function from this list enters it in the Active Cell and opens the Function Arguments dialog box; selecting More Functions at the bottom of the list opens the Insert Function dialog box.



P ROCEDURES

1. Select the cell into which you want to enter the formula.

2. Select the Insert Function button in the Formula Bar . 3. Enter a description of what you want to do and press [Return] . 4. Select the desired function in the Select a function list. 5. Select . 6. Click the Collapse Dialog button

at the right of the first argument edit

box. 7. Select the range you want to use in the calculation. 8. Release the mouse button.

Page 112

OFFICEPRO, Inc.