Matching
Match the conditional formatting options to their descriptions:
Premises:
Color scale
Highlight Cells Rules
Icon set
Data bar
Top Bottom Rules
Responses:
horizontal gradient or solid fill indicating a cell's relative value
highlights cells meeting criteria with a color,font,or border
conditional format that displays a particular color based on the relative value of a cell
formats cells based on the value in relation to the other cells
conditional format that displays a small image representing a value
Correct Answer:
Premises:
Responses:
Color scale
Highlight Cells Rules
Icon set
Data bar
Top Bottom Rules
Premises:
Color scale
Highlight Cells Rules
Icon set
Data bar
Top Bottom Rules
Responses:
Related Questions
Q51: With data arranged in a table, you
Q65: You can only apply one filter to
Q66: A table style controls the fill color
Q67: Which of the following shows where automatic
Q69: The Freeze Panes option keeps:<br>A)only the first
Q70: Sorting arranges records in a table by:<br>A)using
Q71: What are icon sets?
Q72: A(n)_ row appears as the last row
Q73: Excel enables you to sort data on
Q84: A total row appears as the last