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
Progress — 15 questions
1 of 15
Question 1 of 15
1/15
Is argument “settlement” required in =ODDLYIELD?
Explanation: “settlement” is required.
Question 2 of 15
2/15
In =ODDLYIELD, which is argument #1?
Explanation: Argument #1 is “settlement”.
Question 3 of 15
3/15
Does =ODDLYIELD return a dynamic array?
Explanation: ODDLYIELD does not spill.
Question 4 of 15
4/15
How many arguments does =ODDLYIELD have in total?
Explanation: =ODDLYIELD has 7 required, 1 optional (8 total).
Question 5 of 15
5/15
What is the fix for #NUM! in =ODDLYIELD?
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
Question 6 of 15
6/15
Is argument “last_interest” required in =ODDLYIELD?
Explanation: “last_interest” is required.
Question 7 of 15
7/15
Which is the correct syntax of =ODDLYIELD?
Explanation: Correct syntax: =ODDLYIELD(settlement, maturity, last_interest, rate, pr, redemption, frequency, [basis])
Question 8 of 15
8/15
Which use case fits =ODDLYIELD?
Explanation: Use case “Financial Calculations” fits ODDLYIELD.
Question 9 of 15
9/15
Which function is NOT related to =ODDLYIELD?
Explanation: “ISNA” is not related to ODDLYIELD.
Question 10 of 15
10/15
What is the type of argument “frequency” in =ODDLYIELD?
Explanation: Type of “frequency” is “Number”.
Question 11 of 15
11/15
Which statement about =ODDLYIELD is correct?
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.
Question 12 of 15
12/15
Is argument “redemption” required in =ODDLYIELD?
Explanation: “redemption” is required.
Question 13 of 15
13/15
Is argument “pr” required in =ODDLYIELD?
Explanation: “pr” is required.
Question 14 of 15
14/15
Since which Excel version is =ODDLYIELD available?
Explanation: Version: “All versions”.
Question 15 of 15
15/15
What usually causes #NUM! in =ODDLYIELD?
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