Matching
Match the following Conditional Formatting Options with their description:
Premises:
Data bars
Icon Sets
Highlight Cells Rules
Color Scales
Top/Bottom Rules
Responses:
Formats cells with gradients of color depending on the cell's value compared to the other values in the range
Uses symbols to represent the comparison of values
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
Correct Answer:
Premises:
Responses:
Data bars
Icon Sets
Highlight Cells Rules
Color Scales
Top/Bottom Rules
Premises:
Data bars
Icon Sets
Highlight Cells Rules
Color Scales
Top/Bottom Rules
Responses:
Related Questions
Q6: The print _ is the range of
Q7: In a structured reference what do you
Q8: Match the following Data Type Sort Options
Q14: What is not true about creating a
Q18: Which of the following is not a
Q60: You cannot sort cells by their fill
Q61: You can freeze as many columns and
Q65: What would be the result if you
Q76: In the formula =SUBTOTAL(102,[PAID]), what does the
Q85: On which tab will you find options