Excel 2016 Introduction

Excel 2016

Lesson – Using Basic Workbook Skills

Steps

Practice Data

5. Open the folder in which the workbook you want to open is located.

Double-click to open the student data folder

The contents of the folder appear.

6. Select the file name of the workbook you want to open.

Scroll as necessary and click SALES1.XLSX

The file name is highlighted in the list and appears in the File name box.

7. Select the left-hand part of the Open button. The Open dialog box closes and the workbook opens.

Click

U SING D ATA E NTRY S HORTCUTS  D ISCUSSION

Excel includes shortcuts to help you perform certain data entry tasks. The AutoComplete and Pick From Drop-down List features are shortcuts that save you time entering labels into a worksheet.

The AutoComplete feature helps speed up entry into a column containing text by completing the entry after you type a few characters. It is common to have to repeat entries when you are entering text into a column. For a column titled Region , possible entries might include New York , Boston , Chicago , and so on. These entries are likely to be repeated more than once. As you type entries into a column, Excel automatically compiles a list of the entries. When you type the first few letters of a repeated entry in the same column, Excel finishes typing the entry for you. If you do not want to use the entry that Excel suggests, you simply continue typing. The Pick From Drop-down List feature is a quick way to enter text into a column because it allows you to select an entry from a list. Excel automatically compiles a list of the text entries in a column. When activated, the Pick From Drop-down List feature displays a list of the available entries for the active column in alphabetical order. You can then select an entry from the list instead of having to retype each entry.

OFFICEPRO, Inc.

Page 63