Essay
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
Correct Answer:
Verified
Q14: What is not true about creating a
Q19: Where does Excel display the Total row
Q22: Data _ is the method used to
Q27: By how many levels will Excel allow
Q40: Which of the following is not a
Q44: What cannot be found on the Manage
Q47: _ references help to clarify what type
Q52: You can see how many records meet
Q71: In the formula =SUBTOTAL(102,[PAID]), what does the
Q100: Which one of the following filter options