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
Which Google Sheets function returns today's date without a time component?
Answer: TODAY()
TODAY() returns the current date as a date value, updating automatically each day the spreadsheet is opened.
What does the NOW() function return in Google Sheets?
Answer: The current date and time
NOW() returns the current date and time as a combined value, recalculating whenever the spreadsheet is edited or opened.
What is the correct syntax for the DATE function in Google Sheets?
Answer: DATE(year, month, day)
DATE(year, month, day) constructs a date value from separate year, month, and day numeric arguments.
Which function calculates the number of working days between two dates, excluding weekends?
Answer: NETWORKDAYS()
NETWORKDAYS(start_date, end_date) returns the number of working days between two dates, automatically excluding Saturdays and Sundays.
What does the YEAR() function extract from a date value in Google Sheets?
Answer: The four-digit year
YEAR(date) returns the four-digit year corresponding to a given date value.
Which Google Sheets function returns a number (1–7) representing the day of the week for a given date?
Answer: WEEKDAY()
WEEKDAY(date, [type]) returns the day of the week as a number, with the type argument controlling which day is numbered 1.
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