Quiz

  1. 1
    Advanced

    Suppose cells A5 and A6 contain the numbers 48 and 40 respectively. For both cells the custom conditional format rule is =$A$5>45 which executes a red font. What color will be the font in A6?

  2. 2
    Advanced

    Suppose cell D5 has two conditional formatting rules in place. The first rule turns the font blue if the value exceeds 10. The second rule turns the background yellow and the font red if the value exceeds 20. What is required for a value of 25 to be displayed with a red font and yellow background?

  3. 3
    Advanced

    Suppose cell D5 has two conditional formatting rules in place. The first rule in the manage rules list turns the font blue if the value exceeds 10. The second rule in the manage rules list turns the background yellow and the font red if the value exceeds 20. The value in D5 is currently 25. What will be the color scheme?