Excel: Managing Worksheets & Workbooks Flashcards

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

Answer: No sheets are currently grouped

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

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

Answer: Formulas only recalculate when you press F9 or save the file

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

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

Answer: Ctrl+Z (Undo) immediately after deletion

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

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

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

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

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?

Answer: Places list in the Save As dialog (Pinned folders)

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

You want the workbook to always open with a specific sheet active. What is the correct approach?

Answer: Save and close the workbook with that sheet active

Excel reopens a workbook with the same sheet active as when it was last saved and closed.

A colleague reports that your shared workbook shows '#' symbols filling cells instead of numbers. What is the most likely cause?

Answer: The column is too narrow to display the values

##### symbols appear when a column is too narrow to display the numeric or date value.