Financial =DURATION(settlement, maturity, coupon, yld, frequency, [basis])

Quiz =DURATION — 15 Questions

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

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

← DURATION ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

Is argument “basis” required in =DURATION?

Question 2 of 15 2/15

What is the type of argument “settlement” in =DURATION?

Question 3 of 15 3/15

Which statement about =DURATION is correct?

Question 4 of 15 4/15

In =DURATION, which is argument #1?

Question 5 of 15 5/15

Is =DURATION volatile?

Question 6 of 15 6/15

What is the type of argument “coupon” in =DURATION?

Question 7 of 15 7/15

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

Question 8 of 15 8/15

What usually causes #NUM! in =DURATION?

Question 9 of 15 9/15

Which formula is a valid example of =DURATION?

Question 10 of 15 10/15

Which function is NOT related to =DURATION?

Question 11 of 15 11/15

How many arguments does =DURATION have in total?

Question 12 of 15 12/15

How many optional arguments does =DURATION have?

Question 13 of 15 13/15

Which category does =DURATION belong to?

Question 14 of 15 14/15

What usually causes #VALUE! in =DURATION?

Question 15 of 15 15/15

What is the type of argument “maturity” in =DURATION?

Click a question to see the answer.

1. Is argument “basis” required in =DURATION?

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

Explanation: “basis” is optional.

2. What is the type of argument “settlement” in =DURATION?

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

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

3. Which statement about =DURATION is correct?

A. 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. ✓
B. Requires add-in
C. Select entire column for best performance
D. Only works in old versions

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.

4. In =DURATION, which is argument #1?

A. settlement ✓
B. range
C. coupon
D. basis

Explanation: Argument #1 is “settlement”.

5. Is =DURATION volatile?

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

Explanation: DURATION is not volatile.

6. What is the type of argument “coupon” in =DURATION?

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

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

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

A. Requires add-in
B. Select entire column for best performance
C. Check the order of the dates and the input values ✓
D. Volatile and recalculates every time

Explanation: If coupon < 0 or if yld < 0, DURATION returns the #NUM! error value. If frequency is any number other than 1, 2, or 4, DURATION returns the #NUM! error value. If basis < 0 or if basis > 4, DURATION returns the #NUM! error value. If settlement ≥ maturity, DURATION returns the #NUM! error value. — Fix: Check the order of the dates and the input values

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

A. Volatile and recalculates every time
B. Select entire column for best performance
C. If coupon < 0 or if yld < 0, DURATION returns the #NUM! error value. If frequency is any number other than 1, 2, or 4, DURATION returns the #NUM! error value. If basis < 0 or if basis > 4, DURATION returns the #NUM! error value. If settlement ≥ maturity, DURATION returns the #NUM! error value. ✓
D. Text is always ignored

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

A. DURATION(A2,A3,A4,A5,A6,A7)
B. =DURATION(A2,A3,A4,A5,A6,A7, 0)
C. =MDURATION(A2,A3,A4,A5,A6,A7)
D. =DURATION(A2,A3,A4,A5,A6,A7) ✓

Explanation: Correct example: =DURATION(A2,A3,A4,A5,A6,A7)

10. Which function is NOT related to =DURATION?

A. SERIESSUM ✓
B. PRICE
C. YIELD
D. MDURATION

Explanation: “SERIESSUM” is not related to DURATION.

11. How many arguments does =DURATION have in total?

A. 7
B. 5
C. 8
D. 6 ✓

Explanation: =DURATION has 5 required, 1 optional (6 total).

12. How many optional arguments does =DURATION have?

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

Explanation: =DURATION has 5 required, 1 optional (6 total).

13. Which category does =DURATION belong to?

A. Financial ✓
B. Compatibility
C. Information
D. Database

Explanation: Category is “Financial”.

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

A. Volatile and recalculates every time
B. If settlement or maturity is not a valid date, DURATION returns the #VALUE! error value. ✓
C. مقدار coupon یا yld منفی است، تناوب جز ۱، ۲ یا ۴ است، مبنا خارج از ۰ تا ۴ است، یا تسویه مساوی یا بعد از سررسید است.
D. Requires add-in

Explanation: If settlement or maturity is not a valid date, DURATION returns the #VALUE! error value. — Fix: تاریخ‌ها را با تابع DATE وارد کنید و مطمئن شوید سلول‌ها واقعاً تاریخ هستند، نه متن.

15. What is the type of argument “maturity” in =DURATION?

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

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