wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Excel Lesson 3 Review

Total questions: 20

Worksheet time: 10mins

Name
Class
Date
1.

You are tired of typing repetitive data (over and over) again. What can you do?

a)

Print

b)

Fill or Copy

c)

Insert

2.

You want to be sure that all words are spelled correctly in the worksheet. What can you do?

a)

Word Finder

b)

Document Checker

c)

Spell Checker

3.

What do you press while using the Drag and Drop Method?

a)

CTRL key

b)

Shift key

c)

Just hold down the mouse

4.

To move the contents in a cell.

a)

Copy

b)

Fill

c)

Cut

5.

You forgot to type a row of data in the middle of the worksheet.

a)

Insert Sheet Column

b)

Insert Sheet Row

c)

Insert Cell

6.

A portion of the worksheet would be more useful in another area of the worksheet.

a)

Cut & Paste

b)

Copy & Paste

7.

What type of border do you get when you copy or cut data?

a)

Solid border

b)

Green border

c)

Flashing border

8.

The Fill commands are available only if you are copying data to cells adjacent to the original cell.

a)

True

b)

False

9.

Deleting a row or column erases the data in that row or column.

a)

True

b)

False

10.

The black cross in the lower-right corner of the active cell or range that you drag over the cells you want to fill.

a)

Fill Handle

b)

Fill Select

c)

Fill Copy

11.

You no longer need a certain column in the worksheet.

a)

Delete sheet row

b)

Delete sheet column

c)

Insert sheet column

12.

To keep selected rows and / or columns of the worksheet visible on the screen as the rest of the worksheet scrolls.

a)

Split Panes

b)

Freeze Panes

c)

Divide Panes

13.

The Office Clipboard can hold 34 items.

a)

True

b)

False

14.

Which method is used for copying selections short distances?

a)

Cut, Copy, Paste

b)

Fill

c)

Drag and Drop

15.

When using the Drag & Drop Method, your mouse arrow changes to what?

a)

Two headed arrow

b)

Cross

c)

Four headed arrow

16.

Which group on the ribbon can you locate the Insert button?

a)

Clipboard

b)

Font

c)

Cells

d)

Numbers

17.

Which Tab can you locate the Freeze Panes button?

a)

Home

b)

Insert

c)

View

d)

Data

18.

When you freeze panes, you select the row below the one you want to freeze?

a)

True

b)

False

19.

Which Tab can you locate the Spell Check feature?

a)

Home

b)

Insert

c)

Review

d)

View

20.

The Fill Handle copies both the content AND the formatting to an adjacent cell or range.

a)

True

b)

False