Using Conditional Formatting to Draw Attention to Cells That Are

question 66

Multiple Choice

Using Conditional Formatting to draw attention to cells that are blank

• A) displays a particular color based on the relative value of the cell contents to other selected cells.
• B) displays an icon representing a value in the top third, quarter, or fifth based on values in the selected range.
• C) helps locate where data may be missing.
• D) helps locate errors in cells quickly.

---

Definitions:

Centered

In statistics, adjusting data values by subtracting the mean of the data set from each value to have an average of zero.

Perfect Substitute

Goods or services that can be used in exactly the same way and are considered interchangeable by the consumer.

Indifference Curve

A graph representing combinations of two goods that provide an individual with the same level of satisfaction and utility.

Convex Preferences

A situation in consumer theory where a consumer prefers combinations or mixtures of goods to extreme amounts of either good, illustrating a desire for diversified consumption.