Module 1 Test: Manage Workbook Options and Settings

Course: MO-211: Microsoft Excel Expert Topic: Comprehensive review of Lessons 1.1 – 1.9

Section A: Lesson 1.1 — Copying Macros Between Workbooks

Q1. Practical Application

You are working in the Visual Basic Editor (VBE) and need to move a macro from Report_A.xlsm to Report_B.xlsm. You decide to use the Drag-and-Drop method. Which specific item do you click and drag in the Project Explorer? - A) The VBAProject (Report_A.xlsm) folder icon. - B) The specific Sub MacroName() line in the code window. - C) The specific Module name (e.g., Module1) within the Modules folder. - D) The Microsoft Excel Objects folder.

Q2. File Extensions

You have successfully copied a complex automation script into a new, blank workbook. You save the file as Final_Analysis.xlsx. When you reopen the file the next morning, the macro is gone. Why? - A) The VBE was not closed before saving the file. - B) Standard .xlsx files do not support VBA storage and strip macros upon saving. - C) The macro was not "compiled" before the file was closed. - D) The file was saved in a "Read-Only" directory.

Q3. Individual Script Management

A colleague sends you a workbook with a module containing 20 different macros. You only need one specific macro for your project. What is the most efficient way to get only that code into your workbook? - A) Drag-and-Drop the entire module and delete the 19 macros you don't need. - B) Export the module as a .bas file and import it. - C) Open the code window, highlight the specific Sub to End Sub block, copy it, and paste it into a module in your workbook. - D) Use the "Share Macro" feature in the Developer Tab.

Q4. Naming Conflicts

You drag Module1 from a source file into a destination file that already contains a module named Module1. How does Excel resolve this? - A) It overwrites the existing code in the destination file. - B) It automatically renames the new module to Module11. - C) It merges the code from both modules into one. - D) It displays an error message and cancels the transfer.

Q5. True or False

The .bas file format is used when exporting a module to be saved as a standalone file on your computer. (True / False)

Q6. True or False

You can drag an individual Sub-routine (macro) directly from the code window of one workbook into the Project Explorer of another. (True / False)

Section B: Lesson 1.2 — External References

Q7. Creating Large-Scale Links

You need to link a summary table (Range A1:G50) from a source workbook into a destination report. Which method is most efficient for transferring this entire block while ensuring Excel creates all 350 individual links automatically? - A) Typing the manual syntax for each cell. - B) Using the Point-and-Click method for the first cell and dragging the fill handle. - C) Copying the range in the source and using Paste Link in the destination. - D) Using the Consolidate Data tool in the Data tab.

Q8. Managing Broken Links

A source workbook has been moved to a different folder, causing your report formulas to return #REF! errors. Which button in the Edit Links dialog box should you use to point Excel to the file's new location? - A) Update Values - B) Check Status - C) Change Source - D) Open Source

Q9. Closed-Workbook Syntax

Which formula correctly references workbook Expenses 2026.xlsx while the file is closed? - A) =[Expenses 2026.xlsx]Sheet1!$A$1 - B) ='C:\Users\Admin\Documents\[Expenses 2026.xlsx]Sheet1'!$A$1 - C) =Expenses 2026.xlsx!Sheet1!$A$1 - D) ='[Expenses 2026.xlsx]Sheet1'!$A$1

Q10. True or False

Breaking a link via the Edit Links dialog can be reversed by pressing Ctrl + Z (Undo). (True / False)

Section C: Lesson 1.3 — Macro Security & Trust Center

Q11. Default Security State

When you open a macro-enabled workbook (.xlsm) for the first time on a standard Excel installation, what is the default behavior? - A) The macros run immediately without any prompts. - B) Excel displays a yellow Message Bar stating "SECURITY WARNING: Macros have been disabled." - C) Excel permanently deletes the VBA code for security. - D) A pop-up window forces you to password-protect the workbook.

Q12. Trusted Locations

You have a folder (C:\CompanyReports\) where 50 macro-enabled files live. You want to stop the "Enable Content" prompt for every file in this directory. What is the correct solution? - A) Change the global setting to "Enable all macros." - B) Add the CompanyReports folder as a Trusted Location. - C) Move all files to the Downloads folder. - D) Re-save all files as standard .xlsx workbooks.

Q13. VBA Project Access

A specialised add-in programmatically modifies VBA code in your workbooks but fails to function. Which specific Macro Setting must be enabled? - A) Disable Excel 4.0 macros when VBA macros are developed. - B) Trust access to the VBA project object model. - C) Require Trusted Publishers for all Add-ins. - D) Enable all macros.

Q14. True or False

For maximum security, it is a best practice to set your computer's Downloads folder as a Trusted Location. (True / False)

Section D: Lesson 1.4 — Workbook Versions

Q15. Recovering a Crashed Session

Excel crashed before you saved your work on a local .xlsx. Which path opens the folder containing the AutoRecover drafts? - A) File > Save As > Browse - B) File > Info > Manage Workbook > Recover Unsaved Workbooks - C) File > Options > Save > Open - D) Review > Track Changes > Restore

Q16. Configuring AutoRecover Frequency

You want Excel to save AutoRecover information every 2 minutes for a critical model. Where is this setting? - A) File > Info > Protect Workbook - B) File > Options > Save - C) File > Options > Advanced - D) Review > Workbook Statistics

Q17. Where Version History Lives

A colleague says they "rolled back to last Tuesday's version" of a shared workbook. Which storage location is required for full Version History to be available in the title bar? - A) A USB stick mapped as drive E: - B) Local Documents folder - C) OneDrive or SharePoint - D) A network share over SMB without OneDrive sync

Q18. Restore vs. Save a Copy

In Version History, what is the difference between Restore and Save a Copy? - A) Restore replaces the current file with the older version; Save a Copy keeps both. - B) Save a Copy replaces the current file; Restore makes a duplicate. - C) They are aliases for the same action. - D) Save a Copy requires admin permission, Restore does not.

Q19. AutoRecover File Extension

Which file extension does Excel use for AutoRecovery drafts? - A) .xlsx - B) .xlsb - C) .asb - D) .tmp

Q20. True or False

Version History keeps cloud-stored versions for a longer retention period than local AutoRecover keeps unsaved drafts. (True / False)

Q21. True or False

The Keep the last AutoRecovered version if I close without saving checkbox should be left on for safety. (True / False)

Section E: Lesson 1.5 — Restrict Editing

Q22. Mark as Final Behavior

A workbook has been Marked as Final. A user opens it. Which statement is correct? - A) The user cannot open the file without a password. - B) The Ribbon is collapsed and editing is discouraged, but the user can click Edit Anyway to bypass. - C) The file silently deletes itself after one read. - D) The user must have IRM credentials to view it.

Q23. The Right Tool for "Open as Read-Only"

You want every recipient prompted: "Open as read-only?" whenever they double-click the file. Which option do you set? - A) File > Info > Protect Workbook > Mark as Final - B) File > Info > Protect Workbook > Always Open Read-Only - C) Review > Protect Sheet - D) Review > Protect Workbook

Q24. Encryption Risk

Which warning is true about Encrypt with Password under File > Info > Protect Workbook? - A) Microsoft Support can recover lost passwords on request. - B) The password can be reset by reinstalling Excel. - C) If the password is lost, the data is effectively gone — Microsoft cannot recover it. - D) The password is stored in the document properties and visible to anyone.

Q25. IRM Permission Levels

Under Restrict Access (Information Rights Management), which two permission levels are available? - A) Read and Change - B) View and Comment - C) Owner and Guest - D) Public and Private

Q26. Choosing the Right Restriction

You need to lock a financial model so that only members of the Finance group can edit it on their own computers, with no shared password. Which option fits? - A) Mark as Final - B) Always Open Read-Only - C) Restrict Access (IRM) - D) Encrypt with Password

Q27. True or False

Mark as Final is a security feature that prevents editing under all circumstances. (True / False)

Q28. True or False

Encrypt with Password prevents the file from being opened at all without the correct password. (True / False)

Section F: Lesson 1.6 — Protect Worksheet and Cell Ranges

Q29. The Two-Step Workflow

You select cells B2:B20, uncheck Locked in Format Cells > Protection, but users still cannot edit those cells. Why? - A) The cells need to be merged. - B) Protect Sheet has not been turned on; locking has no effect until then. - C) Excel needs a restart. - D) Locked cannot be unchecked once set.

Q30. Hiding Formulas

You want users to see results but not the formulas behind them. Which combination of attributes do you set on the formula cells, then what do you do? - A) Locked off + Hidden on, then Protect Sheet - B) Locked on + Hidden on, then Protect Sheet - C) Locked on + Hidden off, then Protect Workbook - D) Locked off + Hidden off, then Protect Sheet

Q31. Allow Edit Ranges Sequence

You want different teams to edit different ranges, each with its own password, on the same protected sheet. In what order do you act? - A) Protect Sheet first, then add ranges via Allow Edit Ranges - B) Define ranges in Allow Edit Ranges, then click Protect Sheet from inside that dialog - C) Encrypt the workbook, then assign passwords per range - D) Protect Workbook Structure, then unlock specific cells

Q32. AutoFilter Permission Caveat

You ticked Use AutoFilter in the Protect Sheet permissions, but users still can't filter. Why? - A) AutoFilter dropdowns must already be present on the sheet before protection is applied. - B) AutoFilter requires a paid add-in. - C) AutoFilter only works on Excel Tables. - D) The sheet password must be removed first.

Q33. Default Locked State

Which statement about cell locking is true? - A) Cells are unlocked by default; you must lock the ones you want protected. - B) Cells are locked by default; you must unlock the ones you want users to edit. - C) Locking is randomised when a sheet is created. - D) Locking only applies to numeric cells.

Q34. Lost Password

You have forgotten the password used to protect a critical worksheet. What does Microsoft offer? - A) A 24-hour recovery service via support ticket. - B) A Reset Password button on the Review tab. - C) No built-in recovery tool — the only sanctioned options are restoring an earlier version or rebuilding. - D) A free utility on the Microsoft Store.

Q35. True or False

The Hidden attribute in Format Cells > Protection is a strong cryptographic protection that prevents anyone from ever seeing the formula. (True / False)

Section G: Lesson 1.7 — Protect Workbook Structure

Q36. What Structure Protection Blocks

With Protect Workbook (Structure) enabled, which action is disabled? - A) Editing a cell value - B) Renaming a worksheet tab - C) Saving the workbook - D) Applying conditional formatting

Q37. Hidden Sheet Strategy

You hide Calc and Mappings sheets, then turn on Protect Workbook Structure. What does a user see when they right-click a tab? - A) Unhide... is enabled and shows your sheets. - B) Unhide... is greyed out — hidden sheets cannot be revealed without unprotecting first. - C) Hidden sheets are deleted. - D) The right-click menu disappears entirely.

Q38. The Path

Where do you turn on Workbook Structure protection? - A) File > Info > Protect Workbook > Encrypt with Password - B) Review > Protect > Protect Workbook - C) Data > Data Tools > Protect - D) Insert > Protection

Q39. Macro That Inserts a Sheet

A macro that adds a new sheet errors out on a structure-protected workbook. What is the correct fix? - A) Switch the workbook to manual calculation. - B) Have the macro Unprotect at the start and re-Protect at the end. - C) Convert all sheets to Tables first. - D) Save the file as .xlsb.

Q40. True or False

Protect Workbook Structure prevents users from editing data in any cell on any sheet. (True / False)

Section H: Lesson 1.8 — Formula Calculation Options

Q41. The Right Mode for a Massive Model

Your model has 200,000 formulas; every edit causes a 5-second "Calculating" pause. Which calculation mode helps? - A) Automatic - B) Automatic Except for Data Tables - C) Manual - D) Iterative

Q42. Recalculate Now Shortcut

In Manual mode, which key recalculates every open workbook? - A) F9 - B) Shift + F9 - C) Ctrl + Alt + F9 - D) Ctrl + S

Q43. Recalculate Active Sheet Only

Which key recalculates only the active worksheet (faster for large files)? - A) F9 - B) Shift + F9 - C) Ctrl + Alt + F9 - D) Alt + F9

Q44. Iterative Calculation Settings

A pricing model has a deliberate circular reference. Which two settings under File > Options > Formulas > Enable iterative calculation does the exam typically ask you to configure? - A) Calculation mode and decimal places - B) Maximum iterations and Maximum change - C) Number format and Precision - D) Iterations and AutoRecover interval

Q45. Precision as Displayed Risk

Which warning is correct about Set precision as displayed? - A) The change is purely cosmetic and reversible. - B) The change is permanent — Excel deletes the hidden decimal data and you cannot retrieve it later. - C) It applies only to negative numbers. - D) It requires admin rights.

Q46. The Status Bar Cue

In Manual mode, where does Excel tell you that formulas are "stale" (data has changed but not been recalculated)? - A) A red border around the cell - B) The message Calculate in the status bar (bottom-left) - C) A pop-up dialog every 30 seconds - D) A tab indicator in the ribbon

Q47. True or False

Calculation mode is workbook-specific — opening a Manual workbook does not affect other open workbooks. (True / False)

Section I: Lesson 1.9 — Inspect Workbook

Q48. Document Inspector Categories

Which of the following does the Document Inspector flag? - A) Spelling errors in cell values - B) Hidden worksheets and personal information in document properties - C) Circular references - D) Slow-running formulas

Q49. Compatibility Checker Severity Tiers

What are the two severity tiers reported by the Compatibility Checker? - A) Critical and Trivial - B) Significant loss of functionality and Minor loss of fidelity - C) Errors and Warnings only - D) Red and Yellow

Q50. Accessibility Issues

Which of these is not typically flagged by the Accessibility Checker? - A) Image without alt text - B) Default sheet name like Sheet1 - C) Merged cells inside a data region - D) A cell with a #DIV/0! error

Q51. Pre-Release Sequence

You want to prepare a workbook for external release. In what order should you run the three checkers? - A) Inspect Document → Check Compatibility → Check Accessibility - B) Check Compatibility → Inspect Document → Check Accessibility - C) Check Accessibility → Check Compatibility → Inspect Document - D) Order does not matter

Q52. Saving as `.xls`

What happens to a workbook that uses XLOOKUP and dynamic-array spills when you save it as Excel 97-2003 Workbook (*.xls)? - A) The formulas continue to work because Excel transparently translates them. - B) The formulas are converted to #NAME? errors and rows beyond 65,536 are truncated. - C) The formulas are removed but the result values remain. - D) Excel refuses to save the file.

Q53. Removing Inspector Findings

After running Inspect Document, you click Remove All next to Hidden Worksheets. What is true? - A) The action is reversible with Ctrl + Z. - B) The action is not undoable; hidden sheets are deleted permanently. - C) The hidden sheets are moved to a backup file. - D) Excel emails you a recovery link.

Q54. True or False

The Accessibility Checker can be set to run in real-time and surface its status in the Excel status bar. (True / False)

Q55. True or False

Saving to .xls does not require running the Compatibility Checker — Excel handles legacy conversion silently. (True / False)

Section J: Hands-On Micro-Tasks (across Module 1)

Treat each task like a real exam project file. Steps are in the answer key.

T1. Macro relocation. Open Source.xlsm and Destination.xlsm. Move the entire Module1 containing macro RebuildReport from the source to the destination using the VBE Project Explorer. Save the destination workbook so the macro is preserved on disk.

T2. AutoRecover and Version History. On BudgetModel.xlsx (saved on OneDrive), reduce the AutoRecover interval to 3 minutes. Then open Version History and Save a Copy of the version from yesterday as BudgetModel_BeforeEdits.xlsx.

T3. Layered Editing Restrictions. Open Q4_Forecast.xlsx. Apply two restrictions: (a) encrypt the file with password Forecast!2026, and (b) Mark as Final. Verify both icons are visible under File > Info.

T4. Sheet Protection With An Editable Input Range. On OrderForm.xlsx, the user must be able to edit B5:B20 and use the existing AutoFilter on the data table, but should not be able to edit any other cell or rename any sheet. Apply both worksheet protection (with the right Allow checklist) and workbook structure protection.

T5. Iterative Calculation Setup. On LoanInterest.xlsx, enable iterative calculation with a maximum of 500 iterations and a maximum change of 0.0001.

T6. Pre-Release Inspection. On Quarterly_Review.xlsx, run all three checkers in sequence: Accessibility (fix every Error), Compatibility against Excel 2010 (note any significant loss), then Document Inspector (remove personal information and hidden worksheets). Save the cleaned workbook as Quarterly_Review_Public.xlsx.

Show answers

## Sections A–C — Lessons 1.1–1.3 Answer Key | # | Answer | Explanation | | :--- | :--- | :--- | | **Q1** | **C** | Drag-and-drop works at the **Module** level, not the project or individual `Sub` level. | | **Q2** | **B** | `.xlsx` strips macros on save. Always use `.xlsm` or `.xlsb` for VBA-bearing workbooks. | | **Q3** | **C** | To extract a single `Sub`, copy/paste the text of that procedure. Drag-and-drop moves whole modules. | | **Q4** | **B** | Excel auto-renames the imported module (e.g., `Module1` becomes `Module11`) to avoid overwriting. | | **Q5** | **True** | `.bas` (Basic) is the export format for a single VBA module. | | **Q6** | **False** | Only modules can be dragged in the Project Explorer. To move a single procedure, copy/paste text. | | **Q7** | **C** | **Paste Link** is the canonical efficient method to create many cell links from a copied range. | | **Q8** | **C** | **Change Source** in the Edit Links dialog repoints a link to the file's new location. | | **Q9** | **B** | A **closed** external workbook reference requires the full path inside single quotes if names have spaces. | | **Q10** | **False** | Breaking a link is permanent — it flattens formulas to static values and cannot be undone. | | **Q11** | **B** | The default Trust Center setting is "Disable all macros with notification" — the yellow message bar. | | **Q12** | **B** | A **Trusted Location** allows every file in that folder to bypass the security warning. | | **Q13** | **B** | "Trust access to the VBA project object model" is the specific switch that lets add-ins read/write VBA code. | | **Q14** | **False** | Never trust Downloads — it's the primary entry point for files of unknown origin. | ## Section D — Lesson 1.4 Answer Key | # | Answer | Explanation | | :--- | :--- | :--- | | **Q15** | **B** | **File > Info > Manage Workbook > Recover Unsaved Workbooks** opens the AutoRecover folder. | | **Q16** | **B** | **File > Options > Save** is where the AutoRecover interval (default 10 min) is configured. | | **Q17** | **C** | Full Version History is only available for files stored on **OneDrive** or **SharePoint**. | | **Q18** | **A** | **Restore** overwrites the current version; **Save a Copy** extracts the old version as a new file. | | **Q19** | **C** | AutoRecover drafts use the `.asb` extension. | | **Q20** | **True** | Cloud Version History keeps versions for months; AutoRecover unsaved drafts are short-lived. | | **Q21** | **True** | Keeping the last AutoRecovered version is the safety net for accidental "Don't Save" clicks. | ## Section E — Lesson 1.5 Answer Key | # | Answer | Explanation | | :--- | :--- | :--- | | **Q22** | **B** | Mark as Final discourages editing but is bypassable — the user can click **Edit Anyway**. | | **Q23** | **B** | **Always Open Read-Only** is the dedicated File > Info option that triggers the read-only prompt. | | **Q24** | **C** | Lost passwords cannot be recovered by Microsoft. The data is effectively gone. | | **Q25** | **A** | IRM provides two permission levels: **Read** and **Change**. | | **Q26** | **C** | **Restrict Access (IRM)** maps to specific user identities — the right tool for per-user editing rights. | | **Q27** | **False** | Mark as Final is a communication signal, not a security feature. **Edit Anyway** bypasses it. | | **Q28** | **True** | Encrypt with Password requires the password before the workbook can be opened at all. | ## Section F — Lesson 1.6 Answer Key | # | Answer | Explanation | | :--- | :--- | :--- | | **Q29** | **B** | The Locked attribute has no effect until **Protect Sheet** is turned on. | | **Q30** | **B** | To hide formulas: keep cells **Locked**, also tick **Hidden**, then **Protect Sheet**. | | **Q31** | **B** | Define ranges in **Allow Edit Ranges** first, then click **Protect Sheet** from inside that dialog. | | **Q32** | **A** | The AutoFilter dropdowns must already exist before protection — protection cannot create new filters. | | **Q33** | **B** | Cells are **Locked** by default. You unlock the input cells before turning on protection. | | **Q34** | **C** | Excel offers no built-in password recovery. Restore from version history or rebuild. | | **Q35** | **False** | Hidden is a UI-only feature. A determined user can copy the cell elsewhere or read it via VBA. | ## Section G — Lesson 1.7 Answer Key | # | Answer | Explanation | | :--- | :--- | :--- | | **Q36** | **B** | Structure protection blocks tab actions: insert/delete/rename/hide/unhide/move sheets. | | **Q37** | **B** | With structure protected, **Unhide...** is greyed out — the hidden sheet strategy works. | | **Q38** | **B** | **Review > Protect > Protect Workbook** is the canonical path. | | **Q39** | **B** | Macros that mutate workbook structure must `Unprotect` at start and `Protect` at end. | | **Q40** | **False** | Structure protection blocks tab actions, **not** cell editing. Use Protect Sheet for cell-level locking. | ## Section H — Lesson 1.8 Answer Key | # | Answer | Explanation | | :--- | :--- | :--- | | **Q41** | **C** | **Manual** mode prevents the recalculation pause on every edit; you trigger calc on demand. | | **Q42** | **A** | `F9` recalculates every formula in every open workbook. | | **Q43** | **B** | `Shift + F9` recalculates only the active worksheet. | | **Q44** | **B** | Iterative calculation has two configurable parameters: **Maximum iterations** and **Maximum change**. | | **Q45** | **B** | Precision as displayed permanently truncates stored decimals. The change cannot be undone later. | | **Q46** | **B** | The bottom-left status bar shows **Calculate** when results are stale in Manual mode. | | **Q47** | **False** | Calculation mode is a session-wide setting — switching one workbook to Manual switches them all. | ## Section I — Lesson 1.9 Answer Key | # | Answer | Explanation | | :--- | :--- | :--- | | **Q48** | **B** | The Inspector flags hidden content and personal info: comments, properties, hidden sheets, ink, etc. | | **Q49** | **B** | The two tiers are **Significant loss of functionality** and **Minor loss of fidelity**. | | **Q50** | **D** | Cell errors are formula problems, not accessibility issues. The Accessibility Checker focuses on assistive-tech compatibility. | | **Q51** | **C** | Recommended order: Accessibility, Compatibility, Inspect Document last (so author info is stripped after fixes). | | **Q52** | **B** | Dynamic-array and `XLOOKUP` features become `#NAME?`, and rows past 65,536 are truncated when saving to `.xls`. | | **Q53** | **B** | **Remove All** is permanent — Excel deletes the items immediately. Save a copy beforehand. | | **Q54** | **True** | Tick **Keep accessibility checker running while I work** to surface the live status indicator. | | **Q55** | **False** | Saving to `.xls` automatically re-runs the Compatibility Checker and shows the dialog before conversion. | ## Section J — Hands-On Solutions **T1. Macro relocation.** 1. Open both `Source.xlsm` and `Destination.xlsm`. 2. `Alt + F11` to open the VBE. 3. In the Project Explorer, expand `VBAProject (Source.xlsm) > Modules`. 4. Drag `Module1` onto `VBAProject (Destination.xlsm)`. 5. Switch to Excel, save `Destination.xlsm` (it must remain `.xlsm` to preserve the macro). **T2. AutoRecover and Version History.** 1. Open `BudgetModel.xlsx` from OneDrive. 2. **File > Options > Save** → set **Save AutoRecover information every** to `3` minutes → **OK**. 3. Click the filename in the title bar → **Version History** (or **File > Info > Version History**). 4. Pick yesterday's version → click **...** > **Save a Copy** → name it `BudgetModel_BeforeEdits.xlsx`. **T3. Layered Editing Restrictions.** 1. **File > Info > Protect Workbook > Encrypt with Password** → enter `Forecast!2026` twice → **OK**. 2. **File > Info > Protect Workbook > Mark as Final** → **OK** → **OK** on the confirmation. 3. Verify the **Protect Workbook** card on the Info pane shows both annotations. **T4. Sheet Protection With An Editable Input Range.** 1. Select `B5:B20` → `Ctrl + 1` → **Protection** tab → **uncheck Locked** → **OK**. 2. Confirm the data table already has AutoFilter dropdowns (turn on via **Data > Filter** if not). 3. **Review > Protect Sheet** → in the **Allow all users of this worksheet to** list, tick **Select unlocked cells** and **Use AutoFilter**. Leave the rest unchecked. Optionally set a password. Click **OK**. 4. **Review > Protect Workbook** → tick **Structure** → optional password → **OK**. **T5. Iterative Calculation Setup.** 1. **File > Options > Formulas**. 2. Tick **Enable iterative calculation**. 3. **Maximum Iterations:** `500`. 4. **Maximum Change:** `0.0001`. 5. **OK**. **T6. Pre-Release Inspection.** 1. **File > Save a Copy** as `Quarterly_Review_Public.xlsx` (work on the copy from here on). 2. **Review > Check Accessibility** — fix every Error item via the **Recommended Actions** dropdown (alt text, sheet rename, unmerge cells, etc.). 3. **File > Info > Check for Issues > Check Compatibility** → **Select versions to show...** → tick **Excel 2010** only → review the list and fix or accept the noted losses. 4. **File > Info > Check for Issues > Inspect Document** → confirm save → tick **Document Properties and Personal Information** and **Hidden Worksheets** (and any others as required) → **Inspect** → click **Remove All** beside the relevant findings. 5. Save.

Exam Tip — Module 1 Coverage Map:

Lesson	Most-Tested Concept
1.1	Drag-and-drop works on modules, not individual `Sub`s; `.xlsm` for macro files.
1.2	Paste Link for ranges; Change Source for moved files; closed-file syntax with full path.
1.3	Trusted Locations for folders of macro files; Trust access to the VBA project object model for code-modifying add-ins.
1.4	File > Info > Manage Workbook > Recover Unsaved; AutoRecover interval at File > Options > Save; cloud-only Version History.
1.5	Mark as Final = communication, not security; Encrypt with Password = no recovery.
1.6	Two-step protection: unlock first, then Protect Sheet. Allow Edit Ranges before protection.
1.7	Structure protection guards tab actions, not cell content.
1.8	`F9` / `Shift+F9` / `Ctrl+Alt+F9`; iterative calc params; Precision as Displayed is irreversible.
1.9	Run order: Accessibility → Compatibility → Inspect Document. Remove All is permanent.