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

Question 1

What does the TIME(hour, minute, second) function create in Google Sheets?

Accepted Answer

A fractional day value representing a time

Answer

TIME(hour, minute, second) returns a fractional number between 0 and 1 that represents a time of day within Google Sheets' date system.

Question 2

Which function returns the week number of the year for a given date in Google Sheets?

Accepted Answer

WEEKNUM()

Answer

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.

Question 3

Which function returns a date a specified number of workdays after a start date in Google Sheets?

Accepted Answer

WORKDAY()

Answer

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.

Question 4

What behavior does NOW() exhibit when a Google Sheets spreadsheet is not actively being edited?

Accepted Answer

It updates only when the file is opened or edited

Answer

NOW() is a volatile function that recalculates each time the spreadsheet is opened, edited, or when a dependent cell changes.

Question 5

What does the MONTH() function return for the date December 15, 2025?

Accepted Answer

12

Answer

MONTH(date) returns the month number from 1 (January) to 12 (December), so December 15 returns 12.

Google Sheets Test Practice Test

Google Sheets Test Practice Test

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