Page 7 of 8PREVNEXT

Understand data at a glance with conditional formatting

Test yourself

Complete the following test so you can be sure you understand the material. Your answers are private, and test results are not scored.


You can apply conditional formatting to an Excel table, which already has its own formatting.

True.

False.

When you select a conditional formatting option such as data bars for example, you can only use the samples you see.

True.

False.

You can always change conditional formatting rules after you apply them.

True.

False.

To delete conditional formatting, select the cells you want to clear the formatting from, and then:

Press Delete.

On the Home tab, in the Editing group, click Clear Formats.

On the Home tab, in the Styles tab, click Conditional Formatting, click Clear Rules, and then select the appropriate option.

Page 7 of 8PREVNEXT