Using Conditional Formatting to Draw Attention to Cells Containing Errors

question 78

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.

---

Definitions:

Sunk Cost Effect

The phenomenon where a person continues an endeavor because of previously invested resources (time, money, or effort), despite potential losses.

Availability Heuristic

The availability heuristic is a mental shortcut that relies on immediate examples that come to mind when evaluating a specific topic, concept, method, or decision.

Confirmation Bias

Confirmation bias is the tendency to search for, interpret, favor, and recall information in a way that confirms one’s preexisting beliefs or hypotheses.

Self-Serving Bias

A common cognitive bias where individuals attribute their successes to personal factors while attributing their failures to external factors.