Financial =ODDFPRICE(settlement, maturity, issue, first_coupon, rate, yld, redemption, frequency, [basis])

Quiz =ODDFPRICE — 10 Questions

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

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

← ODDFPRICE ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

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

Question 2 of 10 2/10

In =ODDFPRICE, which is argument #3?

Question 3 of 10 3/10

What usually causes #VALUE! in =ODDFPRICE?

Question 4 of 10 4/10

What is the type of argument “redemption” in =ODDFPRICE?

Question 5 of 10 5/10

What is the type of argument “rate” in =ODDFPRICE?

Question 6 of 10 6/10

Is argument “settlement” required in =ODDFPRICE?

Question 7 of 10 7/10

Which statement about =ODDFPRICE is correct?

Question 8 of 10 8/10

In =ODDFPRICE, which is argument #1?

Question 9 of 10 9/10

Since which Excel version is =ODDFPRICE available?

Question 10 of 10 10/10

Is argument “maturity” required in =ODDFPRICE?

Click a question to see the answer.

1. What is the type of argument “settlement” in =ODDFPRICE?

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

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

2. In =ODDFPRICE, which is argument #3?

A. maturity
B. first_coupon
C. issue ✓
D. settlement

Explanation: Argument #3 is “issue”.

3. What usually causes #VALUE! in =ODDFPRICE?

A. If settlement, maturity, issue, or first_coupon is not a valid date, ODDFPRICE returns the #VALUE! error value. ✓
B. مقدار rate یا yld منفی است، مقدار basis خارج از 0 تا 4 است، یا شرط maturity > first_coupon > settlement > issue برقرار نیست.
C. Select entire column for best performance
D. Only works in old versions

Explanation: If settlement, maturity, issue, or first_coupon is not a valid date, ODDFPRICE returns the #VALUE! error value. — Fix: تاریخ‌ها را با تابع DATE وارد کنید و از معتبر بودن آن‌ها مطمئن شوید.

4. What is the type of argument “redemption” in =ODDFPRICE?

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

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

5. What is the type of argument “rate” in =ODDFPRICE?

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

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

6. Is argument “settlement” required in =ODDFPRICE?

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

Explanation: “settlement” is required.

7. Which statement about =ODDFPRICE is correct?

A. 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 would be January 1, 2038, which is 30 years after the January 1, 2008, issue date.
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. Microsoft 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, 2008 is serial number 39448 because it is 39,448 days after January 1, 1900.
D. Text is always ignored

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.

8. In =ODDFPRICE, which is argument #1?

A. basis
B. lookup_value
C. settlement ✓
D. issue

Explanation: Argument #1 is “settlement”.

9. Since which Excel version is =ODDFPRICE available?

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

Explanation: Version: “All versions”.

10. Is argument “maturity” required in =ODDFPRICE?

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

Explanation: “maturity” is required.