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 TIME(hour, minute, second) function create in Google Sheets?
Answer: A fractional day value representing a time
TIME(hour, minute, second) returns a fractional number between 0 and 1 that represents a time of day within Google Sheets' date system.
Which function returns the week number of the year for a given date in Google Sheets?
Answer: WEEKNUM()
WEEKNUM(date, [type]) returns the week number within the year for the specified date, with an optional type argument to set the week start day.
Which function returns a date a specified number of workdays after a start date in Google Sheets?
Answer: WORKDAY()
WORKDAY(start_date, num_days, [holidays]) returns the date that is a given number of working days from the start date, skipping weekends and optional holidays.
What behavior does NOW() exhibit when a Google Sheets spreadsheet is not actively being edited?
Answer: It updates only when the file is opened or edited
NOW() is a volatile function that recalculates each time the spreadsheet is opened, edited, or when a dependent cell changes.
What does the MONTH() function return for the date December 15, 2025?
Answer: 12
MONTH(date) returns the month number from 1 (January) to 12 (December), so December 15 returns 12.
Which function converts a time text string like "3:30 PM" into a numeric time value in Google Sheets?
Answer: TIMEVALUE()
TIMEVALUE(time_string) parses a text representation of a time and returns its equivalent fractional day number usable in calculations.
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