Excel 2016 Introduction

Excel 2016

Lesson – Using Basic Workbook Skills



S TEP - BY -S TEP Enter numbers into the cells of a worksheet.

Steps

Practice Data

1. Select the cell into which you want to enter a number. The cell you select becomes the Active Cell .

Click cell D5

2. Type the desired number. The number appears in the

Type 1819

Formula Bar and in the Active Cell .

3. Press [Enter] .

Press [Enter]

The number is entered into the selected cell and the next cell down becomes the Active Cell . 4. Enter numbers into additional cells as desired. The numbers appear in the corresponding worksheet cells.

Follow the instructions shown below the table to complete this step

Fill in the data shown in the following table:

A

B

C

D

1

Worldwide Sporting Goods

2

Sales Report

3

4

Sales Reps

Last Name

First Initial

5

Smith, S.

1819

6

Brown, N.

1726

7

Jones, P.

2009

8

Adams, G.

1948

OFFICEPRO, Inc.

Page 49