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

Which statement about =ODDLYIELD is correct?

Question 2 of 10 2/10

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

Question 3 of 10 3/10

What is the output type of =ODDLYIELD?

Question 4 of 10 4/10

Which use case fits =ODDLYIELD?

Question 5 of 10 5/10

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

Question 6 of 10 6/10

Since which Excel version is =ODDLYIELD available?

Question 7 of 10 7/10

In =ODDLYIELD, which is argument #2?

Question 8 of 10 8/10

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

Question 9 of 10 9/10

How many optional arguments does =ODDLYIELD have?

Question 10 of 10 10/10

Which formula is a valid example of =ODDLYIELD?

Click a question to see the answer.

1. Which statement about =ODDLYIELD is correct?

A. Microsoft Excel stores dates as sequential serial numbers so they can be used in calculations. By default, January 1, 1900 is serial number 1, and January 1, 2008 is serial number 39448 because it is 39,448 days after January 1, 1900.
B. Requires add-in
C. Output is always a dynamic array
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.

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

A. تاریخ‌ها را با تابع DATE وارد کنید و از صحت آن‌ها اطمینان حاصل کنید. ✓
B. Only works in old versions
C. Volatile and recalculates every time
D. Text is always ignored

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

3. What is the output type of =ODDLYIELD?

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

Explanation: Output is “Number”.

4. Which use case fits =ODDLYIELD?

A. Financial Calculations ✓
B. Conditional Aggregation
C. Comparation
D. Date & Time Calculations

Explanation: Use case “Financial Calculations” fits ODDLYIELD.

5. What is the type of argument “maturity” in =ODDLYIELD?

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

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

6. Since which Excel version is =ODDLYIELD available?

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

Explanation: Version: “All versions”.

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

A. pr
B. basis
C. lookup_value
D. maturity ✓

Explanation: Argument #2 is “maturity”.

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

A. Check the order of the dates and the input values ✓
B. Only works in old versions
C. Requires add-in
D. Text is always ignored

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

9. How many optional arguments does =ODDLYIELD have?

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

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

10. Which formula is a valid example of =ODDLYIELD?

A. =ODDLYIELD(A2, A3, A4, A5, A6, A7, A8, A9, 0)
B. =ODDFYIELD(A2, A3, A4, A5, A6, A7, A8, A9)
C. =ODDLYIELD(A2, A3, A4, A5, A6, A7, A8, A9) ✓
D. ODDLYIELD(A2, A3, A4, A5, A6, A7, A8, A9)

Explanation: Correct example: =ODDLYIELD(A2, A3, A4, A5, A6, A7, A8, A9)