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
Which custom number format is required in order to turn the chart axis red as shown in the image below?
[Red][>=500]#,##0;[Red][<=-500]-#,##0; “-“
[>=500]#,##0;[<=-500]-#,##0; #,##0
[Red][>=500]#,##0;[Red][<=-500]-#,##0; #,##0
Don’t know
2
Advanced
Which is the shortest custom number format that we can write in order to change the color of the values as shown in the chart below?
[>=500]#,##0; [<=-500]-#,##0;[Red]#
[>=500]#,##0;[<=-500]-#,##0;[Red]0
[Black][>=500]#,##0;[Black][<=-500]-#,##0;[Red]0,000
Don’t know
3
Advanced
Why did the values all turn red as shown in the image below when the author used the following custom number format: [Red][<=500]#,##0;[Red][>=-500]-#,##0;[Black]0 ?
Any number that fails the first test will pass the second test
All values successfully trigger both of the first two rules
The rule is too complex and fails to execute properly
Don’t know
Back to the top
© 2024 GoSkills Ltd.
Skills for career advancement