Multiple Choice
A color scale:
A) highlights cells meeting specified criteria with a specified color,font,or border.
B) is a conditional format that displays an colored icon representing a value in the top third,quarter,or fifth based on colors in the selected range.
C) calculates an aggregate for values in a range or database.
D) is a conditional format that displays a color based on the relative value of the cell contents.
Correct Answer:
Verified
Correct Answer:
Verified
Q5: You can sort data by one or
Q19: Each row in an Excel table<br>A) is
Q44: If the automatic page breaks occur in
Q72: A(n)_ row appears as the last row
Q73: Excel enables you to sort data on
Q74: Why might you want to freeze rows
Q75: What are the four types of sorts
Q78: Top/Bottom Rules:<br>A)is a horizontal gradient or solid
Q79: Match the filter options to their explanations:
Q81: What is a field?<br>A)A complete set of