Workbook Options, Protection, and Application Settings
What this domain actually tests
Questions here are about location and intent, not about building content. You need to know exactly where each setting lives and what it does and does not protect.
Protection options. Excel offers four distinct protections and questions love to blur them:
- Protect Sheet (Review > Protect Sheet) locks cells and objects on one worksheet and optionally allows specific actions such as selecting locked cells or formatting rows.
- Protect Workbook > Structure prevents inserting, deleting, renaming, moving, hiding, or unhiding worksheets.
- Protect Workbook > Windows freezes window size and position (largely legacy).
- Encrypt with Password applies a real open-password to the file; Mark as Final only makes the file read-only until someone clicks Edit Anyway - it is not security.
Application and workbook settings. Use File > Options for the Quick Access Toolbar, Ribbon customization, default font and sheet count, AutoRecover interval, and the default personal template location. Calculation mode lives under Formulas > Calculation Options (Automatic, Automatic Except for Data Tables, Manual); F9 recalculates all open workbooks, Shift+F9 the active sheet only. Add-ins are managed through File > Options > Add-ins, and macro/ActiveX behavior through Trust Center Settings. Advanced document properties are found at File > Info > Properties > Advanced Properties.
Traps to expect. (1) Confusing sheet protection with workbook-structure protection. (2) Assuming Mark as Final prevents editing. (3) Forgetting that a Manual calculation setting persists with the workbook and makes formulas appear "stale." (4) Mixing up the open password with the weaker password to modify.
Rule of thumb: ask "what is the user trying to stop?" - stopping tab-level changes means Protect Workbook Structure; stopping cell-level changes means Protect Sheet; stopping the file from opening means Encrypt with Password.