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
Correct Answer:

Verified
Correct Answer:
Verified
Q21: Before you freeze panes make sure the
Q35: When would you not need to use
Q38: Using the data bars conditional formatting, how
Q44: What cannot be found on the Manage
Q51: Which table style option is useful to
Q53: In a data table each row is
Q58: What is not true about using the
Q65: What would be the result if you
Q74: Match the following table style options with
Q100: Which one of the following filter options