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

Quiz =YIELDDISC — 10 Questions

10 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 — 10 questions 1 of 10

Question 1 of 10 1/10

How many required arguments does =YIELDDISC have?

Question 2 of 10 2/10

Which statement about =YIELDDISC is correct?

Question 3 of 10 3/10

Is argument “settlement” required in =YIELDDISC?

Question 4 of 10 4/10

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

Question 5 of 10 5/10

What usually causes #VALUE! in =YIELDDISC?

Question 6 of 10 6/10

How many arguments does =YIELDDISC have in total?

Question 7 of 10 7/10

In =YIELDDISC, which is argument #2?

Question 8 of 10 8/10

What is the output type of =YIELDDISC?

Question 9 of 10 9/10

Which function is NOT related to =YIELDDISC?

Question 10 of 10 10/10

How many optional arguments does =YIELDDISC have?

Click a question to see the answer.

1. How many required arguments does =YIELDDISC have?

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

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

2. Which statement about =YIELDDISC is correct?

A. 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. ✓
B. Only works in old versions
C. The settlement date is the date a buyer purchases a coupon, such as a bond. The maturity date is the date when a coupon expires. For example, suppose a 30-year bond is issued on January 1, 2008, and is purchased by a buyer six months later. The issue date would be January 1, 2008, the settlement date would be July 1, 2008, and the maturity date would be January 1, 2038, which is 30 years after the January 1, 2008, issue date.
D. Requires add-in

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.

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

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

Explanation: “settlement” is required.

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

A. Volatile and recalculates every time
B. Only works in old versions
C. قیمت یا ارزش بازخرید صفر یا منفی است، basis خارج از بازه ۰ تا ۴ است، یا settlement بزرگ‌تر یا مساوی maturity است.
D. تاریخ‌ها را با تابع DATE وارد کنید و بررسی کنید سلول‌های تاریخ واقعاً تاریخ باشند، نه متن. ✓

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

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

A. If settlement or maturity is not a valid date, YIELDDISC returns the #VALUE! error value. ✓
B. Select entire column for best performance
C. Only works in old versions
D. Output is always a dynamic array

6. How many arguments does =YIELDDISC have in total?

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

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

7. In =YIELDDISC, which is argument #2?

A. value
B. maturity ✓
C. settlement
D. range

Explanation: Argument #2 is “maturity”.

8. What is the output type of =YIELDDISC?

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

Explanation: Output is “Number”.

9. Which function is NOT related to =YIELDDISC?

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

Explanation: “SECH” is not related to YIELDDISC.

10. How many optional arguments does =YIELDDISC have?

A. 3
B. 1 ✓
C. 2
D. 0

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