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

Quiz =MDURATION — 10 Questions

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

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

← MDURATION ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

Which statement about =MDURATION is correct?

Question 2 of 10 2/10

Which function is NOT related to =MDURATION?

Question 3 of 10 3/10

Is argument “coupon” required in =MDURATION?

Question 4 of 10 4/10

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

Question 5 of 10 5/10

How many arguments does =MDURATION have in total?

Question 6 of 10 6/10

Is argument “frequency” required in =MDURATION?

Question 7 of 10 7/10

Is argument “yld” required in =MDURATION?

Question 8 of 10 8/10

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

Question 9 of 10 9/10

What usually causes #VALUE! in =MDURATION?

Question 10 of 10 10/10

What is the type of argument “frequency” in =MDURATION?

Click a question to see the answer.

1. Which statement about =MDURATION is correct?

A. Settlement, maturity, frequency, and basis are truncated to integers.
B. Dates should be entered by using the DATE function, or as results of other formulas or functions. For example, use DATE(2008,5,23) for the 23rd day of May, 2008. Problems can occur if dates are entered as text. ✓
C. Modified duration is defined as follows:
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(2008,5,23) for the 23rd day of May, 2008. Problems can occur if dates are entered as text.

2. Which function is NOT related to =MDURATION?

A. PRICE
B. MDURATION_X
C. ROW ✓
D. DURATION

Explanation: “ROW” is not related to MDURATION.

3. Is argument “coupon” required in =MDURATION?

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

Explanation: “coupon” is required.

4. What is the type of argument “coupon” in =MDURATION?

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

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

5. How many arguments does =MDURATION have in total?

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

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

6. Is argument “frequency” required in =MDURATION?

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

Explanation: “frequency” is required.

7. Is argument “yld” required in =MDURATION?

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

Explanation: “yld” is required.

8. What is the fix for #NUM! in =MDURATION?

A. Check the order of the dates and the input values ✓
B. Volatile and recalculates every time
C. Output is always a dynamic array
D. Requires add-in

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

9. What usually causes #VALUE! in =MDURATION?

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

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

10. What is the type of argument “frequency” in =MDURATION?

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

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