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

Which statement about =ODDLPRICE is correct?

Question 2 of 10 2/10

Is argument “rate” required in =ODDLPRICE?

Question 3 of 10 3/10

How many arguments does =ODDLPRICE have in total?

Question 4 of 10 4/10

Which formula is a valid example of =ODDLPRICE?

Question 5 of 10 5/10

Which use case fits =ODDLPRICE?

Question 6 of 10 6/10

Is argument “yld” required in =ODDLPRICE?

Question 7 of 10 7/10

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

Question 8 of 10 8/10

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

Question 9 of 10 9/10

Is argument “basis” required in =ODDLPRICE?

Question 10 of 10 10/10

Which function is related to =ODDLPRICE?

Click a question to see the answer.

1. 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. Text is always ignored
C. Settlement, maturity, last_interest, and basis are truncated to integers.
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.

2. Is argument “rate” required in =ODDLPRICE?

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

Explanation: “rate” is required.

3. How many arguments does =ODDLPRICE have in total?

A. 9
B. 8 ✓
C. 7
D. 10

Explanation: =ODDLPRICE has 7 required, 1 optional (8 total).

4. 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)

5. Which use case fits =ODDLPRICE?

A. External Data, Web & Cube
B. Probability & Hypothesis Testing
C. Financial Calculations ✓
D. Daily Tasks

Explanation: Use case “Financial Calculations” fits ODDLPRICE.

6. Is argument “yld” required in =ODDLPRICE?

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

Explanation: “yld” is required.

7. What is the type of argument “yld” in =ODDLPRICE?

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

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

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

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

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

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

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

Explanation: “basis” is optional.

10. Which function is related to =ODDLPRICE?

A. FORECAST.ETS.CONFINT
B. CSC
C. ODDFPRICE ✓
D. DAYS360

Explanation: “ODDFPRICE” is related to ODDLPRICE.