Using Conditional Formatting to draw attention to cells containing errors
A) helps locate errors in cells quickly.
B) displays a particular color based on the relative value of the cell contents to other selected cells.
C) calculates an aggregate for values in a range or database.
D) displays an icon representing a value in the top third based on values in the selected range.

Question

Quizplus · Accepted Answer

Conditional Formatting can be used to highlight cells that contain errors, making it easier to quickly locate and address these errors in a spreadsheet. Choices B, C, and D describe other functionalities of Conditional Formatting but not its use in identifying errors.

Using Conditional Formatting to Draw Attention to Cells Containing Errors