MO-211 practice question 14 of 35
How can you remove personal information from a workbook before sharing it with others?
Full set: 355 questionsDomain Manage slides
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.
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.
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.
Keep practicing
Take the free MO-211 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other MO-211 practice questions
- Question 1What formula can be used to calculate the sum of a range of cells in Excel?
- Question 2Which chart type is best used to display trends over time?
- Question 3What is the formula used in Excel to calculate the percentage change between two numbers?
- Question 4What is a slicer in Excel?
- Question 5What is the shortcut key to insert a new worksheet in Excel?
- Question 6What is the shortcut key for copying a formula in Excel?
