Free Microsoft MO-211 Actual Exam Questions - Question 13 Discussion
contents?
A. Conditional formatting is the only one that really reacts automatically when the cell’s content changes. Borders and shading (B) are static unless you manually adjust them, and text wrapping or alignment don’t change based on content value at all. So it has to be A because it’s built for dynamic appearance changes tied to the actual data in the cell.
A. Borders and shading don’t update on their own—they’re set manually. Conditional formatting is designed to automatically adjust based on what’s inside the cell, so that’s the only one that fits here.
Option A is the only one that reacts to the cell's value. Borders and shading are static, and text wrapping or alignment don’t depend on content changes.
A vs B? Borders and shading just change the look but aren’t dynamic based on what’s actually in the cell. Conditional formatting is the only one that updates the cell’s style depending on its value or formula result, so it fits best here.
A, since only conditional formatting changes based on cell data, not just style.
A. Conditional Formatting is the only option that changes the cell’s look depending on what data is inside, so it makes sense to pick that one. The others just adjust static styles.
It’s definitely not B, C, or D because those just change how the cell looks generally, not based on what's inside it. So it has to be A.
Sure feels like Conditional Formatting, so A.