GoSkills
  • Courses
  • Courses
    • Train your organization. Train your organization Supercharge your organization with expert-led business and productivity courses. Learn more
    • Learn on your own. Learn on your own Earn certifications for the most in-demand skills with unlimited access to all GoSkills courses. Learn more
    • Explore our courses. Explore our courses Browse our award-winning library of 100+ business and productivity courses delivered in bite-sized lessons. Explore courses
  • LMS
  • Course builder
  • Resources
  • Pricing
    • Organization pricing
    • Individual pricing
  • Pricing
  • Search
Sign upLog in
  • Log in Signup

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 font color will A6 show?

    Supporting image for quiz question

    Supporting image for quiz question
  2. 2
    Advanced

    Suppose cell D5 has two conditional formatting rules in place, as shown below. 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?

    Supporting image for quiz question

    Supporting image for quiz question
  3. 3
    Advanced

    Suppose cell D5 has two conditional formatting rules in place as shown below. 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 color scheme will the cell display?

    Supporting image for quiz question

    Supporting image for quiz question
Previous question Previous Next question Next
Give feedback

How is your GoSkills experience?

I need help

Your feedback has been sent

Thank you

Back to the top

© 2023 GoSkills Ltd. Skills for career advancement