Excel: Managing Worksheets & Workbooks Flashcards

You need to apply the same header to 8 worksheets at once. What is the most efficient approach?

Answer: Group all sheets, then add the header once in Page Layout view

Grouping sheets before editing applies changes to all grouped sheets simultaneously.

What does the 'Very Hidden' property for a worksheet mean compared to 'Hidden'?

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.

When you freeze panes in Excel, where does the freeze line appear relative to the selected cell?

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.

A workbook contains sensitive data. You want to remove personal information like the author name before sharing. Where is this option?

Answer: File > Info > Check for Issues > Inspect Document

The Document Inspector (File > Info > Check for Issues > Inspect Document) finds and removes personal metadata.

Which AutoSave behavior is true when a workbook is stored on OneDrive?

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.

You want to view two different sections of the same large worksheet simultaneously. Which feature allows this?

Answer: Split

The Split feature divides the worksheet into up to four panes that can scroll independently.

A workbook's file size is unexpectedly large. Which action in File > Info can help identify the cause?

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.