Excel 2016 Introduction

Lesson – Creating Simple Formulas

Excel 2016

Using the AutoSum button

NOTE If the range of values you wish to sum is not contiguous, you can select the range and then click the AutoSum button. If you select a row of values, Excel enters the Sum formula in the first empty cell to the right of the selected range. If you select a column of values, Excel enters the Sum formula in the first empty cell below the selected range. When you use the AutoSum button, a ScreenTip appears with information about the structure of the selected function. If you click the name of the function in the ScreenTip, Excel displays additional help for the function.



P ROCEDURES

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

2. Click the left-hand part of the

button in the Function Library group on

the Formulas tab.

3. Press [Enter] .



S TEP - BY -S TEP Use the AutoSum button to total the values in a column or row.

Page 104

OFFICEPRO, Inc.