Quiz

  1. 1
    Advanced

    Assume that A5 contains 48 and A6 contains 40. A custom conditional format rule is set up over A5 and A6 that reads =$A$5>45 and sets a red font. What color will the font be in A6?

  2. 2
    Advanced

    Cell D5 has two conditional formatting rules in place, in this order from top to bottom. Rule 1: Turns the font blue if the value is over 10. The author clicked the "Clear" button on the Fill tab when creating the rule. Rule 2: Turns the background yellow and the font red if the value is over 20. What do we need to do in order to have a value of 25 show with a red font and a yellow background?

  3. 3
    Advanced

    Cell D5 has two conditional formatting rules in place, in this order from top to bottom. Rule 1: Turns the font blue if the value is over 10. The author clicked the "Clear" button on the Fill tab when creating the rule. Rule 2: Turns the background yellow and the font red if the value is over 20. The value in D5 is currently 25. What will the color scheme be?