Financial =COUPPCD(settlement, maturity, frequency, [basis])

Quiz =COUPPCD — 15 Questions

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

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

← COUPPCD ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

Is argument “maturity” required in =COUPPCD?

Question 2 of 15 2/15

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

Question 3 of 15 3/15

Is argument “settlement” required in =COUPPCD?

Question 4 of 15 4/15

Which statement about =COUPPCD is correct?

Question 5 of 15 5/15

What is the type of argument “frequency” in =COUPPCD?

Question 6 of 15 6/15

Which use case fits =COUPPCD?

Question 7 of 15 7/15

How many required arguments does =COUPPCD have?

Question 8 of 15 8/15

In =COUPPCD, which is argument #3?

Question 9 of 15 9/15

Is argument “basis” required in =COUPPCD?

Question 10 of 15 10/15

Which is the correct syntax of =COUPPCD?

Question 11 of 15 11/15

Is argument “frequency” required in =COUPPCD?

Question 12 of 15 12/15

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

Question 13 of 15 13/15

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

Question 14 of 15 14/15

Since which Excel version is =COUPPCD available?

Question 15 of 15 15/15

Which function is related to =COUPPCD?

Click a question to see the answer.

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

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

Explanation: “maturity” is required.

2. What is the type of argument “basis” in =COUPPCD?

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

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

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

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

Explanation: “settlement” is required.

4. Which statement about =COUPPCD 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. All arguments are truncated to integers.
D. Output is always a dynamic array

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. What is the type of argument “frequency” in =COUPPCD?

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

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

6. Which use case fits =COUPPCD?

A. Depreciation
B. Conditional Formatting & Validation
C. Financial Calculations ✓
D. Rounding & Numeric

Explanation: Use case “Financial Calculations” fits COUPPCD.

7. How many required arguments does =COUPPCD have?

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

Explanation: =COUPPCD has 3 required, 1 optional (4 total).

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

A. frequency ✓
B. maturity
C. lookup_value
D. criteria

Explanation: Argument #3 is “frequency”.

9. Is argument “basis” required in =COUPPCD?

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

Explanation: “basis” is optional.

10. Which is the correct syntax of =COUPPCD?

A. =COUPDAYBS(settlement, maturity, frequency, [basis])
B. =COUPPCD(settlement, maturity, frequency, [basis]) ✓
C. COUPPCD(settlement, maturity, frequency, [basis])
D. =COUPPCD(settlement, maturity, frequency, [basis], 0)

Explanation: Correct syntax: =COUPPCD(settlement, maturity, frequency, [basis])

11. Is argument “frequency” required in =COUPPCD?

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

Explanation: “frequency” is required.

12. What is the type of argument “settlement” in =COUPPCD?

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

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

13. What is the fix for #VALUE! in =COUPPCD?

A. Select entire column for best performance
B. تاریخ‌ها را با تابع DATE وارد کنید. ✓
C. Text is always ignored
D. Volatile and recalculates every time

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

14. Since which Excel version is =COUPPCD available?

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

Explanation: Version: “All versions”.

15. Which function is related to =COUPPCD?

A. F.INV.RT
B. COUPDAYBS ✓
C. STDEV
D. CHISQ.DIST

Explanation: “COUPDAYBS” is related to COUPPCD.