Matching
Match the following Conditional Formatting Options with their description:
Premises:
Highlight Cells Rules
Top/Bottom Rules
Data bars
Color Scales
Icon Sets
Responses:
Formats cells if they fall in the lowest % (% determined by the user)
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 a date falls in a certain range
Uses symbols to represent the comparison of values
Correct Answer:
Premises:
Responses:
Highlight Cells Rules
Top/Bottom Rules
Data bars
Color Scales
Icon Sets
Premises:
Highlight Cells Rules
Top/Bottom Rules
Data bars
Color Scales
Icon Sets
Responses:
Related Questions
Q11: If you wanted the most freedom in
Q39: The most common method of entering data
Q63: Match the following terms with the group
Q64: How many other forms does the More
Q65: Match the following terms with their description:
Q66: Match the following Subtotal Function with their
Q68: Match the following terms with their description:
Q70: Match the following Data Type Sort Options
Q71: There is no way to make sure
Q72: Sketching out a form's layout on paper