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:

Enable Content Button

A feature in software that permits the activation of content that may be disabled by default for security.

If Block

Conditional programming structure that executes a set of statements based on whether a specified condition is true.

End If Statement

Marks the conclusion of an IF condition in programming, signaling the end of conditional logic execution.

Macro

A sequence of commands or actions automated to perform a specific task within software applications.