Match the Following Conditional Formatting Options in the Quick Analysis

question 76

Multiple Choice

Match the following Conditional Formatting Options in the Quick Analysis Gallery with their description:
i. Text Contains
II. Duplicate Values
III. Unique Values
IV. Equal To
v. Clear Format

• A) Formats cells that have exactly the same value
• B) Formats any cell that has content that matches the first content in the first selected cell
• C) Removes any conditional formatting
• D) Formats cells that have no matching values
• E) Formats cells that have the value

---

Definitions:

Automatically Terminated

Describes a legal status or condition that ends without the need for any action by a party due to pre-set conditions being met.

Agency Relationship

A legal arrangement where one party, the agent, is authorized to act on behalf of another, the principal, in business transactions.

Principal

A person or entity who authorizes an agent to act on their behalf in dealings with third parties.

Constructive Trust

A legal remedy imposed by a court to address unjust enrichment or fraud, requiring the person holding the assets to transfer them to the intended party.