MOS Excel: Managing Worksheets & Workbooks 2 — Questions and Answers
Question 1: You want to move a worksheet to the last position in a workbook with 5 sheets. What is the fastest method?
- Right-click the tab, choose Move or Copy, select '(move to end)'
- Drag the sheet tab to the right of all other tabs (Correct answer)
- Use Ctrl+Shift+End to reposition the sheet
- Press Alt+H then M to move the active sheet
Correct 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.
Question 2: Which keyboard shortcut cycles through all open workbooks in Excel?
- Ctrl+Tab
- Ctrl+W
- Alt+Tab
- Ctrl+F6 (Correct answer)
Correct answer: Ctrl+F6
Ctrl+F6 cycles between open Excel workbook windows.
Question 3: A workbook has a sheet named 'Sales'. You create a copy and both exist in the same workbook. What does Excel name the copy?
- Sales - Copy
- Sales(2)
- Sales (2) (Correct answer)
- Copy of Sales
Correct answer: Sales (2)
Excel names the copied sheet 'Sales (2)' with a space before the parenthesis.
Question 4: You want to prevent users from inserting or deleting worksheets in a workbook. Which option achieves this?
- Sheet Protection with 'Protect Sheet' dialog
- Workbook structure protection via Review > Protect Workbook (Correct answer)
- Marking the workbook as Final
- Setting the workbook to Read-Only
Correct answer: Workbook structure protection via Review > Protect Workbook
Protecting the workbook structure via Review > Protect Workbook prevents users from adding, deleting, or moving sheets.
Question 5: How do you select every worksheet in a workbook simultaneously?
- Ctrl+A while clicking any sheet tab
- Right-click a tab and choose 'Select All Sheets' (Correct answer)
- Shift+click the first and last tab
- Click the first tab, then Ctrl+Shift+End
Correct answer: Right-click a tab and choose 'Select All Sheets'
Right-clicking any sheet tab and choosing 'Select All Sheets' groups all worksheets together.
Question 6: What happens to formulas that reference a worksheet when that sheet is renamed?
- The formulas break and show a #REF! error
- Excel automatically updates the sheet name in all formulas (Correct answer)
- The formulas continue using the old name until manually updated
- Excel prompts you to update references before renaming
Correct answer: Excel automatically updates the sheet name in all formulas
Excel automatically updates all formula references to reflect the new worksheet name.
Question 7: Which view shows a miniature of each workbook page as it will print, allowing you to click and navigate between pages?
- Normal view
- Page Break Preview
- Page Layout view (Correct answer)
- Print Preview
Correct answer: Page Layout view
Page Layout view displays the workbook with page boundaries, headers, and footers visible while still allowing editing.
MOS Excel: Managing Worksheets & Workbooks 2
You want to move a worksheet to the last position in a workbook with 5 sheets.
What is the fastest method?