Matching
Match the following Conditional Formatting Options in the Quick Analysis Gallery with their description:
Premises:
Unique Values
Equal To
Duplicate Values
Text Contains
Clear Format
Responses:
Formats cells that have the value
Removes any conditional formatting
Formats cells that have no matching values
Formats any cell that has content that matches the first content in the first selected cell
Formats cells that have exactly the same value
Correct Answer:
Premises:
Responses:
Unique Values
Equal To
Duplicate Values
Text Contains
Clear Format
Premises:
Unique Values
Equal To
Duplicate Values
Text Contains
Clear Format
Responses:
Related Questions
Q19: Where does Excel display the Total row
Q23: What is true about adding a new
Q39: Locking is the process of making sure
Q41: Records are individual pieces of information.
Q45: Which conditional formatting option would you choose
Q59: By default Excel prints page in what
Q67: If you wanted every cell that has
Q86: Even if panes are frozen pressing Ctrl+Home
Q92: When you include table names in a
Q95: Which wildcard character only replaces one character