Using Conditional Formatting to Draw Attention to Cells Containing Errors

Multiple Choice

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.