Excel: Managing Worksheets & Workbooks Flashcards
7 cards from real MOS practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 7 Excel: Managing Worksheets & Workbooks flashcards as text
You want to move a worksheet to the last position in a workbook with 5 sheets. What is the fastest method?
Answer: Drag the sheet tab to the right of all other tabs
Dragging a sheet tab to the desired position is the fastest way to reorder worksheets in Excel.
Which keyboard shortcut cycles through all open workbooks in Excel?
Answer: Ctrl+F6
Ctrl+F6 cycles between open Excel workbook windows.
A workbook has a sheet named 'Sales'. You create a copy and both exist in the same workbook. What does Excel name the copy?
Answer: Sales (2)
Excel names the copied sheet 'Sales (2)' with a space before the parenthesis.
You want to prevent users from inserting or deleting worksheets in a workbook. Which option achieves this?
Answer: Workbook structure protection via Review > Protect Workbook
Protecting the workbook structure via Review > Protect Workbook prevents users from adding, deleting, or moving sheets.
How do you select every worksheet in a workbook simultaneously?
Answer: Right-click a tab and choose 'Select All Sheets'
Right-clicking any sheet tab and choosing 'Select All Sheets' groups all worksheets together.
What happens to formulas that reference a worksheet when that sheet is renamed?
Answer: Excel automatically updates the sheet name in all formulas
Excel automatically updates all formula references to reflect the new worksheet name.
Which view shows a miniature of each workbook page as it will print, allowing you to click and navigate between pages?
Answer: Page Layout view
Page Layout view displays the workbook with page boundaries, headers, and footers visible while still allowing editing.