Matching
Match the following Conditional Formatting Options in the Quick Analysis Gallery with their description:
Premises:
Unique Values
Text Contains
Duplicate Values
Clear Format
Equal To
Responses:
Formats cells that have exactly the same value
Formats cells that have the value
Removes any conditional formatting
Formats any cell that has content that matches the first content in the first selected cell
Formats cells that have no matching values
Correct Answer:
Premises:
Responses:
Unique Values
Text Contains
Duplicate Values
Clear Format
Equal To
Premises:
Unique Values
Text Contains
Duplicate Values
Clear Format
Equal To
Responses:
Related Questions
Q31: Match the following Data Type Sort Options
Q32: Which of the following is not a
Q33: You can manually adjust a page break
Q34: The _ wildcard symbol is often used
Q35: When would you not need to use
Q37: "John Smith" is a good example of
Q38: Using the data bars conditional formatting, how
Q39: Locking is the process of making sure
Q40: Which of the following is not a
Q41: Records are individual pieces of information.