Date & Time =NETWORKDAYS(start_date, end_date, [holidays])

Quiz =NETWORKDAYS — 10 Questions

10 quiz questions about =NETWORKDAYS — test syntax, arguments, examples & errors!

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

← NETWORKDAYS ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

Which function is NOT related to =NETWORKDAYS?

Question 2 of 10 2/10

Which statement about =NETWORKDAYS is correct?

Question 3 of 10 3/10

How many arguments does =NETWORKDAYS have in total?

Question 4 of 10 4/10

What is the output type of =NETWORKDAYS?

Question 5 of 10 5/10

What is the type of argument “holidays” in =NETWORKDAYS?

Question 6 of 10 6/10

How many required arguments does =NETWORKDAYS have?

Question 7 of 10 7/10

Does =NETWORKDAYS return a dynamic array?

Question 8 of 10 8/10

In =NETWORKDAYS, which is argument #3?

Question 9 of 10 9/10

Is argument “start_date” required in =NETWORKDAYS?

Question 10 of 10 10/10

What is the type of argument “start_date” in =NETWORKDAYS?

Click a question to see the answer.

1. Which function is NOT related to =NETWORKDAYS?

A. WORKDAY
B. DAYS
C. TODAY
D. SMALL ✓

Explanation: “SMALL” is not related to NETWORKDAYS.

2. Which statement about =NETWORKDAYS is correct?

A. Text is always ignored
B. To calculate whole workdays between two dates by using parameters to indicate which and how many days are weekend days, use the NETWORKDAYS.INTL function. ✓
C. Only works in old versions
D. Volatile and recalculates every time

Explanation: Correct: To calculate whole workdays between two dates by using parameters to indicate which and how many days are weekend days, use the NETWORKDAYS.INTL function.

3. How many arguments does =NETWORKDAYS have in total?

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

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

4. What is the output type of =NETWORKDAYS?

A. Mixed
B. Array
C. Logical
D. Number ✓

Explanation: Output is “Number”.

5. What is the type of argument “holidays” in =NETWORKDAYS?

A. Range ✓
B. Array
C. Number
D. Date

Explanation: Type of “holidays” is “Range”.

6. How many required arguments does =NETWORKDAYS have?

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

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

7. Does =NETWORKDAYS return a dynamic array?

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

Explanation: NETWORKDAYS does not spill.

8. In =NETWORKDAYS, which is argument #3?

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

Explanation: Argument #3 is “holidays”.

9. Is argument “start_date” required in =NETWORKDAYS?

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

Explanation: “start_date” is required.

10. What is the type of argument “start_date” in =NETWORKDAYS?

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

Explanation: Type of “start_date” is “Date”.