GoSkills
  • LMS
  • Course builder
  • Courses
    • Train your organization. Train your organization Supercharge your organization with expert-led business and productivity courses. Learn more
    • Learn on your own. Learn on your own Earn certifications for the most in-demand skills with unlimited access to all GoSkills courses. Learn more
    • Explore our courses. Explore our courses Browse our award-winning library of 100+ bite-sized business and productivity courses.  Explore courses
  • Courses
  • Resources
  • Pricing
    • Organization pricing
    • Individual pricing
  • Pricing
  • Search
Sign upLog in
  • Log in Signup

Quiz

  1. 1
    Intermediate

    Suppose a cell contains the value 0.5. What is returned when this value is formatted with a date and time format?

  2. 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?

    Supporting image for quiz question

    Supporting image for quiz question
  3. 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?

    Supporting image for quiz question

    Supporting image for quiz question
Previous question Previous Next question Next
Give feedback

How is your GoSkills experience?

I need help

Your feedback has been sent

Thank you

Back to the top

© 2023 GoSkills Ltd. Skills for career advancement