MO-211 practice question 14 of 35

How can you remove personal information from a workbook before sharing it with others?

Full set: 355 questions

Domain Manage slides

Answer options
A: Use the "Protect Workbook" function under the Review tab.
B: Right-click the workbook in the Recent Workbooks menu and select "Remove personal information."
C: Use the "Inspect Document" function under the File tab. Correct answer
D: Go to File Options, click on "Trust Center," then "Trust Center Settings," and check the box for "Remove personal information from file properties on save."
Correct Answer:
C. Use the "Inspect Document" function under the File tab.
Explanation

The most direct and comprehensive method to remove personal information and other hidden data before sharing a workbook is by using the Document Inspector. This tool is found under File > Info > Check for Issues > Inspect Document. It scans the workbook for various types of data, including comments, document properties (like author), hidden worksheets, and other potentially sensitive information, and provides an option to remove them. This one-time check is the standard procedure for preparing a document for distribution.

Why Incorrect

A. "Protect Workbook" prevents structural changes to the workbook, such as adding or deleting sheets, but does not remove personal data.
B. This option describes a non-existent feature in Excel's right-click menu for recent workbooks; this functionality is not available there.
D. While this Trust Center setting does remove personal information from file properties on save, the Document Inspector is the more comprehensive tool that also finds and removes other hidden data like comments, annotations, and hidden content, which is crucial before sharing.

References

1. Microsoft Official Documentation: "Remove hidden data and personal information by inspecting documents

presentations

or workbooks." Microsoft Support. Accessed May 2024.

Section: "Use the Document Inspector to find and remove hidden data and personal information." This section explicitly states

"Before you share a copy of your Office file... it's a good idea to use the Document Inspector to find and remove any hidden data and personal information that you might not want to share." It then details the process of using the tool via File > Info > Check for Issues > Inspect Document.

2. University Courseware: University of Wisconsin-Madison

DoIT KnowledgeBase. "Microsoft 365 - Inspecting a Document for Hidden and Personal Information."

Section: "Inspecting a Document." This guide instructs users to "Go to File > Info. Click on the Check for Issues button and select Inspect Document" as the primary method for removing hidden and personal information from Office files

including Excel workbooks.

3. University Courseware: Gettysburg College

IT Documentation. "Removing Personal or Hidden Information from a Microsoft Office File."

Section: "How to Remove Hidden Data and Personal Information." This document outlines the procedure: "The Document Inspector helps you find and remove hidden data and personal information in Office documents... To open the Document Inspector

click File > Info > Check for Issues > Inspect Document." This reinforces that the Document Inspector is the designated tool for this task.

Scroll to Top