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:

Real Property

Land and anything permanently affixed to it, such as buildings and other structures.

Fealty

A medieval concept referring to the loyalty and duty of a vassal to a lord, often associated with the feudal system.

Cross-Licensing

An illegal contractual arrangement in which two or more parties license each other to use their specified intellectual property only on the condition that neither licenses anyone else to use the property without the other’s consent.

Copyrights

Legal protections granted to creators over their original works, preventing unauthorized use for a certain period of time.