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

Quiz =ODDLYIELD — 15 Questions

15 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 — 15 questions 1 of 15

Question 1 of 15 1/15

Is argument “redemption” required in =ODDLYIELD?

Question 2 of 15 2/15

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

Question 3 of 15 3/15

Which category does =ODDLYIELD belong to?

Question 4 of 15 4/15

Is argument “settlement” required in =ODDLYIELD?

Question 5 of 15 5/15

Is =ODDLYIELD volatile?

Question 6 of 15 6/15

In =ODDLYIELD, which is argument #2?

Question 7 of 15 7/15

Is argument “basis” required in =ODDLYIELD?

Question 8 of 15 8/15

Does =ODDLYIELD return a dynamic array?

Question 9 of 15 9/15

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

Question 10 of 15 10/15

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

Question 11 of 15 11/15

Since which Excel version is =ODDLYIELD available?

Question 12 of 15 12/15

Is argument “last_interest” required in =ODDLYIELD?

Question 13 of 15 13/15

What is the output type of =ODDLYIELD?

Question 14 of 15 14/15

Which statement about =ODDLYIELD is correct?

Question 15 of 15 15/15

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

Click a question to see the answer.

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

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

Explanation: “redemption” is required.

2. What is the type of argument “last_interest” in =ODDLYIELD?

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

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

3. Which category does =ODDLYIELD belong to?

A. Cube
B. Financial ✓
C. Statistical
D. Logical

Explanation: Category is “Financial”.

4. Is argument “settlement” required in =ODDLYIELD?

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

Explanation: “settlement” is required.

5. Is =ODDLYIELD volatile?

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

Explanation: ODDLYIELD is not volatile.

6. In =ODDLYIELD, which is argument #2?

A. redemption
B. maturity ✓
C. last_interest
D. pr

Explanation: Argument #2 is “maturity”.

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

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

Explanation: “basis” is optional.

8. Does =ODDLYIELD return a dynamic array?

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

Explanation: ODDLYIELD does not spill.

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

A. Text is always ignored
B. تاریخ‌ها را با تابع DATE وارد کنید و از صحت آن‌ها اطمینان حاصل کنید. ✓
C. Output is always a dynamic array
D. Requires add-in

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

10. What is the type of argument “redemption” in =ODDLYIELD?

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

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

11. Since which Excel version is =ODDLYIELD available?

A. All versions ✓
B. Excel 2019
C. Excel 365
D. Excel 2007 (Compatibility)

Explanation: Version: “All versions”.

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

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

Explanation: “last_interest” is required.

13. What is the output type of =ODDLYIELD?

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

Explanation: Output is “Number”.

14. Which statement about =ODDLYIELD 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. Output is always a dynamic array
C. Only works in old versions
D. Settlement, maturity, last_interest, and basis are truncated to integers.

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.

15. What is the type of argument “settlement” in =ODDLYIELD?

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

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