wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Excel Lesson 7-Lesson 8

Total questions: 29

Worksheet time: 15mins

Name
Class
Date
1.

Virgil needs to transfer a worksheet in the current workbook to a different workbook. Which command should he choose?

a)

Insert

b)

Move

c)

Rename

d)

Tab Color

2.

John would like to change the order of the worksheets in his workbook. Which option would he choose?

a)

Insert

b)

Delete

c)

Copy

d)

Move

3.

How is an exact copy of a worksheet created within the same workbook?

a)

Choose Move or Copy from the Quick Access Toolbar

b)

Right-click the sheet tab, then choose Move or Copy from the Shortcut Menu

c)

While pointing to the sheet tab, choose Copy from the Shortcut Menu

d)

While pointing to the Select All button, choose Move or Copy from the Shortcut Menu

4.

Jack would like the data in Row 1 to remain stationary on the screen while he scrolls. Which option should he select?

a)

Freeze

b)

Header

c)

Hide

d)

Scale

5.

David wants to change all occurrences of "North Carolina" to "NC" in his spreadsheet. What command should he use to complete this task?

a)

AutoFill

b)

Filter

c)

Find and Replace

d)

Sort

6.

How would you move sheet tabs to a new position in the workbook?

a)

Choose Move on the Home Ribbon.

b)

Click and drag the sheet tab to the new location.

c)

Choose Move on the Insert Ribbon.

d)

Choose Relocate on the Quick Access Toolbar.

7.

Virgil wants to customize the sheet tabs in his workbook with the names June, July, and August. Which command should he choose?

a)

Insert

b)

Move

c)

Rename

d)

Tab Color

8.

What is a single character, word, or phrase in a cell on a worksheet that is typically used in searches?

a)

Text

b)

String

c)

Thread

d)

Key

9.

What feature of Microsoft Excel keeps a portion of a worksheet visible while the other portion scrolls?

a)

Freeze Panes

b)

Rotate

c)

Select

d)

Zoom

10.

Which command on the Home Ribbon do you use to replace information in a selected cell with new information or new formatting?

a)

Cell Styles

b)

Font

c)

Format Cell

d)

Find & Select

11.

Joan wants to be able to view row 1 as well as column A while scrolling through her worksheet. Which option should she choose?

a)

Freeze

b)

Hide

c)

Page Break

d)

Split

12.

Virgil wants to emphasize the sheet tabs in his workbook. Which command should he choose?

a)

Insert

b)

Move

c)

Rename

d)

Tab Color

13.

John would like to remove a worksheet from his workbook. Which option would he choose?

a)

Copy

b)

Delete

c)

Insert

d)

Move

14.

Which term describes the blank portions of a page that fall outside the main body of the printed document?

a)

Borders

b)

Edges

c)

Frames

d)

Margins

15.

Jim would like the data in Row 1 of his spreadsheet to repeat on every page of his printout. What page setup option should he change?

a)

Orientation

b)

Page Break

c)

Print Area

d)

Print Titles

16.

Jack would like to force the data in his spreadsheet to fit on one page when printed. Which option should he select?

a)

Freeze

b)

Header

c)

Hide

d)

Scale

17.

Jack would like the data in Row 10 not to display on his spreadsheet. Which option should he select?

a)

Freeze

b)

Header

c)

Hide

d)

Scale

18.

Which set of formatting choices includes a set of colors, fonts, and effects that you can apply to a worksheet to enhance its appearance?

a)

Layout

b)

Template

c)

Theme

d)

Design

19.

In Microsoft Excel, what do you use to emphasize certain entries and make the worksheet easier to read and understand?

a)

Formatting

b)

Printing

c)

Arranging

d)

Configuring

20.

John notices that column D is not showing on his spreadsheet. What action does he need to take to view column D?

a)

Freeze Panes

b)

Split

c)

Hide

d)

Unhide

21.

Joan is showing her spreadsheet to a customer and does not want the customer to be able to see the wholesale prices column. What option should she choose?

a)

Freeze

b)

Split

c)

Page Break

d)

Hide

22.

John's spreadsheet includes multiple pages of records. If John wants to view his headings while scrolling through his spreadsheet what should he do?

a)

Hide

b)

Unhide

c)

Freeze Panes

d)

Split

23.

What command do you use to insert information into a worksheet that will display at the top and bottom edges of the printed page?

a)

Header & Footer

b)

Margins

c)

Print Titles

d)

Page Setup

24.

Which ribbon contains the command to apply a theme to a worksheet in Microsoft Excel?

a)

Home

b)

Page Layout

c)

Data

d)

View

25.

Which command on the Page Layout Ribbon enables a user to mark where a new page will begin on the printed copy?

a)

Background

b)

Breaks

c)

Effects

d)

Print Area

26.

Which command on the Home Ribbon do you use to remove cells, rows, or columns from a worksheet or table?

a)

Delete

b)

Remove

c)

Format

d)

Format As Table

27.

Which command do you use to remove manual page breaks from a worksheet area?

a)

Select break, press Delete on keyboard

b)

Select break, press Backspace on keyboard

c)

Select break, press Remove Page Break from Shortcut Menu

d)

Select Remove Page Break from the Breaks drop-down area

28.

Which command on the Home Ribbon do you use to format row height and column width, organize sheets, and protect or hide cells in a worksheet?

a)

Insert

b)

Form

c)

Sort & Filter

d)

Format

29.

Which command group on the Page Layout Ribbon controls the presence of gridlines and headings on a worksheet?

a)

Themes

b)

Page Setup

c)

Sheet Options

d)

Arrange