Excel 2016 Tips and Tricks

Lesson 2 – Working with Tables

Excel 2016



P ROCEDURES

1. Select the last data cell in the table. 2. Press [Tab] . 3. Enter the desired data in the cell. 4. Press [Tab] . 5. Continue entering the row data.



S TEP - BY -S TEP

Add new rows of data.

Open the file: TABLEA.XLS

Steps

Practice Data

1. Select the last data cell in the table. The cell is selected.

Click cell H23

2. Press [Tab] .

Press [Tab]

A new row is added to the table and the first cell in the new row is selected. 3. Enter the desired data in the cell. The data appears in the selected cell.

Type Gina Mann

4. Press [Tab] .

Press [Tab]

The entry is confirmed and the next cell in the row is selected.

5. Continue entering the row data. The data appears in the row.

Follow the instructions below to complete this step

Enter the following data, pressing [Tab] after each entry except the last. Press [Enter] to confirm the last entry.

B

C

D

E

F

G

H

Central

Jul

2007

2500 Golf Balls

SportsCity

Joe Marks

Southwes t

Apr

2007

1850 Gloves

SportsCity

Page 34

OFFICEPRO, Inc.