Multiple Choice
An icon set
A) is a conditional format that displays an icon representing a value in the top third, quarter, or fifth based on values in the selected range.
B) highlights cells meeting specified criteria with a specified color, font, or border.
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
Q58: A _ row appears as the last
Q59: In addition to sorting and filtering cells
Q60: The SUBTOTAL function<br>A) highlights or emphasizes cells
Q61: A data bar<br>A) highlights cells meeting specified
Q62: After you select a table style, you
Q64: If the default conditional format options do
Q65: A page _ indicates where data starts
Q66: Using Conditional Formatting to draw attention to
Q67: Conditional formatting<br>A) highlights or emphasizes cells that
Q68: A page break indicates where the end