Google Sheets Test Google Sheets Date and Time Functions Questions and Answers 2

Question 1

What does the DATEDIF function calculate in Google Sheets?

Accepted Answer

The difference between two dates in a specified unit

Answer

The sum of two date values

Answer

The formatted display of a date

Answer

The number of weekdays in a month

Question 2

Which function adds a specified number of months to a date in Google Sheets?

Accepted Answer

EDATE()

Answer

DATEADD()

Answer

ADDMONTHS()

Answer

MONTHSHIFT()

Question 3

What does the HOUR() function extract from a time or datetime value?

Accepted Answer

The hour as a number between 0 and 23

Answer

Minutes past the hour

Answer

The hour as a 12-hour value

Answer

The total hours since midnight

Question 4

Which function converts a text string representing a date into an actual date value in Google Sheets?

Accepted Answer

DATEVALUE()

Answer

TODATE()

Answer

CONVERT()

Answer

TEXTTODATE()

Question 5

What does the EOMONTH function return in Google Sheets?

Accepted Answer

The last day of a month offset by a number of months

Answer

The first day of a given month

Answer

The middle day of the month

Answer

The total days in a month

Question 6

Which DATEDIF unit returns the number of complete months between two dates?

Accepted Answer

"M"

Answer

"D"

Answer

"Y"

Answer

"W"