Excel 2016 Introduction

Lesson – Creating Simple Formulas

Excel 2016

Steps

Practice Data

Type MIN and click Go , then click OK .

3. Search for the MIN function.

4. Select the Collapse Dialog button for the argument you want to edit. The Function Arguments dialog box collapses. 5. Select the range you want to use in the calculation. The range is selected as you drag. collapsed Function Arguments dialog box, as well as in the formula in both the Formula Bar and the cell. 7. Click the Expand Dialog button. The Function Arguments dialog box expands. 6. Release the mouse button. The range appears in the

Click the

Select C5:C8

Release the mouse button

Click

8. Select OK .

Click

The Function Arguments dialog box closes, and the result of the formula appears in the cell.

The result of the calculation should be 1725 .

U SING THE A UTO C ALCULATE F EATURE  D ISCUSSION

The AutoCalculate feature performs a simple calculation on a selected range of cells without making you supply a formula. The result of the calculation appears on the Status Bar . AutoCalculate results are temporary and are not placed in the worksheet. AutoCalculate is helpful when you want to spot-check your worksheet for accuracy or need a quick answer to a basic calculation.

By default, three of the AutoCalculate functions ( Average, Count and Sum ) are enabled in the Status Bar and will display their results as soon as you select a range of cells containing values. You can choose which AutoCalculate results are enabled by customizing the Status Bar .

Page 116

OFFICEPRO, Inc.