MOS Excel: Managing Worksheets & Workbooks 4

Question 1

You right-click a sheet tab and do not see the 'Ungroup Sheets' option. What does this indicate?

Accepted Answer

No sheets are currently grouped

Answer

'Ungroup Sheets' only appears in the context menu when multiple sheets are currently grouped.

Question 2

What is the effect of setting a workbook's calculation mode to Manual?

Accepted Answer

Formulas only recalculate when you press F9 or save the file

Answer

In Manual calculation mode, formulas recalculate only when you press F9 or explicitly save the workbook.

Question 3

You accidentally delete a worksheet that was never saved separately. Which option gives you the best chance of recovering it?

Accepted Answer

Ctrl+Z (Undo) immediately after deletion

Answer

Ctrl+Z immediately after deletion is the only reliable way to recover a deleted worksheet within the same session.

Question 4

When using 'Save As' to save an .xlsx file as a .csv, what warning does Excel display?

Accepted Answer

CSV format does not support multiple worksheets; only the active sheet will be saved

Answer

Excel warns that CSV format supports only one sheet, so only the active worksheet will be preserved.

Question 5

Which Excel feature lets you define a name for a specific workbook file location so you can quickly switch between commonly used folders when saving?

Accepted Answer

Places list in the Save As dialog (Pinned folders)

Answer

Pinning folders in the Save As dialog adds them to your Places list for quick access during save operations.

MOS - Microsoft Office Specialist Certification Practice Test