What Does the Highlight Duplicate Values Conditional Formatting Rule Do

question 213

Multiple Choice

What does the Highlight Duplicate Values conditional formatting rule do when you apply it to a range?

• A) It highlights duplicate values in the range.
• B) It deletes duplicate values from the range.
• C) It converts duplicate values so they are unique.
• D) It moves the duplicate values to another area of the worksheet.

---

Definitions:

Health Insurance

A type of insurance coverage that typically pays for medical, surgical, prescription drug, and sometimes dental expenses incurred by the insured.

Gay Marriages

Legal or socially recognized marriages between two individuals of the same gender.

Marital Bias

Preconceived notions or unfair treatment based on an individual's marital status.

Single People

Individuals who are not currently in a marital or comparable committed relationship and may prioritize personal, social, or career goals differently from those in partnerships.