Toggle navigation
GoSkills
Courses
Courses
Train your organization
Supercharge your organization with expert-led business and productivity courses.
Learn more
Learn on your own
Earn certifications for the most in-demand skills with unlimited access to all GoSkills courses.
Learn more
Explore our courses
Browse our award-winning library of 110+ business and productivity courses delivered in bite-sized lessons.
Explore courses
LMS
Course builder
Resources
Pricing
Organization pricing
Individual pricing
Pricing
Search
Sign up
Log in
Log in
Signup
Quiz
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?
Red
The default on the cell (the rule is false, so won’t trigger a change)
There is not enough information to tell.
Don’t know
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?
Put the yellow rule first
Put the yellow rule first and select Stop if True
Put the blue rule first and select Stop if True
Don’t know
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?
Blue font, yellow background
Red font, yellow background
Blue font, white background
Don’t know
Back to the top
© 2024 GoSkills Ltd.
Skills for career advancement