Excel 2016 Introduction

Excel 2016

Lesson – Creating Simple Formulas

Steps

Practice Data

1. Select the cell into which you want to enter the formula. The selected cell becomes the Active Cell . 2. Click the left-hand part of the AutoSum button in the Function Library group on the Formulas tab. The suggested range is

Click cell B9

Click

surrounded by a colored border, and a function ScreenTip appears.

3. Press [Enter] .

Press [Enter]

The result of the formula appears in the Active Cell .

The result of the function should be 7490 . Select cell B9 and notice the SUM function in the formula bar.

Practice the Concept: Use the AutoSum button to total the sales figures for Feb in cell C9 and for Mar in cell D9 . The results should be 7495 and 7628 . Total the Expenses in cell F9 as well. The result should be 5401 .

U SING THE A UTO S UM L IST  D ISCUSSION

The AutoSum button provides an arrow, which displays a list of other functions you can perform on consecutively filled cells in a column or row. For example, it is easier to use the Average function from the AutoSum list to average the numbers in cells B1 through B7 than to type the formula =(B1+B2+B3+B4+B5+B6+B7)/7 .

Other commonly used functions in the AutoSum list are Count , Max , and Min . Count returns the number of cells containing numeric values, Max returns the highest value in the range, and Min returns the lowest.

Each of these functions automatically use the cell range immediately adjacent to the active cell for the suggested range. If this suggested range is incorrect, you can change it by dragging to select the cells containing the values you want to calculate.

OFFICEPRO, Inc.

Page 105