MOS Excel: Managing Worksheets & Workbooks 4 — Questions and Answers
Question 1: You right-click a sheet tab and do not see the 'Ungroup Sheets' option. What does this indicate?
- The workbook is protected
- No sheets are currently grouped (Correct answer)
- The sheet is hidden
- You must use the Format menu to ungroup
Correct answer: No sheets are currently grouped
'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?
- Formulas never update even when you press F9
- Formulas only recalculate when you press F9 or save the file (Correct answer)
- Only selected cells recalculate automatically
- Charts update automatically but formulas do not
Correct 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.
Question 3: You accidentally delete a worksheet that was never saved separately. Which option gives you the best chance of recovering it?
- Ctrl+Z (Undo) immediately after deletion (Correct answer)
- File > Info > Manage Workbook > Recover Unsaved Workbooks
- Check the Recycle Bin for the deleted sheet
- Open a previous AutoRecover version from the temp folder
Correct 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.
Question 4: When using 'Save As' to save an .xlsx file as a .csv, what warning does Excel display?
- CSV format does not support multiple worksheets; only the active sheet will be saved (Correct answer)
- CSV will remove all formulas and replace them with values
- Saving as CSV will permanently delete all other sheets
- CSV files cannot be reopened in Excel after saving
Correct 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.
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?
- Quick Access Toolbar shortcut
- Places list in the Save As dialog (Pinned folders) (Correct answer)
- Named Ranges for file paths
- Custom Views
Correct 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.
Question 6: You want the workbook to always open with a specific sheet active. What is the correct approach?
- Set the sheet as default in File > Options > General
- Save and close the workbook with that sheet active (Correct answer)
- Name the sheet 'Sheet1' so Excel defaults to it
- Use Protect Workbook to lock the opening sheet
Correct 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.
Question 7: A colleague reports that your shared workbook shows '#' symbols filling cells instead of numbers. What is the most likely cause?
- The cells contain invalid formulas
- The column is too narrow to display the values (Correct answer)
- The number format is set to Text
- The workbook is in Protected View
Correct 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.
MOS Excel: Managing Worksheets & Workbooks 4
You right-click a sheet tab and do not see the 'Ungroup Sheets' option.
What does this indicate?