Date & Time =DATEDIF(start_date,end_date,unit)

Quiz =DATEDIF — 10 Questions

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

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

← DATEDIF ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

How many required arguments does =DATEDIF have?

Question 2 of 10 2/10

What is the type of argument “unit” in =DATEDIF?

Question 3 of 10 3/10

In =DATEDIF, which is argument #2?

Question 4 of 10 4/10

What is the fix for #NUM! in =DATEDIF?

Question 5 of 10 5/10

Which function is NOT related to =DATEDIF?

Question 6 of 10 6/10

Is argument “unit” required in =DATEDIF?

Question 7 of 10 7/10

Which category does =DATEDIF belong to?

Question 8 of 10 8/10

What usually causes #NUM! in =DATEDIF?

Question 9 of 10 9/10

Which function is related to =DATEDIF?

Question 10 of 10 10/10

Which use case fits =DATEDIF?

Click a question to see the answer.

1. How many required arguments does =DATEDIF have?

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

Explanation: =DATEDIF has 3 required, 0 optional (3 total).

2. What is the type of argument “unit” in =DATEDIF?

A. Reference
B. Value
C. Text ✓
D. Date

Explanation: Type of “unit” is “Text”.

3. In =DATEDIF, which is argument #2?

A. range
B. start_date
C. lookup_value
D. end_date ✓

Explanation: Argument #2 is “end_date”.

4. What is the fix for #NUM! in =DATEDIF?

A. Volatile and recalculates every time
B. Output is always a dynamic array
C. Requires add-in
D. Swap the two dates and check the unit ✓

Explanation: If the start_date is greater than the end_date, the result will be #NUM!. — Fix: Swap the two dates and check the unit

5. Which function is NOT related to =DATEDIF?

A. DAYS
B. TODAY
C. YEAR
D. MROUND ✓

Explanation: “MROUND” is not related to DATEDIF.

6. Is argument “unit” required in =DATEDIF?

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

Explanation: “unit” is required.

7. Which category does =DATEDIF belong to?

A. Logical
B. Date & Time ✓
C. Cube
D. Information

Explanation: Category is “Date & Time”.

8. What usually causes #NUM! in =DATEDIF?

A. Text is always ignored
B. If the start_date is greater than the end_date, the result will be #NUM!. ✓
C. Requires add-in
D. Output is always a dynamic array

Explanation: If the start_date is greater than the end_date, the result will be #NUM!. — Fix: Swap the two dates and check the unit

9. Which function is related to =DATEDIF?

A. TODAY ✓
B. NORM.DIST
C. CALL
D. SUMSQ

Explanation: “TODAY” is related to DATEDIF.

10. Which use case fits =DATEDIF?

A. Investment Appraisal
B. Scientific & Unit Conversion
C. Daily Tasks ✓
D. Workdays & Due Dates

Explanation: Use case “Daily Tasks” fits DATEDIF.