MOS Excel: Managing Worksheets & Workbooks 3

Question 1

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

Accepted Answer

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

Answer

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'?

Accepted Answer

Very Hidden sheets can only be unhidden via the VBA editor, not through the Format menu

Answer

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?

Accepted Answer

Below and to the right of the selected cell

Answer

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?

Accepted Answer

File > Info > Check for Issues > Inspect Document

Answer

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?

Accepted Answer

AutoSave saves changes continuously in near real-time

Answer

When a workbook is saved to OneDrive or SharePoint, AutoSave saves changes continuously in near real-time.

MOS - Microsoft Office Specialist Certification Practice Test