Financial =ODDFYIELD(settlement, maturity, issue, first_coupon, rate, pr, redemption, frequency, [basis])

Quiz =ODDFYIELD — 15 Questions

15 quiz questions about =ODDFYIELD — test syntax, arguments, examples & errors!

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

← ODDFYIELD ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

Is =ODDFYIELD volatile?

Question 2 of 15 2/15

Is argument “settlement” required in =ODDFYIELD?

Question 3 of 15 3/15

In =ODDFYIELD, which is argument #3?

Question 4 of 15 4/15

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

Question 5 of 15 5/15

What usually causes #NUM! in =ODDFYIELD?

Question 6 of 15 6/15

What is the type of argument “maturity” in =ODDFYIELD?

Question 7 of 15 7/15

Is argument “basis” required in =ODDFYIELD?

Question 8 of 15 8/15

Is argument “first_coupon” required in =ODDFYIELD?

Question 9 of 15 9/15

What is the output type of =ODDFYIELD?

Question 10 of 15 10/15

Is argument “rate” required in =ODDFYIELD?

Question 11 of 15 11/15

Which statement about =ODDFYIELD is correct?

Question 12 of 15 12/15

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

Question 13 of 15 13/15

Which category does =ODDFYIELD belong to?

Question 14 of 15 14/15

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

Question 15 of 15 15/15

How many optional arguments does =ODDFYIELD have?

Click a question to see the answer.

1. Is =ODDFYIELD volatile?

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

Explanation: ODDFYIELD is not volatile.

2. Is argument “settlement” required in =ODDFYIELD?

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

Explanation: “settlement” is required.

3. In =ODDFYIELD, which is argument #3?

A. criteria
B. pr
C. rate
D. issue ✓

Explanation: Argument #3 is “issue”.

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

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

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

5. What usually causes #NUM! in =ODDFYIELD?

A. Only works in old versions
B. If rate < 0 or if pr ≤ 0, ODDFYIELD returns the #NUM! error value. If basis < 0 or if basis > 4, ODDFYIELD returns the #NUM! error value. The following date condition must be satisfied; otherwise, ODDFYIELD returns the #NUM! error value: maturity > first_coupon > settlement > issue ✓
C. Volatile and recalculates every time
D. مقدار settlement یا maturity یا issue یا first_coupon تاریخ معتبری نیست.

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

6. What is the type of argument “maturity” in =ODDFYIELD?

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

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

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

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

Explanation: “basis” is optional.

8. Is argument “first_coupon” required in =ODDFYIELD?

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

Explanation: “first_coupon” is required.

9. What is the output type of =ODDFYIELD?

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

Explanation: Output is “Number”.

10. Is argument “rate” required in =ODDFYIELD?

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

Explanation: “rate” is required.

11. Which statement about =ODDFYIELD 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. Excel uses an iterative technique to calculate ODDFYIELD. This function uses the Newton method based on the formula used for the function ODDFPRICE. The yield is changed through 100 iterations until the estimated price with the given yield is close to the price. See ODDFPRICE for the formula that ODDFYIELD uses.
C. Settlement, maturity, issue, first_coupon, and basis are truncated to integers.
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.

12. What is the type of argument “settlement” in =ODDFYIELD?

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

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

13. Which category does =ODDFYIELD belong to?

A. Statistical
B. Information
C. Lookup & Reference
D. Financial ✓

Explanation: Category is “Financial”.

14. What is the type of argument “frequency” in =ODDFYIELD?

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

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

15. How many optional arguments does =ODDFYIELD have?

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

Explanation: =ODDFYIELD has 8 required, 1 optional (9 total).