Financial =ODDLPRICE(settlement, maturity, last_interest, rate, yld, redemption, frequency, [basis])

Quiz =ODDLPRICE — 10 Questions

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

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

← ODDLPRICE ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

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

Question 2 of 10 2/10

Is =ODDLPRICE volatile?

Question 3 of 10 3/10

What usually causes #NUM! in =ODDLPRICE?

Question 4 of 10 4/10

Is argument “maturity” required in =ODDLPRICE?

Question 5 of 10 5/10

What is the type of argument “last_interest” in =ODDLPRICE?

Question 6 of 10 6/10

Does =ODDLPRICE return a dynamic array?

Question 7 of 10 7/10

Is argument “basis” required in =ODDLPRICE?

Question 8 of 10 8/10

Which category does =ODDLPRICE belong to?

Question 9 of 10 9/10

Which statement about =ODDLPRICE is correct?

Question 10 of 10 10/10

Which formula is a valid example of =ODDLPRICE?

Click a question to see the answer.

1. What is the fix for #NUM! in =ODDLPRICE?

A. Check the order of the dates and the input values ✓
B. Volatile and recalculates every time
C. Only works in old versions
D. Output is always a dynamic array

Explanation: If rate < 0 or if yld < 0, ODDLPRICE returns the #NUM! error value. If basis < 0 or if basis > 4, ODDLPRICE returns the #NUM! error value. The following date condition must be satisfied; otherwise, ODDLPRICE returns the #NUM! error value: maturity > settlement > last_interest — Fix: Check the order of the dates and the input values

2. Is =ODDLPRICE volatile?

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

Explanation: ODDLPRICE is not volatile.

3. What usually causes #NUM! in =ODDLPRICE?

A. مقدار settlement یا maturity یا last_interest تاریخ معتبری نیست.
B. Requires add-in
C. Volatile and recalculates every time
D. If rate < 0 or if yld < 0, ODDLPRICE returns the #NUM! error value. If basis < 0 or if basis > 4, ODDLPRICE returns the #NUM! error value. The following date condition must be satisfied; otherwise, ODDLPRICE returns the #NUM! error value: maturity > settlement > last_interest ✓

4. Is argument “maturity” required in =ODDLPRICE?

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

Explanation: “maturity” is required.

5. What is the type of argument “last_interest” in =ODDLPRICE?

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

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

6. Does =ODDLPRICE return a dynamic array?

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

Explanation: ODDLPRICE does not spill.

7. Is argument “basis” required in =ODDLPRICE?

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

Explanation: “basis” is optional.

8. Which category does =ODDLPRICE belong to?

A. Web
B. Text
C. Financial ✓
D. Cube

Explanation: Category is “Financial”.

9. Which statement about =ODDLPRICE 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. 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.
C. Volatile and recalculates every time
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 would be 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.

10. Which formula is a valid example of =ODDLPRICE?

A. =ODDFPRICE(A2, A3, A4, A5, A6, A7, A8, A9)
B. ODDLPRICE(A2, A3, A4, A5, A6, A7, A8, A9)
C. =ODDLPRICE(A2, A3, A4, A5, A6, A7, A8, A9) ✓
D. =ODDLPRICE(A2, A3, A4, A5, A6, A7, A8, A9, 0)

Explanation: Correct example: =ODDLPRICE(A2, A3, A4, A5, A6, A7, A8, A9)