MOS Excel: Managing Worksheets & Workbooks 3 — Questions and Answers
Question 1: You need to apply the same header to 8 worksheets at once. What is the most efficient approach?
- Copy the header from one sheet and paste special to the others
- Group all sheets, then add the header once in Page Layout view (Correct answer)
- Use a macro to loop through each sheet
- Manually add the header to each sheet individually
Correct answer: Group all sheets, then add the header once in Page Layout view
Grouping sheets before editing applies changes to all grouped sheets simultaneously.
Question 2: What does the 'Very Hidden' property for a worksheet mean compared to 'Hidden'?
- Very Hidden sheets cannot be printed even when unhidden
- Very Hidden sheets can only be unhidden via the VBA editor, not through the Format menu (Correct answer)
- Very Hidden sheets are password protected by default
- Very Hidden prevents the sheet from being copied to another workbook
Correct answer: Very Hidden sheets can only be unhidden via the VBA editor, not through the Format menu
A 'Very Hidden' sheet (xlSheetVeryHidden) cannot be unhidden through the standard Format menu — only through the VBA editor.
Question 3: When you freeze panes in Excel, where does the freeze line appear relative to the selected cell?
- Below and to the right of the selected cell (Correct answer)
- Above and to the left of the selected cell
- Only below the selected cell
- Only to the right of the selected cell
Correct answer: Below and to the right of the selected cell
Freeze Panes freezes all rows above and all columns to the left of the currently selected cell.
Question 4: A workbook contains sensitive data. You want to remove personal information like the author name before sharing. Where is this option?
- File > Info > Check for Issues > Inspect Document (Correct answer)
- Review > Protect Workbook > Remove Personal Info
- File > Options > General > Remove Personal Info
- Home > Format > Remove Properties
Correct answer: File > Info > Check for Issues > Inspect Document
The Document Inspector (File > Info > Check for Issues > Inspect Document) finds and removes personal metadata.
Question 5: Which AutoSave behavior is true when a workbook is stored on OneDrive?
- AutoSave saves every 10 minutes by default
- AutoSave saves changes continuously in near real-time (Correct answer)
- AutoSave only triggers when the workbook is closed
- AutoSave is disabled for cloud-stored files
Correct answer: AutoSave saves changes continuously in near real-time
When a workbook is saved to OneDrive or SharePoint, AutoSave saves changes continuously in near real-time.
Question 6: You want to view two different sections of the same large worksheet simultaneously. Which feature allows this?
- Freeze Panes
- Split (Correct answer)
- New Window with Arrange All
- Zoom to Selection
Correct answer: Split
The Split feature divides the worksheet into up to four panes that can scroll independently.
Question 7: A workbook's file size is unexpectedly large. Which action in File > Info can help identify the cause?
- Inspect Document to check for hidden rows/sheets (Correct answer)
- Check Compatibility to find size-heavy features
- Manage Workbook to review unsaved versions
- View Permissions to check linked data sources
Correct answer: Inspect Document to check for hidden rows/sheets
The Document Inspector can reveal hidden worksheets, rows, columns, and other data that may inflate file size.
MOS Excel: Managing Worksheets & Workbooks 3
You need to apply the same header to 8 worksheets at once.
What is the most efficient approach?