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 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 particular color based on the relative value of the cell contents to other selected cells.
Correct Answer:
Verified
Correct Answer:
Verified
Q38: A field<br>A) is a complete set of
Q39: Using Conditional Formatting to highlight _ is
Q40: A structured reference<br>A) is a tag or
Q41: The Table Style Options Group<br>A) contains check
Q42: Freeze Top Row<br>A) is the sequence in
Q44: If the automatic page breaks occur in
Q45: A page break<br>A) freezes only the top
Q46: After you apply conditional formatting, you can
Q47: A _ is an area in the
Q48: A structured reference uses field names instead