Excel 2016 Introduction

Lesson – Creating Simple Formulas

Excel 2016

Steps

Practice Data

Enter =SUM(F5) into cell F9 .

1. Insert formula

2. Double-click the cell containing the formula you want to edit. The formula range references and their corresponding range borders appear in the same color. 3. To change the size of a referenced range, point to the square range handle at the appropriate corner of the range border.

Double-click cell F9

Point to the range handle at the bottom-right corner of cell F5

The mouse pointer changes to a black, diagonal, double-headed arrow.

4. Drag the range handle in the

Drag the range handle down to include only F5:F6

desired direction to include more or fewer cells. The range is adjusted as you drag.

5. Release the mouse button.

Release the mouse button

The range border and the formula range reference change accordingly. 6. To move a referenced range without changing its size, point to the range border on any side of the range. The mouse pointer changes to a black, four-headed arrow. 7. Drag the range border to the desired position. The range changes as you drag.

Point to the range border

Drag the range border down to F7:F8

8. Press [Enter] .

Press [Enter]

The result of the modified formula appears in the cell.

Notice the green triangle that appears in the upper left corner of cell F9. Excel senses that you may have made an error.

Page 120

OFFICEPRO, Inc.