Excel 2016 Introduction

Lesson – Creating Simple Formulas

Excel 2016



P ROCEDURES

1. Select the range you want to calculate. 2. Release the mouse button. 3. To enable additional AutoCalculate results, right-click anywhere on the Status Bar . 4. Select the desired AutoCalculate function(s). 5. Select the Status Bar .



S TEP - BY -S TEP Use the AutoCalculate feature.

Steps

Practice Data

1. Select the range you want to calculate.

Select B5:D8

The range is selected as you drag.

2. Release the mouse button. The results of the enabled AutoCalculate functions are displayed in the Status Bar .

Release the mouse button

3. To enable additional

Right-click on the Status Bar

AutoCalculate results, right-click anywhere on the Status Bar . The Customize Status Bar menu appears. 4. Select the desired AutoCalculate function(s). The selected function(s) appear in the Status Bar .

Click MAXIMUM

5. Select the Status Bar .

Left-click on the Status Bar

The Customize Status Bar menu closes.

Click any cell to deselect the range.

Page 118

OFFICEPRO, Inc.