Excel Date and Time Quiz
Authored by Eldorette Loots
Computers
12th Grade
Used 12+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
15 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How does Excel interpret dates and times?
As text values
As numerical values
As graphical values
As currency values
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following functions would you use to insert the current date in Excel?
=NOW()
=DATE()
=TODAY()
=TIME()
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the starting value of a date in Excel?
January 1, 1900
January 1, 2000
December 31, 1900
January 1, 2001
4.
FILL IN THE BLANK QUESTION
1 min • 1 pt
The function ________ extracts only the year from a date in Excel.
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following is true when entering time in Excel?
Time is always represented in the 24-hour format.
Time is treated as a fraction of a 24-hour day.
Times entered must always be in AM.
Time values are displayed as integers only.
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How can you enter the current time in Excel?
=TIME()
=NOW()
Press <;>
Enter the time manually
7.
FILL IN THE BLANK QUESTION
1 min • 1 pt
If cell A1 contains a date, the formula ________ will calculate the difference in days between A1 and today.
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports
Continue with Google
Continue with Email
Continue with Classlink
Continue with Clever
or continue with
Microsoft
%20(1).png)
Apple
Others
Already have an account?
