Managing Workbook Properties

Which items can be included in a custom view? Check all that apply.

Print Settings Hidden Rows and Columns Display Options Dimensions of Rows and Columns

What does the icon look like to add a new worksheet to the current workbook?

a circle with a plus sign inside

What is the purpose of the Split command?

allows you to see two parts of the same worksheet side by side

Put the directions in order

Click the File Tab Enter the Backstage View Select Advance Properties Select Custom Tab

Select the correct navigational path to hide a worksheet.

Home Format Hide & Unhide

What is the purpose of the New Window command?

It opens one of the current worksheets into a new window.

The Arrange All function is used to organize multiple open workbooks at once. Select the correct navigational path to use the Arrange All function.

View Window Arrange All

Select the correct navigational path to freeze the top row of your worksheet.

View Windows Freeze Panes

Selena wants to view multiple worksheets and scroll through them at the same time. What tool should she use?

View Side by Side

What is the purpose of the Arrange All command?

allows you to see multiple workbooks at once

What is the easiest way to reorder the worksheet tabs at the bottom of your Excel workbook?

left-clicking and dragging to the correct position

What is the special feature of the View Side by Side command?

syncs the scrolling of each worksheet while you navigate through them

Which items can be found in the Properties section of the Backstage View? Check all that apply.

Author of Document Size Title Last Modified Timestamp

What is the technical term for the information found in the Properties section?

Metadata

What is the shortcut to switch back and forth between windows?

Tab + Windows