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

Quiz =YIELD — 10 Questions

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

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

← YIELD ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

Is argument “maturity” required in =YIELD?

Question 2 of 10 2/10

What is the type of argument “pr” in =YIELD?

Question 3 of 10 3/10

Is argument “basis” required in =YIELD?

Question 4 of 10 4/10

What is the type of argument “basis” in =YIELD?

Question 5 of 10 5/10

What usually causes #VALUE! in =YIELD?

Question 6 of 10 6/10

In =YIELD, which is argument #3?

Question 7 of 10 7/10

Which statement about =YIELD is correct?

Question 8 of 10 8/10

Which use case fits =YIELD?

Question 9 of 10 9/10

In =YIELD, which is argument #1?

Question 10 of 10 10/10

Which is the correct syntax of =YIELD?

Click a question to see the answer.

1. Is argument “maturity” required in =YIELD?

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

Explanation: “maturity” is required.

2. What is the type of argument “pr” in =YIELD?

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

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

3. Is argument “basis” required in =YIELD?

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

Explanation: “basis” is optional.

4. What is the type of argument “basis” in =YIELD?

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

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

5. What usually causes #VALUE! in =YIELD?

A. If settlement or maturity is not a valid date, YIELD returns the #VALUE! error value. ✓
B. Select entire column for best performance
C. نرخ منفی است، قیمت یا ارزش بازخرید صفر یا منفی است، frequency غیر از ۱، ۲ یا ۴ است، basis خارج از بازه ۰ تا ۴ است، یا settlement بزرگ‌تر یا مساوی maturity است.
D. Requires add-in

Explanation: If settlement or maturity is not a valid date, YIELD returns the #VALUE! error value. — Fix: تاریخ‌ها را با تابع DATE وارد کنید و بررسی کنید سلول‌های تاریخ واقعاً تاریخ باشند، نه متن.

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

A. criteria
B. value
C. frequency
D. rate ✓

Explanation: Argument #3 is “rate”.

7. Which statement about =YIELD is correct?

A. Output is always a dynamic array
B. 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.
C. If there is more than one coupon period until redemption, YIELD is calculated through a hundred iterations. The resolution uses the Newton method, based on the formula used for the function PRICE. The yield is changed until the estimated price given the yield is close to price.
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.

8. Which use case fits =YIELD?

A. Worksheet Info & Navigation
B. Financial Calculations ✓
C. Text Manipulation
D. Probability & Hypothesis Testing

Explanation: Use case “Financial Calculations” fits YIELD.

9. In =YIELD, which is argument #1?

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

Explanation: Argument #1 is “settlement”.

10. Which is the correct syntax of =YIELD?

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

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