Quiz

  1. 1
    Intermediate

    If the value 0.5 resided in a cell, and you formatted it with a time format, what would the result be?

  2. 2
    Intermediate

    If cell A6 holds the time of 8:00 AM, B6 holds the value 7.5 and D6 holds the formula =A6+C6 formatted as a time, what formula would you need to put in C6 to make D6 return 3:30 PM?

  3. 3
    Intermediate

    Assume that A6 holds a time of 8:00 AM and B6 holds a time of 4:00 PM. What formula would we need to use to calculate the number of hours elapsed between the two?