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

In =ODDFYIELD, which is argument #3?

Question 2 of 15 2/15

In =ODDFYIELD, which is argument #2?

Question 3 of 15 3/15

Which is the correct syntax of =ODDFYIELD?

Question 4 of 15 4/15

Is argument “first_coupon” required in =ODDFYIELD?

Question 5 of 15 5/15

Is argument “rate” required in =ODDFYIELD?

Question 6 of 15 6/15

What is the output type of =ODDFYIELD?

Question 7 of 15 7/15

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

Question 8 of 15 8/15

Is argument “issue” required in =ODDFYIELD?

Question 9 of 15 9/15

Is argument “settlement” required in =ODDFYIELD?

Question 10 of 15 10/15

Which statement about =ODDFYIELD is correct?

Question 11 of 15 11/15

How many optional arguments does =ODDFYIELD have?

Question 12 of 15 12/15

What usually causes #VALUE! in =ODDFYIELD?

Question 13 of 15 13/15

How many arguments does =ODDFYIELD have in total?

Question 14 of 15 14/15

Is argument “basis” required in =ODDFYIELD?

Question 15 of 15 15/15

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

Click a question to see the answer.

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

A. maturity
B. value
C. rate
D. issue ✓

Explanation: Argument #3 is “issue”.

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

A. settlement
B. frequency
C. maturity ✓
D. pr

Explanation: Argument #2 is “maturity”.

3. Which is the correct syntax of =ODDFYIELD?

A. =ODDFYIELD(settlement, maturity, issue, first_coupon, rate, pr, redemption, frequency, [basis]) ✓
B. =ODDFYIELD(settlement, maturity, issue, first_coupon, rate, pr, redemption, frequency, [basis], 0)
C. =ODDFPRICE(settlement, maturity, issue, first_coupon, rate, pr, redemption, frequency, [basis])
D. ODDFYIELD(settlement, maturity, issue, first_coupon, rate, pr, redemption, frequency, [basis])

Explanation: Correct syntax: =ODDFYIELD(settlement, maturity, issue, first_coupon, rate, pr, redemption, frequency, [basis])

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

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

Explanation: “first_coupon” is required.

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

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

Explanation: “rate” is required.

6. What is the output type of =ODDFYIELD?

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

Explanation: Output is “Number”.

7. What is the type of argument “basis” in =ODDFYIELD?

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

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

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

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

Explanation: “issue” is required.

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

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

Explanation: “settlement” is required.

10. Which statement about =ODDFYIELD is correct?

A. 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.
B. Settlement, maturity, issue, first_coupon, and basis are truncated to integers.
C. 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.
D. 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. ✓

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.

11. How many optional arguments does =ODDFYIELD have?

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

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

12. What usually causes #VALUE! in =ODDFYIELD?

A. Text is always ignored
B. Output is always a dynamic array
C. If settlement, maturity, issue, or first_coupon is not a valid date, ODDFYIELD returns the #VALUE! error value. ✓
D. Volatile and recalculates every time

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

13. How many arguments does =ODDFYIELD have in total?

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

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

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

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

Explanation: “basis” is optional.

15. What is the fix for #NUM! in =ODDFYIELD?

A. Only works in old versions
B. مقدار settlement یا maturity یا issue یا first_coupon تاریخ معتبری نیست.
C. Text is always ignored
D. Check the order of the dates and the input values ✓

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