Financial =ODDLYIELD(settlement, maturity, last_interest, rate, pr, redemption, frequency, [basis])

Quiz =ODDLYIELD — 10 Questions

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

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

← ODDLYIELD ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

What is the output type of =ODDLYIELD?

Question 2 of 10 2/10

Is argument “last_interest” required in =ODDLYIELD?

Question 3 of 10 3/10

Which is the correct syntax of =ODDLYIELD?

Question 4 of 10 4/10

Which statement about =ODDLYIELD is correct?

Question 5 of 10 5/10

Is argument “redemption” required in =ODDLYIELD?

Question 6 of 10 6/10

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

Question 7 of 10 7/10

What usually causes #VALUE! in =ODDLYIELD?

Question 8 of 10 8/10

Is argument “basis” required in =ODDLYIELD?

Question 9 of 10 9/10

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

Question 10 of 10 10/10

In =ODDLYIELD, which is argument #3?

Click a question to see the answer.

1. What is the output type of =ODDLYIELD?

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

Explanation: Output is “Number”.

2. Is argument “last_interest” required in =ODDLYIELD?

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

Explanation: “last_interest” is required.

3. Which is the correct syntax of =ODDLYIELD?

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

Explanation: Correct syntax: =ODDLYIELD(settlement, maturity, last_interest, rate, pr, redemption, frequency, [basis])

4. Which statement about =ODDLYIELD is correct?

A. Select entire column for best performance
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. Text is always ignored
D. Output is always a dynamic array

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.

5. Is argument “redemption” required in =ODDLYIELD?

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

Explanation: “redemption” is required.

6. What is the type of argument “frequency” in =ODDLYIELD?

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

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

7. What usually causes #VALUE! in =ODDLYIELD?

A. Volatile and recalculates every time
B. Output is always a dynamic array
C. If settlement, maturity, or last_interest is not a valid date, ODDLYIELD returns the #VALUE! error value. ✓
D. مقدار rate منفی یا pr کوچک‌تر یا مساوی صفر است، مقدار basis خارج از 0 تا 4 است، یا شرط maturity > settlement > last_interest برقرار نیست.

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

8. Is argument “basis” required in =ODDLYIELD?

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

Explanation: “basis” is optional.

9. What is the fix for #NUM! in =ODDLYIELD?

A. Text is always ignored
B. Volatile and recalculates every time
C. Select entire column for best performance
D. Check the order of the dates and the input values ✓

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

10. In =ODDLYIELD, which is argument #3?

A. criteria
B. last_interest ✓
C. basis
D. value

Explanation: Argument #3 is “last_interest”.