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

Is argument “coupon” required in =MDURATION?

Question 2 of 10 2/10

How many optional arguments does =MDURATION have?

Question 3 of 10 3/10

In =MDURATION, which is argument #1?

Question 4 of 10 4/10

Which function is related to =MDURATION?

Question 5 of 10 5/10

Which statement about =MDURATION is correct?

Question 6 of 10 6/10

Which is the correct syntax of =MDURATION?

Question 7 of 10 7/10

What is the output type of =MDURATION?

Question 8 of 10 8/10

Which function is NOT related to =MDURATION?

Question 9 of 10 9/10

In =MDURATION, which is argument #3?

Question 10 of 10 10/10

Does =MDURATION return a dynamic array?

Click a question to see the answer.

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

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

Explanation: “coupon” is required.

2. How many optional arguments does =MDURATION have?

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

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

3. In =MDURATION, which is argument #1?

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

Explanation: Argument #1 is “settlement”.

4. Which function is related to =MDURATION?

A. TBILLYIELD
B. ISLOGICAL
C. DURATION ✓
D. CONFIDENCE.T

Explanation: “DURATION” is related to MDURATION.

5. Which statement about =MDURATION is correct?

A. 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. ✓
B. Volatile and recalculates every time
C. Requires add-in
D. The settlement date is the date a buyer purchases a coupon, such as a bond. The maturity date is the date when a coupon expires. For example, suppose a 30-year bond is issued on January 1, 2008, and is purchased by a buyer six months later. The issue date would be January 1, 2008, the settlement date would be July 1, 2008, and the maturity date is January 1, 2038, which is 30 years after the January 1, 2008, issue date.

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.

6. Which is the correct syntax of =MDURATION?

A. =DURATION(settlement, maturity, coupon, yld, frequency, [basis])
B. =MDURATION(settlement, maturity, coupon, yld, frequency, [basis], 0)
C. MDURATION(settlement, maturity, coupon, yld, frequency, [basis])
D. =MDURATION(settlement, maturity, coupon, yld, frequency, [basis]) ✓

Explanation: Correct syntax: =MDURATION(settlement, maturity, coupon, yld, frequency, [basis])

7. What is the output type of =MDURATION?

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

Explanation: Output is “Number”.

8. Which function is NOT related to =MDURATION?

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

Explanation: “VDB” is not related to MDURATION.

9. In =MDURATION, which is argument #3?

A. settlement
B. yld
C. coupon ✓
D. value

Explanation: Argument #3 is “coupon”.

10. Does =MDURATION return a dynamic array?

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

Explanation: MDURATION does not spill.