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. Select the arrow on the bottom part of the AutoSum button on the Formula tab. A list of additional functions appears. surrounded by a blinking, colored border, and a function ScreenTip appears. 4. Drag to select the range you want to calculate, if necessary. The range is selected as you drag. 5. Release the mouse button. The blinking, colored border appears around the selected range. 3. Select the desired function. The suggested range is

Click cell B11

Click

Click Max

Select B5:B8

Release the mouse button

6. Press [Enter] .

Press [Enter]

The result of the formula appears in the cell.

The result of the formula in B11 should be 2009 .

U SING F ORMULA A UTO C OMPLETE  D ISCUSSION Although the AutoSum list assists you in creating formulas for the most commonly used functions, you may prefer to manually enter a function. The SUM , AVERAGE , MAX , MIN , and COUNT functions are entered with the same syntax, including beginning the function with an equal sign ( = ) and then typing the name of the function and an open parenthesis. You then enter the cell range by dragging to select the cells or by typing the first cell in the range, a colon (:), and the last cell in the range. The functions are defined in the following table:

OFFICEPRO, Inc.

Page 107