Excel 2016 Introduction

Excel 2016

Lesson – Using Basic Workbook Skills



P ROCEDURES 1. Select the cell in which you want to use the AutoComplete feature. 2. Begin typing the entry, until the desired completed entry appears in the cell. 3. Press [Enter] . 4. Right-click the cell in which you want to use the Pick From Drop-down List feature. 5. Select Pick From Drop-down List . 6. Select the desired entry.



S TEP - BY -S TEP Use data entry shortcuts to repeat an entry in a column.

Steps

Practice Data

1. Select the cell in which you want to use the AutoComplete feature. The active cell moves accordingly.

Click cell B7

2. Begin typing the entry, until the

Type N

desired completed entry appears in the cell. The completed entry appears in the formula bar and in the active cell.

3. Press [Enter] .

Press [Enter]

The text is entered into the active cell.

4. Right-click the cell in which you want to use the Pick From Drop-down List feature. A shortcut menu appears.

Right-click cell B8

5. Select Pick From Drop-down List .

Click Pick From Drop- down List

A list of available entries for the active column appears.

6. Select the desired entry.

Click Boston

The entry appears in the active cell.

OFFICEPRO, Inc.

Page 65