Conditional Formatting Quiz

Quiz covering Create Reports

Questions in this quiz

A preview of the 5 questions covered. Start the quiz above to answer them, check your score, and read the explanations.

1. 1

   What is the primary purpose of using conditional formatting in a report?

2. 2

   If you want to highlight all cells in a 'Sales' column that are greater than $5,000 in red, which feature should you use?

3. 3

   When applying a '3-Color Scale' to a range of numbers, how does the formatting determine the colors?

4. 4

   Which of the following scenarios is best suited for using 'Icon Sets'?

5. 5

   You have two overlapping conditional formatting rules applied to the same cell range. Rule A sets the background to blue if the value is > 100. Rule B sets the background to yellow if the value is > 50. If the cell value is 120, how does the system resolve this?