Essay
Match the following Conditional Formatting Options in the Quick Analysis Gallery with their description:
I. Text Contains
II. Duplicate Values
III. Unique Values
IV. Equal To
V. Clear Format
A. Formats cells that have exactly the same value
B. Formats any cell that has content that matches the first content in the first selected cell
C. Removes any conditional formatting
D. Formats cells that have no matching values
E. Formats cells that have the value
Correct Answer:
Verified
Correct Answer:
Verified
Q24: In Normal view or Page Layout view
Q45: Which conditional formatting option would you choose
Q48: You can add a row to a
Q58: What is not true about using the
Q61: You can freeze as many columns and
Q70: Excel uses solid blue lines to indicate
Q78: If you use the Color Scale conditional
Q81: You can select multiple print areas.
Q82: When you set up various conditions with
Q92: When you include table names in a