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

TODAY() returns the current date as a date value, updating automatically each day the spreadsheet is opened.

Question 2

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

Accepted Answer

The current date and time

Answer

NOW() returns the current date and time as a combined value, recalculating whenever the spreadsheet is edited or opened.

Question 3

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

Accepted Answer

DATE(year, month, day)

Answer

DATE(year, month, day) constructs a date value from separate year, month, and day numeric arguments.

Question 4

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

Accepted Answer

NETWORKDAYS()

Answer

NETWORKDAYS(start_date, end_date) returns the number of working days between two dates, automatically excluding Saturdays and Sundays.

Question 5

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

Accepted Answer

The four-digit year

Answer

YEAR(date) returns the four-digit year corresponding to a given date value.

Google Sheets Test Practice Test