Managing Workbook Properties Answers

15 verified answers4 views
1
Free Preview

Select the correct navigational path to hide a worksheet.

Answers:
Click the tab on the ribbon to the Cells gallery.:Home
Select and use that drop-down menu to select .:Format
Select and use that drop-down menu to select .:Hide & Unhide
2
Free Preview

Font✔ FormatAlignmentConditional Formatting

A
Font
B
✔ Format
C
Alignment
D
Conditional Formatting
3

RenameMove & Copy✔ Hide & UnhideVisibility

A
Rename
B
Move & Copy
C
✔ Hide & Unhide
D
Visibility
5

What is the purpose of the Arrange All command?

A
adds additional columns in a worksheet at once
B
allows you to see multiple workbooks at once
C
allows you to see two parts of the same worksheet side by side
D
allows you to delete multiple workbooks at once
6

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

A
a paintbrush
B
a triangle with an exclamation point inside
C
a lightbulb
D
a circle with a plus sign inside
7

What is the purpose of the Split command?

A
adds additional columns in a worksheet at once
B
allows you to see multiple worksheets at once
C
allows you to see two parts of the same worksheet side by side
D
allows you to delete multiple columns at once
9

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

A
left-clicking and dragging to the correct position
B
right-clicking and selecting Copy
C
typing “move worksheet” in the Tell Me bar
D
clicking the View tab and moving the worksheet
11

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

A
adds additional columns in a worksheet at once
B
allows you to see two parts of the same worksheet side by side
C
syncs the scrolling of each worksheet while you navigate through them
D
allows you to add multiple worksheets at once
12

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

Answers:
Click the tab on the ribbon to enter the gallery.:View
Click the tab on the ribbon to enter the gallery.:Window
Then, select the drop-down menu to freeze the panes.:Freeze Panes
13

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

Answers:
Click the tab on the ribbon to enter the gallery.:View
Click the tab on the ribbon to enter the gallery.:Window
Then, select the drop-down menu to freeze the panes.:Freeze Panes
14

ViewsShowZoom✔ Window

A
Views
B
Show
C
Zoom
D
✔ Window
15

✔ Freeze PanesNew WindowArrange AllLock Panes

A
✔ Freeze Panes
B
New Window
C
Arrange All
D
Lock Panes

Did you find these answers helpful?