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

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

Question 2 of 15 2/15

Which function is 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

In =YEARFRAC, which is argument #2?

Question 6 of 15 6/15

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

Question 7 of 15 7/15

What usually causes #VALUE! in =YEARFRAC?

Question 8 of 15 8/15

Which formula is a valid example of =YEARFRAC?

Question 9 of 15 9/15

What is the output type of =YEARFRAC?

Question 10 of 15 10/15

In =YEARFRAC, which is argument #3?

Question 11 of 15 11/15

Is argument “basis” required in =YEARFRAC?

Question 12 of 15 12/15

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

Question 13 of 15 13/15

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

Question 14 of 15 14/15

Is =YEARFRAC volatile?

Question 15 of 15 15/15

Which is the correct syntax of =YEARFRAC?

Click a question to see the answer.

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

A. تاریخ‌ها را با تابع DATE وارد کنید و بررسی کنید سلول‌های تاریخ واقعاً تاریخ باشند. ✓
B. Only works in old versions
C. Volatile and recalculates every time
D. Output is always a dynamic array

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

2. Which function is related to =YEARFRAC?

A. INT ✓
B. CUMIPMT
C. VARP
D. SEC

Explanation: “INT” is 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. 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.
D. All arguments are truncated to integers.

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. Yes
B. Yes ✓
C. No
D. —

Explanation: “end_date” is required.

5. In =YEARFRAC, which is argument #2?

A. end_date ✓
B. basis
C. lookup_value
D. value

Explanation: Argument #2 is “end_date”.

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

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

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

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

A. Only works in old versions
B. If start_date or end_date are not valid dates, YEARFRAC returns the #VALUE! error value. ✓
C. Select entire column for best performance
D. Output is always a dynamic array

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

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

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

9. What is the output type of =YEARFRAC?

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

Explanation: Output is “Number”.

10. In =YEARFRAC, which is argument #3?

A. basis ✓
B. lookup_value
C. value
D. start_date

Explanation: Argument #3 is “basis”.

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

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

Explanation: “basis” is optional.

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

A. Date ✓
B. Mixed
C. Reference
D. Number

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

13. What is the type of argument “basis” in =YEARFRAC?

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

Explanation: Type of “basis” is “Number”.

14. Is =YEARFRAC volatile?

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

Explanation: YEARFRAC is not volatile.

15. Which is the correct syntax of =YEARFRAC?

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

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