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

Quiz =DISC — 10 Questions

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

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

← DISC ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

Is argument “redemption” required in =DISC?

Question 2 of 10 2/10

Is =DISC volatile?

Question 3 of 10 3/10

Which is the correct syntax of =DISC?

Question 4 of 10 4/10

In =DISC, which is argument #3?

Question 5 of 10 5/10

Which statement about =DISC is correct?

Question 6 of 10 6/10

Is argument “pr” required in =DISC?

Question 7 of 10 7/10

Which category does =DISC belong to?

Question 8 of 10 8/10

Which function is related to =DISC?

Question 9 of 10 9/10

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

Question 10 of 10 10/10

What usually causes #VALUE! in =DISC?

Click a question to see the answer.

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

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

Explanation: “redemption” is required.

2. Is =DISC volatile?

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

Explanation: DISC is not volatile.

3. Which is the correct syntax of =DISC?

A. DISC(settlement, maturity, pr, redemption, [basis])
B. =DISC(settlement, maturity, pr, redemption, [basis], 0)
C. =DISC(settlement, maturity, pr, redemption, [basis]) ✓
D. =INTRATE(settlement, maturity, pr, redemption, [basis])

Explanation: Correct syntax: =DISC(settlement, maturity, pr, redemption, [basis])

4. In =DISC, which is argument #3?

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

Explanation: Argument #3 is “pr”.

5. Which statement about =DISC is correct?

A. Settlement, maturity, and basis are truncated to integers.
B. Output is always a dynamic array
C. Dates should be entered by using the DATE function, or as results of other formulas or functions. For example, use DATE(2018,5,23) for the 23rd day of May, 2018. Problems can occur if dates are entered as text. ✓
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(2018,5,23) for the 23rd day of May, 2018. Problems can occur if dates are entered as text.

6. Is argument “pr” required in =DISC?

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

Explanation: “pr” is required.

7. Which category does =DISC belong to?

A. Financial ✓
B. Lookup & Reference
C. Text
D. Date & Time

Explanation: Category is “Financial”.

8. Which function is related to =DISC?

A. PRODUCT
B. TIMEVALUE
C. INTRATE ✓
D. GETPIVOTDATA

Explanation: “INTRATE” is related to DISC.

9. What is the type of argument “basis” in =DISC?

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

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

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

A. Select entire column for best performance
B. If settlement or maturity is not a valid serial date number, DISC returns the #VALUE! error value. ✓
C. Output is always a dynamic array
D. Requires add-in

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