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
Suppose a cell contains the value 0.5. What is returned when this value is formatted with a date and time format?
1900-01-01 12:00:00 PM
1900-01-01 12:00:00 AM
12:00:00 PM
Don’t know
2
Intermediate
Suppose cell A6 contains the time 8:00 AM, B6 the value 7.5 and D6 the formula =A6+C6 formatted as a time. Which formula for C6 returns the time 3:30 PM for D6?
=B6*24
=B6/24
=B6/24/60
Don’t know
3
Intermediate
Suppose cells A6 and B6 contain the times 8:00 AM and 4:00 PM respectively. Which formula calculates how many hours have elapsed between these two times?
=(B6-A6)*24
=(B6-A6)*24*60
=B6-A6
Don’t know
Back to the top
© 2024 GoSkills Ltd.
Skills for career advancement