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
Beginner
How do you create the data bars shown on the Sales $ column in the image below?
Select B2:B10 ⇒ Home ⇒ Conditional Formatting ⇒ Data Bars ⇒ Yellow data bars
Select A2:A10 ⇒ Home ⇒ Conditional Formatting ⇒ Data Bars ⇒ Green data bars ⇒ Change the color to Blue
Select A2:A10 ⇒ Home ⇒ Conditional Formatting ⇒ Data Bars ⇒ Blue data bars
Don’t know
2
Beginner
What customization needs to be done to get the yellow data bar rule to appear as it does in the Variance column?
No customization is required as this is the default behavior when positive and negative values are present
The axis needs to be set to show in the cell mid point
The negative color needs to be set to Red
Don’t know
3
Beginner
What customization's were required to get the Tolerance column’s blue data bar rule to display the positive and negative variances so they both extend from the left side of the cell?
The Negative Value and Axis Settings were customized to use a yellow Fill and Border
The Negative Value and Axis Settings were customized to use an Axis setting of “Extend from Left”
The Negative Value and Axis Settings were customized to use an Axis setting of “None”
Don’t know
Back to the top
© 2024 GoSkills Ltd.
Skills for career advancement