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
D, A, C, B, E
You might also like to view...
When working with multiple tables, the ________ row in the query grid identifies the table of origin
Fill in the blank(s) with correct word
The desktop version of Outlook accesses your Office 365 Outlook email using the ________ protocols
A) POP3/SMTP B) AOL/SMTP C) Outlook server D) SMTP/POP3