Managing Worksheets and Workbooks Flashcards
6 cards from real Microsoft Excel practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 6 Managing Worksheets and Workbooks flashcards as text
A user has several worksheets with identical layouts and wants to apply the same formatting change to all of them simultaneously. Which of the following is the most efficient method to achieve this?
Answer: Group the worksheets together before applying the formatting change.
Grouping worksheets allows you to perform actions, such as formatting, on all selected sheets at once. Any change made to one sheet in the group is automatically applied to all other sheets in the group. This is far more efficient than applying changes to each sheet individually.
You are working with a large dataset and need to view rows at the top of the worksheet (headers) and rows at the bottom of the worksheet (totals) simultaneously. Which feature in Excel allows you to divide the worksheet into different panes that scroll independently?
Answer: Split
The Split command on the View tab divides the worksheet into two or four separate panes, each with its own scroll bars. This allows you to scroll through one pane while keeping another pane, such as the one with headers or totals, visible.
What is the primary purpose of using the 'Protect Workbook' feature in Excel?
Answer: To control the structure of the workbook, such as preventing worksheets from being added, deleted, or renamed.
Protecting the workbook focuses on the workbook's structure. It prevents users from changing the organization of the worksheets by adding, deleting, renaming, moving, hiding, or unhiding them. Protecting a worksheet, in contrast, controls the editing of cell contents within that sheet.
A user wants to create a navigation menu on the first worksheet that links to specific cells in other worksheets within the same workbook. Which is the correct way to configure a hyperlink for this purpose?
Answer: In the Insert Hyperlink dialog, select 'Place in This Document' and then choose the worksheet and enter the cell reference.
To create a link to a specific location within the currently open workbook, you should use the 'Place in This Document' option in the Insert Hyperlink dialog box. This allows you to select a specific worksheet and then type in the cell reference you want to link to.
When using the 'Arrange All' command to view multiple open workbooks, which option will display the windows in an overlapping fashion from top to bottom?
Answer: Cascade
The 'Cascade' option in the Arrange Windows dialog box arranges the open workbook windows so that they overlap, with the title bar of each window remaining visible. Tiled, Horizontal, and Vertical options arrange the windows without overlapping.
A user has hidden several worksheets in a large workbook. To make them visible again, they right-click on a visible sheet tab and select 'Unhide'. What will happen next?
Answer: A dialog box will appear, allowing the user to select only one hidden sheet to unhide at a time.
When you use the 'Unhide' command, Excel displays the Unhide dialog box which lists all hidden sheets. However, the standard functionality only allows you to select and unhide one worksheet at a time from this list. You must repeat the process for each sheet you wish to unhide.