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

Question 1

Which Google Sheets function returns today's date without a time component?

Accepted Answer

TODAY()

Answer

NOW()

Answer

DATE()

Answer

CURRENTDATE()

Question 2

What does the NOW() function return in Google Sheets?

Accepted Answer

The current date and time

Answer

Only the current time

Answer

Only the current date

Answer

A static timestamp

Question 3

What is the correct syntax for the DATE function in Google Sheets?

Accepted Answer

DATE(year, month, day)

Answer

DATE(day, month, year)

Answer

DATE(month, day, year)

Answer

DATE(year, day, month)

Question 4

Which function calculates the number of working days between two dates, excluding weekends?

Accepted Answer

NETWORKDAYS()

Answer

WORKDAYS()

Answer

DAYS()

Answer

BUSDAYS()

Question 5

What does the YEAR() function extract from a date value in Google Sheets?

Accepted Answer

The four-digit year

Answer

The month number

Answer

The two-digit year

Answer

The day of the year

Question 6

Which Google Sheets function returns a number (1–7) representing the day of the week for a given date?

Accepted Answer

WEEKDAY()

Answer

DAYOFWEEK()

Answer

DAY()

Answer

DAYNUM()