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

How many arguments does =ODDLYIELD have in total?

Question 2 of 10 2/10

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

Question 3 of 10 3/10

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

Question 4 of 10 4/10

Which function is NOT related to =ODDLYIELD?

Question 5 of 10 5/10

Which is the correct syntax of =ODDLYIELD?

Question 6 of 10 6/10

In =ODDLYIELD, which is argument #3?

Question 7 of 10 7/10

How many required arguments does =ODDLYIELD have?

Question 8 of 10 8/10

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

Question 9 of 10 9/10

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

Question 10 of 10 10/10

What usually causes #NUM! in =ODDLYIELD?

Click a question to see the answer.

1. How many arguments does =ODDLYIELD have in total?

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

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

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

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

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

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

A. Text is always ignored
B. Check the order of the dates and the input values ✓
C. Requires add-in
D. مقدار settlement یا maturity یا last_interest تاریخ معتبری نیست.

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

4. Which function is NOT related to =ODDLYIELD?

A. ODDLPRICE
B. NOW ✓
C. YIELD
D. ODDFYIELD

Explanation: “NOW” is not related to ODDLYIELD.

5. 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], 0)
C. =ODDLYIELD(settlement, maturity, last_interest, rate, pr, redemption, frequency, [basis]) ✓
D. ODDLYIELD(settlement, maturity, last_interest, rate, pr, redemption, frequency, [basis])

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

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

A. range
B. settlement
C. last_interest ✓
D. basis

Explanation: Argument #3 is “last_interest”.

7. How many required arguments does =ODDLYIELD have?

A. 8
B. 7 ✓
C. 9
D. 6

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

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

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

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

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

A. Volatile and recalculates every time
B. Only works in old versions
C. تاریخ‌ها را با تابع DATE وارد کنید و از صحت آن‌ها اطمینان حاصل کنید. ✓
D. Select entire column for best performance

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

10. What usually causes #NUM! in =ODDLYIELD?

A. 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 ✓
B. Volatile and recalculates every time
C. Only works in old versions
D. Output is always a dynamic array