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


B, A, D, E, C

Computer Science & Information Technology

You might also like to view...

Which of the following Microsoft Office applications is used to create dynamic presentations to inform and persuade audiences?

A) PowerPoint B) Word C) Photoshop D) Access

Computer Science & Information Technology

An item, such as a picture or text box, that can be individually selected and manipulated.

What will be an ideal response?

Computer Science & Information Technology

Many companies without graphic arts departments create their logos using ____________________.

Fill in the blank(s) with the appropriate word(s).

Computer Science & Information Technology

The ____ value specifies the rate of change between tweened frames.

A. Scale B. Ease C. Tween D. Rotate

Computer Science & Information Technology