Google Sheets Test Google Sheets Date and Time Functions Questions and Answers 1 — Questions and Answers
Question 1: Which Google Sheets function returns today's date without a time component?
- TODAY() (Correct answer)
- NOW()
- DATE()
- CURRENTDATE()
Correct answer: TODAY()
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?
- Only the current time
- Only the current date
- The current date and time (Correct answer)
- A static timestamp
Correct answer: The current date and time
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?
- DATE(day, month, year)
- DATE(year, month, day) (Correct answer)
- DATE(month, day, year)
- DATE(year, day, month)
Correct answer: DATE(year, month, day)
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?
- WORKDAYS()
- DAYS()
- NETWORKDAYS() (Correct answer)
- BUSDAYS()
Correct answer: NETWORKDAYS()
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?
- The month number
- The four-digit year (Correct answer)
- The two-digit year
- The day of the year
Correct answer: The four-digit year
YEAR(date) returns the four-digit year corresponding to a given date value.
Question 6: Which Google Sheets function returns a number (1–7) representing the day of the week for a given date?
- DAYOFWEEK()
- WEEKDAY() (Correct answer)
- DAY()
- DAYNUM()
Correct answer: WEEKDAY()
WEEKDAY(date, [type]) returns the day of the week as a number, with the type argument controlling which day is numbered 1.
Google Sheets Test Google Sheets Date and Time Functions Questions and Answers 1
Which Google Sheets function returns today's date without a time component?