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

Quiz =YEARFRAC — 10 Questions

10 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 — 10 questions 1 of 10

Question 1 of 10 1/10

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

Question 2 of 10 2/10

Which statement about =YEARFRAC is correct?

Question 3 of 10 3/10

Since which Excel version is =YEARFRAC available?

Question 4 of 10 4/10

Which function is related to =YEARFRAC?

Question 5 of 10 5/10

What is the output type of =YEARFRAC?

Question 6 of 10 6/10

Is argument “start_date” required in =YEARFRAC?

Question 7 of 10 7/10

Does =YEARFRAC return a dynamic array?

Question 8 of 10 8/10

Which function is NOT related to =YEARFRAC?

Question 9 of 10 9/10

Which formula is a valid example of =YEARFRAC?

Question 10 of 10 10/10

In =YEARFRAC, which is argument #1?

Click a question to see the answer.

1. What is the type of argument “start_date” in =YEARFRAC?

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

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

2. Which statement about =YEARFRAC is correct?

A. Only works in old versions
B. Text is always ignored
C. 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. ✓
D. Requires add-in

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.

3. Since which Excel version is =YEARFRAC available?

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

Explanation: Version: “All versions”.

4. Which function is related to =YEARFRAC?

A. MODE.SNGL
B. ACOSH
C. VALUETOTEXT
D. INT ✓

Explanation: “INT” is related to YEARFRAC.

5. What is the output type of =YEARFRAC?

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

Explanation: Output is “Number”.

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

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

Explanation: “start_date” is required.

7. Does =YEARFRAC return a dynamic array?

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

Explanation: YEARFRAC does not spill.

8. Which function is NOT related to =YEARFRAC?

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

Explanation: “IFS” is not related to YEARFRAC.

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

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

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

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

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

Explanation: Argument #1 is “start_date”.