Excel 2016 Introduction

Lesson – Creating Simple Formulas

Excel 2016

Steps

Practice Data

3. Type the first letter of the formula.

Type M

The Formula AutoComplete drop- down list is displayed with the first option highlighted and a ScreenTip describing its use.

4. Type next trigger letter in the

Type I

formula. A list of options becomes shorter.

5. Press the down arrow on the keyboard to highlight the desired option. The desired function is highlighted 6. Press the [Tab] key to select the desired function. The Formula AutoComplete drop- down list closes, the function is inserted in the cell with the insertion point positioned immediately after the opening parenthesis and a ScreenTip describes the structure of the function. 7. Select the range of cells to be calculated. The range is outlined as you drag and a ScreenTip indicates how many columns and rows are selected.

Use the down arrow to highlight MIN

Press [Tab]

Select cells B5 : B8

8. Release the mouse button. The formula appears in the

Release the mouse button

Formula Bar and in the cell, and a blinking border with colored corners appears around the selected cells.

9. Press [Enter] .

Press [Enter]

The result of the formula appears in the cell.

The result of the formula should be 1704 .

Page 110

OFFICEPRO, Inc.