Lesson 8 Quiz: Managing Worksheets

How many worksheets can a workbook contain?

• Unlimited

• 10

• 50

• 100

What is the benefit of having multiple worksheets in a workbook that are based on the same form?

• You can hide specific data from view

• You can select and make changes to data once and have it reflected on all sheets

• You can apply different formatting to each worksheet

• You can easily delete unwanted data

Which command allows you to search for specified content in Excel?

• Freeze command

• Zoom command

• Replace command

• Find command

What does the Zoom feature in Excel allow you to do?

• Adjust the display magnification

• Search for data within a workbook

• Hide or unhide worksheets

• Change the color of a worksheet tab

How can you change the color of a worksheet tab in Excel?

• Use the Fill Color tool on the Home tab

• On the Page Layout tab, in the Themes group, select Colors

• Right-click the tab and select Tab Color

• You cannot change the color of a worksheet tab

Which of the following is a method for hiding a single worksheet in a multi-sheet workbook?

• Enter the name of the worksheet in the Hide dialog box

• Select the visible area of the worksheet

• On the View tab, in the Window group, click Hide

• Right-click the worksheet's tab and click Hide

How can you insert a new worksheet into a workbook?

• Click the Insert sheet (+) button to the right of the worksheet tabs

• On the Home tab, click Insert and then click Insert Sheet

• On the Insert tab, click Worksheet

• In the Insert dialog box, click Worksheet and then click OK

What does it mean to freeze panes in Excel?

• To prevent portions of a worksheet from moving on the screen

• To search for data within a workbook

• To change the magnification of the worksheet

• To make a worksheet invisible

Which command allows you to search for specified content and replace any matches in Excel?

• Freeze command

• Zoom command

• Replace command

• Find command

What is the correct procedure to delete one or more worksheets from a workbook?

• Select a group of worksheets, right-click the group, and click Delete

• Press Ctrl+A to select all cells in the worksheet and then press Delete

• Click the Delete down arrow on the Home tab and click Delete Sheet

• Right-click a worksheet tab and click Delete