Match the following Conditional Formatting Options with their description:
I. Highlight Cells Rules
II. Top\Bottom Rules
III. Data bars
IV. Color Scales
V. Icon Sets
A. Formats cells if they fall in the lowest % (% determined by the user)
B. Formats cells with gradients of color depending on the cell's value compared to the other values in the range
C. Formats cells with colors whose width is proportional to the other values in the range
D. Formats cells if a date falls in a certain range
E. Uses symbols to represent the comparison of values
Correct Answer:
Verified
Q60: _ page breaks can be inserted if
Q64: In Page Break Preview, the area to
Q68: You can manually adjust a page break
Q74: In Normal view or Page Layout view
Q81: Match the following terms with their description:
I.
Q83: Match the following Data Type Sort Options
Q84: Match the following terms with their description:
I.
Q86: Match the following terms with their description:
I.
Q87: This could be a valid formula in
Q90: You cannot sort cells by their fill
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