Google Sheets Date and Time Functions Questions and Answers Flashcards
6 cards from real Google Sheets Test practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 6 Google Sheets Date and Time Functions Questions and Answers flashcards as text
What does the DATEDIF function calculate in Google Sheets?
Answer: The difference between two dates in a specified unit
DATEDIF(start_date, end_date, unit) calculates the difference between two dates in units such as years, months, or days.
Which function adds a specified number of months to a date in Google Sheets?
Answer: EDATE()
EDATE(start_date, months) returns a date the specified number of months before or after the start date.
What does the HOUR() function extract from a time or datetime value?
Answer: The hour as a number between 0 and 23
HOUR(time) returns the hour component of a time value as an integer from 0 (midnight) to 23.
Which function converts a text string representing a date into an actual date value in Google Sheets?
Answer: DATEVALUE()
DATEVALUE(date_string) converts a date stored as text into a numeric date serial that Google Sheets can use in calculations.
What does the EOMONTH function return in Google Sheets?
Answer: The last day of a month offset by a number of months
EOMONTH(start_date, months) returns the last day of the month that is a specified number of months from the start date.
Which DATEDIF unit returns the number of complete months between two dates?
Answer: "M"
Using "M" as the unit in DATEDIF returns the number of complete calendar months between the start and end dates.
How this page was made: written with AI tools. We have not yet matched this exam's facts to an official source, so confirm fees, dates and rules with the exam body. Not reviewed by a subject-matter expert. Editorial policy