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

A text label for a time

Answer

A date serial number

Answer

A timestamp with timezone

Question 2

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

Accepted Answer

WEEKNUM()

Answer

WEEKOF()

Answer

WEEK()

Answer

ISOWEEK()

Question 3

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

Accepted Answer

WORKDAY()

Answer

NETWORKDAYS()

Answer

NEXTWORKDAY()

Answer

ADDWORKDAYS()

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

It stops updating permanently

Answer

It updates every minute automatically

Answer

It always shows the file creation time

Question 5

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

Accepted Answer

12

Answer

15

Answer

2025

Answer

349

Question 6

Which function converts a time text string like "3:30 PM" into a numeric time value in Google Sheets?

Accepted Answer

TIMEVALUE()

Answer

CONVERTTIME()

Answer

TEXTTIME()

Answer

PARSETIME()