Print Area, Export Formats, Print Settings, Inspect, Comments & Notes

Print Area, Export Formats, Print Settings, Inspect, Comments & Notes

Quick Answer: Preparing workbooks for collaboration and distribution on MO-210 means setting a print area, saving/exporting to formats like PDF or CSV, choosing what to print, running Inspect Workbook when asked to remove hidden or personal content, and managing Comments and Notes on the Review tab.

These tasks often appear at the end of a project file: after data and charts are correct, you package the workbook for a manager. Read whether the prompt wants a printable subset, a different file type, a cleaned copy, or feedback annotations.

Set and Clear a Print Area

A print area limits printing and PDF export (when printing the sheet) to a specific range.

1. Select the range that should print (for example, A1:G40).
2. Page Layout > Print Area > Set Print Area.
3. Verify with File > Print — only that range appears.
4. To remove it: Page Layout > Print Area > Clear Print Area.

You can add more ranges with Add to Print Area when noncontiguous blocks must print as separate pages. Print area is stored on the Sheet tab of Page Setup (Print area box) and can be edited there as a range address.

Print area vs Print Selection vs Print Titles

If a task says "set the print area to the selection," use Set Print Area — not merely Print Selection in the print dialog.

Save and Export Alternative File Formats

Use File > Save a Copy / Save As (or File > Export for some PDF/XPS flows) and change Save as type:

Format caveats that cost points

• CSV saves only the active sheet values. Formulas become calculated values; multiple sheets, charts, and formatting are not preserved. If the prompt says "export the Transactions sheet as CSV," activate that sheet first.
• PDF via Save As / Export creates a static snapshot respecting orientation, margins, print area, and page breaks — preview first.
• Template (.xltx) is for creating new workbooks from a starter layout; saving as template is different from saving a normal workbook.
• Closing prompts may warn about CSV features; confirm when the task requires CSV.

Configure Print Settings

Open File > Print (or Ctrl+P). Key Associate-level controls:

Print Active Sheets prints the selected sheet tab(s) — group sheets first if several should print. Print Entire Workbook prints every sheet. Print Selection prints the highlighted cells for this job only without defining a lasting print area.

Collation matters when printing multiple copies of multi-page sheets: Collated yields complete sets (1,2,3, 1,2,3); Uncollated yields all page 1s then all page 2s.

Inspect Workbooks and Correct Issues

Before distributing a file outside your team, Excel can scan for hidden or personal content:

1. File > Info > Check for Issues > Inspect Document.
2. Save when prompted (inspection needs a saved copy).
3. Select inspectors (Document Properties and Personal Information, Hidden Rows and Columns, Hidden Worksheets, Invisible Content, and others available in your build).
4. Inspect, review findings, then Remove All on categories the task tells you to clean.
5. Re-inspect if required; save the cleaned workbook.

Associate-level awareness:

• Removing document properties and personal information clears author/title-type metadata you may have just set — only remove when the collaboration prompt requires a clean distribution file.
• Hidden rows, columns, or worksheets can still hold data; Inspect helps you find them. Unhiding manually (Home > Format > Hide & Unhide) is the fix when you must keep the content visible rather than delete it.
• Inspect Document is not the same as Protect Workbook / Protect Sheet. Protection locks editing; Inspect finds content to review or strip before sharing.

Manage Comments and Notes

Microsoft 365 Excel distinguishes Comments (modern, threaded, @mention-capable) from Notes (legacy cell sticky notes formerly called comments in older Excel).

Task verbs map directly:

• "Add a comment…" / "Reply to the comment…" / "Delete the comment…" → Comments commands.
• "Add a note…" / "Edit the note…" / "Show all notes" → Notes menu.

Workflow tips:

1. Select the cell → Review > New Comment (or Notes > New Note).
2. Enter the required text exactly as specified (spelling counts on performance exams).
3. Use Previous/Next Comment to navigate; delete when the prompt says the discussion is resolved.
4. Show Comments / pane vs indicators: if the task says to display comments, open the Comments pane rather than only leaving the cell indicator.

Do not convert notes to comments unless asked — Convert changes the object type and can confuse graders looking for a Note.

Exam Scenario Walkthrough

Prompt: Set the print area to A1:F25 on Summary. Save a PDF copy named Summary-Handout. Print settings should use the entire workbook for a future print. Inspect the workbook and remove document properties and personal information. Add a note on cell H2 that reads "Verify vendor ID."

1. Select A1:F25 → Page Layout > Print Area > Set Print Area.
2. File > Export or Save As → PDF → Summary-Handout.pdf.
3. File > Print → choose Print Entire Workbook (setting retained for the session/job as applicable; ensure the dropdown is not left on Print Selection).
4. File > Info > Check for Issues > Inspect Document → remove Document Properties and Personal Information.
5. Select H2 → Review > Notes > New Note → type Verify vendor ID.

That sequence matches Certiport's Prepare workbooks for collaboration and distribution skill set: print area, alternate formats, print configuration, inspection, and notes/comments management.