Date & Time =YEARFRAC(start_date, end_date, [basis])

Quiz =YEARFRAC — 15 Questions

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

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

← YEARFRAC ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

Which category does =YEARFRAC belong to?

Question 2 of 15 2/15

Which function is NOT related to =YEARFRAC?

Question 3 of 15 3/15

Which statement about =YEARFRAC is correct?

Question 4 of 15 4/15

Is argument “end_date” required in =YEARFRAC?

Question 5 of 15 5/15

Is argument “start_date” required in =YEARFRAC?

Question 6 of 15 6/15

Is argument “basis” required in =YEARFRAC?

Question 7 of 15 7/15

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

Question 8 of 15 8/15

Since which Excel version is =YEARFRAC available?

Question 9 of 15 9/15

What is the type of argument “end_date” in =YEARFRAC?

Question 10 of 15 10/15

Which is the correct syntax of =YEARFRAC?

Question 11 of 15 11/15

Which formula is a valid example of =YEARFRAC?

Question 12 of 15 12/15

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

Question 13 of 15 13/15

Is =YEARFRAC volatile?

Question 14 of 15 14/15

What usually causes #VALUE! in =YEARFRAC?

Question 15 of 15 15/15

How many required arguments does =YEARFRAC have?

Click a question to see the answer.

1. Which category does =YEARFRAC belong to?

A. Statistical
B. Date & Time ✓
C. Compatibility
D. Engineering

Explanation: Category is “Date & Time”.

2. Which function is NOT related to =YEARFRAC?

A. NORMSDIST ✓
B. INT
C. DATEDIF
D. TODAY

Explanation: “NORMSDIST” is not related to YEARFRAC.

3. Which statement about =YEARFRAC is correct?

A. Requires add-in
B. Dates should be entered by using the DATE function, or as results of other formulas or functions. For example, use DATE(2018,5,23) for the 23rd day of May, 2018. Problems can occur if dates are entered as text. The YEARFRAC function may return an incorrect result when using the US (NASD) 30/360 basis, and the start_date is the last day in February. ✓
C. Text is always ignored
D. Excel stores dates as sequential serial numbers so they can be used in calculations. By default, January 1, 1900 is serial number 1, and January 1, 2018 is serial number 43101 because it is 43,101 days after January 1, 1900.

Explanation: Correct: Dates should be entered by using the DATE function, or as results of other formulas or functions. For example, use DATE(2018,5,23) for the 23rd day of May, 2018. Problems can occur if dates are entered as text. The YEARFRAC function may return an incorrect result when using the US (NASD) 30/360 basis, and the start_date is the last day in February.

4. Is argument “end_date” required in =YEARFRAC?

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

Explanation: “end_date” is required.

5. Is argument “start_date” required in =YEARFRAC?

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

Explanation: “start_date” is required.

6. Is argument “basis” required in =YEARFRAC?

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

Explanation: “basis” is optional.

7. What is the fix for #NUM! in =YEARFRAC?

A. Text is always ignored
B. Output is always a dynamic array
C. مقدار start_date یا end_date تاریخ معتبری نیست.
D. Correct the third argument ✓

Explanation: If basis < 0 or if basis > 4, YEARFRAC returns the #NUM! error value. — Fix: Correct the third argument

8. Since which Excel version is =YEARFRAC available?

A. Excel 365
B. All versions ✓
C. Excel 2007 (Compatibility)
D. Excel 2019

Explanation: Version: “All versions”.

9. What is the type of argument “end_date” in =YEARFRAC?

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

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

10. Which is the correct syntax of =YEARFRAC?

A. =YEARFRAC(start_date, end_date, [basis], 0)
B. =INT(start_date, end_date, [basis])
C. YEARFRAC(start_date, end_date, [basis])
D. =YEARFRAC(start_date, end_date, [basis]) ✓

Explanation: Correct syntax: =YEARFRAC(start_date, end_date, [basis])

11. Which formula is a valid example of =YEARFRAC?

A. =YEARFRAC(A2,A3, 0)
B. =YEARFRAC(A2,A3) ✓
C. YEARFRAC(A2,A3)
D. =INT(A2,A3)

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

12. What is the fix for #VALUE! in =YEARFRAC?

A. Select entire column for best performance
B. تاریخ‌ها را با تابع DATE وارد کنید و بررسی کنید سلول‌های تاریخ واقعاً تاریخ باشند. ✓
C. مقدار basis کوچک‌تر از ۰ یا بزرگ‌تر از ۴ است.
D. Text is always ignored

Explanation: If start_date or end_date are not valid dates, YEARFRAC returns the #VALUE! error value. — Fix: تاریخ‌ها را با تابع DATE وارد کنید و بررسی کنید سلول‌های تاریخ واقعاً تاریخ باشند.

13. Is =YEARFRAC volatile?

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

Explanation: YEARFRAC is not volatile.

14. What usually causes #VALUE! in =YEARFRAC?

A. مقدار basis کوچک‌تر از ۰ یا بزرگ‌تر از ۴ است.
B. Text is always ignored
C. Requires add-in
D. If start_date or end_date are not valid dates, YEARFRAC returns the #VALUE! error value. ✓

15. How many required arguments does =YEARFRAC have?

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

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