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

Which formula is a valid example of =YIELD?

Question 2 of 10 2/10

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

Question 3 of 10 3/10

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

Question 4 of 10 4/10

Since which Excel version is =YIELD available?

Question 5 of 10 5/10

Is argument “frequency” required in =YIELD?

Question 6 of 10 6/10

Which use case fits =YIELD?

Question 7 of 10 7/10

Is =YIELD volatile?

Question 8 of 10 8/10

In =YIELD, which is argument #3?

Question 9 of 10 9/10

Is argument “redemption” required in =YIELD?

Question 10 of 10 10/10

What usually causes #VALUE! in =YIELD?

Click a question to see the answer.

1. Which formula is a valid example of =YIELD?

A. YIELD(A2,A3,A4,A5,A6,A7,A8)
B. =IRR(A2,A3,A4,A5,A6,A7,A8)
C. =YIELD(A2,A3,A4,A5,A6,A7,A8) ✓
D. =YIELD(A2,A3,A4,A5,A6,A7,A8, 0)

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

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

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

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

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

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

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

4. Since which Excel version is =YIELD available?

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

Explanation: Version: “All versions”.

5. Is argument “frequency” required in =YIELD?

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

Explanation: “frequency” is required.

6. Which use case fits =YIELD?

A. Conditional Aggregation
B. Financial Calculations ✓
C. Advanced Formulas
D. Probability & Hypothesis Testing

Explanation: Use case “Financial Calculations” fits YIELD.

7. Is =YIELD volatile?

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

Explanation: YIELD is not volatile.

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

A. rate ✓
B. redemption
C. criteria
D. pr

Explanation: Argument #3 is “rate”.

9. Is argument “redemption” required in =YIELD?

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

Explanation: “redemption” is required.

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

A. Volatile and recalculates every time
B. Text is always ignored
C. If settlement or maturity is not a valid date, YIELD returns the #VALUE! error value. ✓
D. Select entire column for best performance

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