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

Quiz =COUPPCD — 10 Questions

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

Question 1 of 10 1/10

Is =COUPPCD volatile?

Question 2 of 10 2/10

How many arguments does =COUPPCD have in total?

Question 3 of 10 3/10

What usually causes #NUM! in =COUPPCD?

Question 4 of 10 4/10

Is argument “frequency” required in =COUPPCD?

Question 5 of 10 5/10

How many optional arguments does =COUPPCD have?

Question 6 of 10 6/10

How many required arguments does =COUPPCD have?

Question 7 of 10 7/10

In =COUPPCD, which is argument #3?

Question 8 of 10 8/10

Which formula is a valid example of =COUPPCD?

Question 9 of 10 9/10

Which statement about =COUPPCD is correct?

Question 10 of 10 10/10

Which function is related to =COUPPCD?

Click a question to see the answer.

1. Is =COUPPCD volatile?

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

Explanation: COUPPCD is not volatile.

2. How many arguments does =COUPPCD have in total?

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

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

3. What usually causes #NUM! in =COUPPCD?

A. If frequency is any number other than 1, 2, or 4, COUPPCD returns the #NUM! error value. If basis < 0 or if basis > 4, COUPPCD returns the #NUM! error value. If settlement ≥ maturity, COUPPCD returns the #NUM! error value. ✓
B. Select entire column for best performance
C. Requires add-in
D. Output is always a dynamic array

Explanation: If frequency is any number other than 1, 2, or 4, COUPPCD returns the #NUM! error value. If basis < 0 or if basis > 4, COUPPCD returns the #NUM! error value. If settlement ≥ maturity, COUPPCD returns the #NUM! error value. — Fix: Check the order of the dates and the input values

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

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

Explanation: “frequency” is required.

5. How many optional arguments does =COUPPCD have?

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

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

6. How many required arguments does =COUPPCD have?

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

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

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

A. maturity
B. range
C. frequency ✓
D. basis

Explanation: Argument #3 is “frequency”.

8. Which formula is a valid example of =COUPPCD?

A. =COUPDAYBS(A2,A3,A4,A5)
B. COUPPCD(A2,A3,A4,A5)
C. =COUPPCD(A2,A3,A4,A5) ✓
D. =COUPPCD(A2,A3,A4,A5, 0)

Explanation: Correct example: =COUPPCD(A2,A3,A4,A5)

9. Which statement about =COUPPCD is correct?

A. Requires add-in
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. Select entire column for best performance
D. 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.

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.

10. Which function is related to =COUPPCD?

A. FINV
B. COUPDAYBS ✓
C. WRAPCOLS
D. SUMX2MY2

Explanation: “COUPDAYBS” is related to COUPPCD.