U7:QUIZ 1: SPREADSHEET BASICS

To lock rows at the top of the screen, use the ______ command.

• Freeze Panes

• Lock Panes

• Freeze Rows

• Lock Rows

Orlando would like to compare data in two different areas of the same worksheet. He can use the ______ command to divide the worksheet in two panes.

• Freeze Panes

• Split

• View Side by Side

• Arrange All

Use the ______ Windows command to go back and forth between open workbooks.

• Switch

• Alternate

• Restore

• Change

Tim has several workbooks open in the Excel application. He would like to view them all at the same time, so he should use the ______ command.

• Display All

• View All

• Windows

• Arrange All

When the View Side by Side command is turned on, what other command is also active?

• Synchronous Scrolling

• Asynchronous Scrolling

• Scrolling

• Side-by-Side Scrolling

Sidney is working in a workbook that contains three worksheets. She would like to view the worksheets side by side. To do so, first she must open each worksheet in a ______.

• worksheet tab

• new window

• new file

• dialog box

How many workbook windows does the View Side by Side command allow you to view and compare at the same time?

• 2

• 4

• 5

• 3

Go to the _______ to print files.

• layout view

• backstage view

• design view

• file view

Details about a file are also known as _______.

• metadata

• meta file information

• file information

• data properties

Sam wants to set custom document properties, so he should open the _______.

• Advanced Document Properties

• Custom Document Properties

• Added Document Properties

• Document Settings View