Excel 2016 Introduction

Lesson – Using Basic Workbook Skills

Excel 2016

If necessary, select cell A1.

Steps

Practice Data

1. Select the Home tab.

Click Home

The Home tab is displayed.

2. Select Find & Select in the Editing group. The Find & Select menu appears.

Click

3. Select Go To .

Click Go To

The Go To dialog box opens with the insertion point in the Reference box. 4. Enter the address of the cell you want to move to in the Reference box. The text appears in the Reference box.

Type e10

5. Select OK .

Click Enter

or press

The Go To dialog box closes, and the referenced cell is activated.

Practice the Concept: Open the Go To dialog box by pressing [F5] and go to cell AZ25 . Then use [Ctrl+G] to open the Go To dialog box and go to cell A1 . Save file as my_DISTRICT.XLSX and close the file.

E NTERING T EXT INTO C ELLS  D ISCUSSION

In Excel, text is defined as letters or any combination of numbers and letters. For example, Expenses , 2nd Qtr , and BN9847 are all treated as text. Text automatically aligns to the left in a cell. If the text is too long to fit within a cell, the excess characters appear over the next cell to the right, as long as that cell is empty. If text has been entered into the adjacent cell, however, the long text entry appears truncated (i.e., as if the excess characters have been deleted). The characters are not actually deleted; they are visible in the Formula Bar , and they will display in the cell if you widen the column containing the long text entry.

Page 44

OFFICEPRO, Inc.