NEW
Font size
Worksheets=NOW()
Total questions: 10
Worksheet time: 5mins
True/False: The NOW function is useful to display the current date.
True
False
True/False: The TODAY function is useful to display the current date.
True
False
_______Returns the current date and time.
=NOW()
=NOW()+5
=TODAY
=TODAY()=5
_______Returns the date and time 12 hours ago
=NOW()
=NOW()-0.5
=TODAY()
=NOW()-5
_______Returns the date and time 7 days in the future
=NOW()
=NOW()+7
=TODAY
=TODAY()-7
_______Returns the date and time 2 days and 6 hours ago
=NOW()
=NOW()-2.25
=NOW()-0.25
=TODAY()-2
_______Returns the date and time 6 hours ago
=NOW()
=NOW()-2.25
=NOW()-0.25
=TODAY()-2
_______Returns the date and time 18 hours ago
=NOW()
=NOW()+2.25
=NOW()-0.75
=TODAY()-2
_______Returns the 7 date and 18 hours ago
=NOW()
=NOW()-2.25
=NOW()-7.75
=TODAY()-2
_______Returns the yesterday date and 6 hours ago
=NOW()
=NOW()-1.25
=NOW()-7.75
=TODAY()-2
