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
Intermediate
How do you create a custom conditional formatting rule? Select your range of data and…
Go to Home ⇒ Conditional Formatting ⇒ New Rule ⇒ Custom
Go to Home ⇒ Conditional Formatting ⇒ Custom Rules ⇒ New
Go to Home ⇒ Conditional Formatting ⇒ New Rule ⇒ Use a formula to determine which cells to format
Don’t know
2
Intermediate
In a conditional formatting rule, how do you make a cell reference fully relative (instead of the default absolute reference)?
Remove the $ signs in front of the column letter and row number
Add a $ in front of the column letter or row number
Add a * in front of the column letter or row number
Don’t know
3
Intermediate
If you set one conditional formatting rule to fill the cell background in orange if the value is over 1000, and a second rule to set the font color to red and bold if the value is over 2000, what will the cell formatting look like if the value is 2500?
The background will be white and the font will be red and bold
The background will be orange and the font will be black
The background will be orange and the font will be red and bold
Don’t know
Back to the top
© 2024 GoSkills Ltd.
Skills for career advancement