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 would return the values as shown in the image below?
#,##0 +;[Red]#,##0 -
#,##0 +;[Red]#,##0 -;0
#,##0 +;[Red]#,##0 -;"-"
Don’t know
2
Advanced
Your boss sent you the spreadsheet shown below, and has asked you to display the values in the Raw row as shown in the Formatted row. Which custom number format do you need?
#.# "U";#.# "D";"Even"
0.0 "U";0.0 "D";"Even"
#.0 "U";#.0 "D";"Even"
Don’t know
3
Advanced
Assume that cell B5 holds a value of 560. What would the custom number format of ;;; cause this cell to display?
560
The cell would appear empty, no matter what data was in it
The cell would appear empty unless it held text
Don’t know
Back to the top
© 2024 GoSkills Ltd.
Skills for career advancement