MO-211 practice question 23 of 35
What is the purpose of the 'Compatibility Checker' feature in Excel?
Full set: 355 questionsDomain Manage presentations
The Compatibility Checker is a diagnostic tool in Microsoft Excel designed to identify potential issues when a workbook is saved in an older file format (e.g., .xls for Excel 97-2003). It scans the workbook for features, functions, and formatting that are not supported or will function differently in the selected earlier version. The tool generates a report detailing any "significant loss of functionality" or "minor loss of fidelity," allowing the user to make informed decisions before saving to ensure the file remains usable for recipients with older software.
A. Creating a digital signature is handled by the 'Add a Digital Signature' feature, which is used for security and authentication.
C. Highlighting cells with errors is the function of the 'Error Checking' tool or can be achieved with conditional formatting rules.
D. Protecting a workbook from editing is accomplished using features like 'Protect Sheet,' 'Protect Workbook,' or 'Mark as Final.'
1. Microsoft Corporation. (n.d.). Check file compatibility with earlier versions of Excel. Microsoft Support. Retrieved from support.microsoft.com.
Reference Details: The article explicitly states
"When you create a workbook in a newer version of Excel
but it will be opened in an earlier version of Excel
it's a good idea to run the Compatibility Checker... The Compatibility Checker finds potential compatibility issues and helps you create a report so that you can resolve them."
2. University of Michigan. (n.d.). Saving Microsoft Excel Workbooks for Backwards Compatibility. ITS Documentation.
Reference Details: In the section on saving for older versions
the documentation explains that Excel automatically runs a "Compatibility Checker" to warn users about features that may be lost or changed when saving to the Excel 97-2003 (.xls) format. This confirms the tool's purpose is to check for version-specific feature compatibility.
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?
