Excel 2016 Introduction

Lesson – Creating Simple Formulas

Excel 2016

Using the AutoSum list

NOTE Another method of inserting a formula using the AutoSum list is to select the column or row of values you want the function to calculate. When you select a function from the AutoSum list, the formula is automatically inserted into the first available blank cell below the selected column or to the right of the selected row. The More Functions command in the AutoSum list opens the Insert Function dialog box, which can be used to access all Excel functions.



P ROCEDURES

1. Select the cell into which you want to enter the formula. 2. Select the arrow on the bottom part of the AutoSum button in the Function Library group on the Formula tab. 3. Select the desired function. 4. Drag to select the range you want to calculate, if necessary. 5. Release the mouse button. 6. Press [Enter] .



S TEP - BY -S TEP

Use the AutoSum list.

Page 106

OFFICEPRO, Inc.