MO-211 practice question 13 of 35
Which of the following formatting options allows you to change a cell's appearance based on its contents?
Full set: 355 questionsDomain Insert tables, charts, SmartArt, 3D models, and media
Conditional Formatting is a feature in Microsoft Excel that allows you to apply specific formatting to cells that meet certain criteria. The formatting is dynamic, meaning the cell's appearance (e.g., fill color, font style, or icon sets) automatically changes if its contents satisfy a predefined rule or condition. This feature is designed specifically to make data easier to visualize and analyze by highlighting cells of interest based on their values.
B. Borders and Shading: This is a static formatting tool that applies a fixed appearance and does not change based on the cell's value.
C. Text Wrapping: This is a layout setting that controls how text fits within a cell; it is not dependent on the cell's value.
D. Cell Alignment: This is a static positioning setting for cell content and does not change based on a condition.
1. Microsoft Corporation. (n.d.). Use conditional formatting to highlight information. Microsoft Support.
Reference Details: In the introductory section
it states
"Conditional formatting makes it easy to highlight interesting cells or ranges of cells
emphasize unusual values
and visualize data by using data bars
color scales
and icon sets that correspond to specific variations in the data." This directly confirms that formatting is applied based on the data's variations (contents).
2. University of California
Berkeley Library. (n.d.). Excel 2016: Conditional Formatting. Lib-Data.
Reference Details: The guide's overview section explains
"Conditional formatting allows you to automatically apply formatting—such as colors
icons
and data bars—to one or more cells based on the cell value." This explicitly links the application of formatting to the cell's value.
3. Massachusetts Institute of Technology (MIT). (2015). 15.S53: Lab 2 - Excel. MIT OpenCourseWare.
Reference Details: In the "Conditional Formatting" section of the lab exercise PDF (page 3)
the instructions guide users to "Highlight the cells in the range...if the value in the cell is greater than 10." This demonstrates the core function of changing appearance based on a condition related to the cell's contents.
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?
