Excel 2016 Introduction

Lesson – Working with Ranges

Excel 2016

Steps

Practice Data

4. Press [Enter] .

Press [Enter]

The data is entered into the cell and the next cell in the range is activated.

5. Continue entering data as desired. The data is entered into the range.

Follow the instructions shown below the table to complete this step

Use the following table to fill in the data in columns D and E by typing the number and pressing [Enter] after each entry:

A

B

C

D

E

4

Sales Reps

5

Smith, S.

1819

1766

1942

6

Brown, N.

1704

1809

1651

7

Wallace, F.

2009

2195

2164

8

Adams, G.

1958

1725

1871

Click any cell to deselect the range.

U SING THE A UTO F ILL F EATURE  D ISCUSSION

You can use the Auto Fill feature in Excel to create a standard series of labels on a worksheet. Examples of standard series include months of the year, days of the week, and quarters of the year.

When you select a cell or range, a small, black box called the fill handle displays in the lower right corner of the cell or range. When the mouse pointer is positioned on the fill handle, it changes into a solid, black plus sign (+). If the cell contains a label that Excel recognizes as an item in a standard series, a ScreenTip appears displaying the next item in the series as you drag the fill handle.

When you release the mouse button, Excel fills the range based on the contents of the first cell in the range, and the Auto Fill Options button appears in the lower right corner of the last cell. Clicking the Auto Fill Options button displays a list of available Auto Fill options.

Page 92

OFFICEPRO, Inc.