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
Assuming that your version of Excel doesn't give you a default option formatting dates in a year-month-day format, how would you format the "Sales up to" column to display the dates as 2018-12-09, 2018-12-11 and 2018-12-10?
Go to Format Cells, choose Number and then Custom and set the Type to yyyy-m-d
Go to Format Cells, select Date and choose Jan 22, 2013
Go to Format Cells, choose Number and then Custom and set the Type to yyyy-mm-dd
Don’t know
2
Intermediate
By default, the values in the Product # column of the table shown below will not have leading zeros. How would you force Excel to show them?
Format the cell as text
Type 001234 in the cell
Go to Format Cells and select Number and then Custom and set the Type to 000000
Don’t know
3
Intermediate
Suppose the value 134567 is in a cell. When this value is formatted with the custom number format ###-###-###, what does it look like?
###-###-###
000-134-567
-134-567
Don’t know
Back to the top
© 2024 GoSkills Ltd.
Skills for career advancement