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

DATEDIF(start_date, end_date, unit) calculates the difference between two dates in units such as years, months, or days.

Question 2

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

Accepted Answer

EDATE()

Answer

EDATE(start_date, months) returns a date the specified number of months before or after the start date.

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

HOUR(time) returns the hour component of a time value as an integer from 0 (midnight) to 23.

Question 4

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

Accepted Answer

DATEVALUE()

Answer

DATEVALUE(date_string) converts a date stored as text into a numeric date serial that Google Sheets can use in calculations.

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

EOMONTH(start_date, months) returns the last day of the month that is a specified number of months from the start date.

Google Sheets Test Practice Test