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
What does the custom number formatting operator “\” do?
It will divide the number by whatever value is typed next
It denotes that the next character is to be treated as text (this is here so that quotation marks (“) can be included in number formatting if required)
It allows spacing for the next character
Don’t know
2
Beginner
Which of the following custom number types would make the value zero and zero only appear as “-“ rather than “0”?
“-“
[Blue]#,##0-
[Blue]_(#,##0_);[Red](#,##0);[Green]_(\-_)
Don’t know
3
Beginner
What does the custom number formatting “;;;” do?
It forces all formatting back to default spreadsheet settings
It requires only text values to be displayed
“;;;” explains formatting for positive; negative; zero; text. Since none is specified, all non-error values will not be displayed in the cell either on screen or upon printing.
Don’t know
Back to the top
© 2024 GoSkills Ltd.
Skills for career advancement