Date & Time =WORKDAY(start_date, days, [holidays])

Quiz =WORKDAY — 15 Questions

15 quiz questions about =WORKDAY — test syntax, arguments, examples & errors!

Questions: 10 questions 15 questions Random 10 or 15 questions from the pool + shuffled options each time

← WORKDAY ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

Which use case fits =WORKDAY?

Question 2 of 15 2/15

Which is the correct syntax of =WORKDAY?

Question 3 of 15 3/15

What is the fix for #VALUE! in =WORKDAY?

Question 4 of 15 4/15

What is the output type of =WORKDAY?

Question 5 of 15 5/15

Is argument “days” required in =WORKDAY?

Question 6 of 15 6/15

Which function is NOT related to =WORKDAY?

Question 7 of 15 7/15

In =WORKDAY, which is argument #2?

Question 8 of 15 8/15

Which function is related to =WORKDAY?

Question 9 of 15 9/15

Is =WORKDAY volatile?

Question 10 of 15 10/15

Which formula is a valid example of =WORKDAY?

Question 11 of 15 11/15

Which category does =WORKDAY belong to?

Question 12 of 15 12/15

What usually causes #NUM! in =WORKDAY?

Question 13 of 15 13/15

Is argument “start_date” required in =WORKDAY?

Question 14 of 15 14/15

How many arguments does =WORKDAY have in total?

Question 15 of 15 15/15

In =WORKDAY, which is argument #3?

Click a question to see the answer.

1. Which use case fits =WORKDAY?

A. Reshape Tables
B. Date & Time Calculations ✓
C. Comparation
D. Daily Tasks

Explanation: Use case “Date & Time Calculations” fits WORKDAY.

2. Which is the correct syntax of =WORKDAY?

A. WORKDAY(start_date, days, [holidays])
B. =WORKDAY(start_date, days, [holidays], 0)
C. =TODAY(start_date, days, [holidays])
D. =WORKDAY(start_date, days, [holidays]) ✓

Explanation: Correct syntax: =WORKDAY(start_date, days, [holidays])

3. What is the fix for #VALUE! in =WORKDAY?

A. Text is always ignored
B. افزودن days به start_date تاریخی نامعتبر ایجاد می‌کند.
C. Requires add-in
D. Check the dates and the holiday range ✓

Explanation: If any argument is not a valid date, WORKDAY returns the #VALUE! error value. — Fix: Check the dates and the holiday range

4. What is the output type of =WORKDAY?

A. Text
B. Logical
C. Date ✓
D. Array

Explanation: Output is “Date”.

5. Is argument “days” required in =WORKDAY?

A. —
B. Yes ✓
C. Yes
D. No

Explanation: “days” is required.

6. Which function is NOT related to =WORKDAY?

A. TODAY
B. ATANH ✓
C. NETWORKDAYS
D. EDATE

Explanation: “ATANH” is not related to WORKDAY.

7. In =WORKDAY, which is argument #2?

A. holidays
B. value
C. lookup_value
D. days ✓

Explanation: Argument #2 is “days”.

8. Which function is related to =WORKDAY?

A. EXP
B. FUNC404
C. TODAY ✓
D. ISODD

Explanation: “TODAY” is related to WORKDAY.

9. Is =WORKDAY volatile?

A. No
B. Yes
C. No ✓
D. —

Explanation: WORKDAY is not volatile.

10. Which formula is a valid example of =WORKDAY?

A. =WORKDAY(A2,A3) ✓
B. WORKDAY(A2,A3)
C. =WORKDAY(A2,A3, 0)
D. =TODAY(A2,A3)

Explanation: Correct example: =WORKDAY(A2,A3)

11. Which category does =WORKDAY belong to?

A. Logical
B. Database
C. Date & Time ✓
D. Financial

Explanation: Category is “Date & Time”.

12. What usually causes #NUM! in =WORKDAY?

A. Select entire column for best performance
B. Text is always ignored
C. If start_date plus days yields an invalid date, WORKDAY returns the #NUM! error value. ✓
D. Requires add-in

Explanation: If start_date plus days yields an invalid date, WORKDAY returns the #NUM! error value. — Fix: مقدار days را کاهش دهید یا تاریخ شروع متفاوتی انتخاب کنید تا تاریخ حاصل معتبر باشد.

13. Is argument “start_date” required in =WORKDAY?

A. —
B. Yes ✓
C. Yes
D. No

Explanation: “start_date” is required.

14. How many arguments does =WORKDAY have in total?

A. 2
B. 5
C. 4
D. 3 ✓

Explanation: =WORKDAY has 2 required, 1 optional (3 total).

15. In =WORKDAY, which is argument #3?

A. start_date
B. range
C. criteria
D. holidays ✓

Explanation: Argument #3 is “holidays”.