Excel 2016 Introduction

Excel 2016

Lesson – Creating Simple Formulas

Edit a function



P ROCEDURES

1. Select the cell containing the function you want to edit.

2. Select the Insert Function button

on the Formula tab.

3. Select the Collapse Dialog button

for the argument you want to edit.

4. Select the range you want to use in the calculation. 5. Release the mouse button. 6. Click the Expand Dialog button . 7. Select .



S TEP - BY -S TEP

Edit a function.

Select cell C12 and use the AutoSum list to insert the MIN function; accept the suggested range.

Steps

Practice Data

1. Select the cell containing the function you want to edit.

Click cell C12

The active cell moves accordingly.

2. Select the Insert Function button on the Formula tab. The Function Arguments dialog box opens.

Click

OFFICEPRO, Inc.

Page 115