Excel Date and Time Quiz

How does Excel interpret dates and times?

• As text values

• As numerical values

• As graphical values

• As currency values

Which of the following functions would you use to insert the current date in Excel?

• =NOW()

• =DATE()

• =TODAY()

• =TIME()

What is the starting value of a date in Excel?

• January 1, 1900

• January 1, 2000

• December 31, 1900

• January 1, 2001

The function ________ extracts only the year from a date in Excel.

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.

How can you enter the current time in Excel?

• =TIME()

• =NOW()

• Press <;>

• Enter the time manually

If cell A1 contains a date, the formula ________ will calculate the difference in days between A1 and today.

If you want Excel to display the time as 3 PM, what format would you enter?

• 03:00 AM

• 15:00

• 03:00 PM

• 15:00 AM

To add 30 days to the current date in Excel, you would use the formula ________.

Which function would you use to combine both the current date and time into one cell in Excel?

• =DATE()

• =NOW()

• =TIME()

• =TODAY()