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:
Data bars
Icon Sets
Top/Bottom Rules
Highlight Cells Rules
Color Scales
Premises:
Data bars
Icon Sets
Top/Bottom Rules
Highlight Cells Rules
Color Scales
Responses:
Related Questions
Q86: Filter arrows are always displayed in data
Q87: This could be a valid formula in
Q88: You can add a row to a
Q89: After a table has been named, that
Q90: You cannot sort cells by their fill
Q92: Match the following Conditional Formatting Options in
Q93: Match the following Subtotal Function with their
Q94: Match the following Data Type Sort Options
Q95: Match the following table style options with
Q96: Match the following table style options with
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents