Matching
Match the following Conditional Formatting Options with their description:
Premises:
Data bars
Icon Sets
Top/Bottom Rules
Highlight Cells Rules
Color Scales
Responses:
Formats cells with gradients of color depending on the cell's value compared to the other values in the range
Formats cells with colors whose width is proportional to the other values in the range
Formats cells if they fall in the lowest % (% determined by the user)
Uses symbols to represent the comparison of values
Formats cells if a date falls in a certain range
Correct Answer:
Premises:
Responses:
Icon Sets
Uses symbols to represent the comparison of values
Color Scales
Formats cells with gradients of color depending on the cell's value compared to the other values in the range
Data bars
Formats cells with colors whose width is proportional to the other values in the range
Top/Bottom Rules
Formats cells if they fall in the lowest % (% determined by the user)
Highlight Cells Rules
Formats cells if a date falls in a certain range
Premises:
Icon Sets
Color Scales
Data bars
Top/Bottom Rules
Highlight Cells Rules
Responses:
Uses symbols to represent the comparison of values
Formats cells with gradients of color depending on the cell's value compared to the other values in the range
Formats cells with colors whose width is proportional to the other values in the range
Formats cells if they fall in the lowest % (% determined by the user)
Formats cells if a date falls in a certain range
Related Questions
Q1: To what does the @ symbol refer
Q3: In a data table you can use
Q4: To go to the first unfrozen cell
Q5: Match the following table style options with
Q6: The print _ is the range of
Q7: In a structured reference what do you
Q8: Which table style option shows the field
Q9: When you use the Freeze Panes option
Q10: The Table Styles _ shows you all
Q11: To print row labels on the left