Financial =YIELDDISC(settlement, maturity, pr, redemption, [basis])

Quiz =YIELDDISC — 15 Questions

15 quiz questions about =YIELDDISC — test syntax, arguments, examples & errors!

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

← YIELDDISC ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

Is argument “redemption” required in =YIELDDISC?

Question 2 of 15 2/15

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

Question 3 of 15 3/15

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

Question 4 of 15 4/15

Which statement about =YIELDDISC is correct?

Question 5 of 15 5/15

How many required arguments does =YIELDDISC have?

Question 6 of 15 6/15

In =YIELDDISC, which is argument #3?

Question 7 of 15 7/15

Which category does =YIELDDISC belong to?

Question 8 of 15 8/15

Is =YIELDDISC volatile?

Question 9 of 15 9/15

Is argument “maturity” required in =YIELDDISC?

Question 10 of 15 10/15

What is the type of argument “settlement” in =YIELDDISC?

Question 11 of 15 11/15

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

Question 12 of 15 12/15

Since which Excel version is =YIELDDISC available?

Question 13 of 15 13/15

Is argument “settlement” required in =YIELDDISC?

Question 14 of 15 14/15

Does =YIELDDISC return a dynamic array?

Question 15 of 15 15/15

Which function is NOT related to =YIELDDISC?

Click a question to see the answer.

1. Is argument “redemption” required in =YIELDDISC?

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

Explanation: “redemption” is required.

2. What is the fix for #NUM! in =YIELDDISC?

A. Check the order of the dates and the input values ✓
B. Volatile and recalculates every time
C. Output is always a dynamic array
D. مقدار settlement یا maturity تاریخ معتبری نیست.

Explanation: If pr ≤ 0 or if redemption ≤ 0, YIELDDISC returns the #NUM! error value. If basis < 0 or if basis > 4, YIELDDISC returns the #NUM! error value. If settlement ≥ maturity, YIELDDISC returns the #NUM! error value. — Fix: Check the order of the dates and the input values

3. What is the fix for #VALUE! in =YIELDDISC?

A. Text is always ignored
B. Requires add-in
C. تاریخ‌ها را با تابع DATE وارد کنید و بررسی کنید سلول‌های تاریخ واقعاً تاریخ باشند، نه متن. ✓
D. Output is always a dynamic array

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

4. Which statement about =YIELDDISC is correct?

A. Output is always a dynamic array
B. 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. ✓
C. Settlement, maturity, and basis are truncated to integers.
D. Only works in old versions

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.

5. How many required arguments does =YIELDDISC have?

A. 5
B. 6
C. 4 ✓
D. 3

Explanation: =YIELDDISC has 4 required, 1 optional (5 total).

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

A. pr ✓
B. criteria
C. value
D. range

Explanation: Argument #3 is “pr”.

7. Which category does =YIELDDISC belong to?

A. Cube
B. Financial ✓
C. Information
D. Database

Explanation: Category is “Financial”.

8. Is =YIELDDISC volatile?

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

Explanation: YIELDDISC is not volatile.

9. Is argument “maturity” required in =YIELDDISC?

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

Explanation: “maturity” is required.

10. What is the type of argument “settlement” in =YIELDDISC?

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

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

11. What is the type of argument “pr” in =YIELDDISC?

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

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

12. Since which Excel version is =YIELDDISC available?

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

Explanation: Version: “All versions”.

13. Is argument “settlement” required in =YIELDDISC?

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

Explanation: “settlement” is required.

14. Does =YIELDDISC return a dynamic array?

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

Explanation: YIELDDISC does not spill.

15. Which function is NOT related to =YIELDDISC?

A. YIELD
B. DISC
C. TEXT ✓
D. PRICEDISC

Explanation: “TEXT” is not related to YIELDDISC.