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

Quiz =COUPNUM — 15 Questions

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

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

← COUPNUM ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

Which statement about =COUPNUM is correct?

Question 2 of 15 2/15

Since which Excel version is =COUPNUM available?

Question 3 of 15 3/15

What is the output type of =COUPNUM?

Question 4 of 15 4/15

Is argument “maturity” required in =COUPNUM?

Question 5 of 15 5/15

What is the type of argument “maturity” in =COUPNUM?

Question 6 of 15 6/15

Is =COUPNUM volatile?

Question 7 of 15 7/15

How many optional arguments does =COUPNUM have?

Question 8 of 15 8/15

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

Question 9 of 15 9/15

Is argument “frequency” required in =COUPNUM?

Question 10 of 15 10/15

What usually causes #NUM! in =COUPNUM?

Question 11 of 15 11/15

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

Question 12 of 15 12/15

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

Question 13 of 15 13/15

Is argument “settlement” required in =COUPNUM?

Question 14 of 15 14/15

Which function is NOT related to =COUPNUM?

Question 15 of 15 15/15

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

Click a question to see the answer.

1. Which statement about =COUPNUM 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. Text is always ignored
D. Volatile and recalculates every time

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.

2. Since which Excel version is =COUPNUM available?

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

Explanation: Version: “All versions”.

3. What is the output type of =COUPNUM?

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

Explanation: Output is “Number”.

4. Is argument “maturity” required in =COUPNUM?

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

Explanation: “maturity” is required.

5. What is the type of argument “maturity” in =COUPNUM?

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

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

6. Is =COUPNUM volatile?

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

Explanation: COUPNUM is not volatile.

7. How many optional arguments does =COUPNUM have?

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

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

8. What is the type of argument “basis” in =COUPNUM?

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

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

9. Is argument “frequency” required in =COUPNUM?

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

Explanation: “frequency” is required.

10. What usually causes #NUM! in =COUPNUM?

A. Select entire column for best performance
B. مقدار settlement یا maturity تاریخ معتبری نیست.
C. If frequency is any number other than 1, 2, or 4, COUPNUM returns the #NUM! error value. If basis < 0 or if basis > 4, COUPNUM returns the #NUM! error value. If settlement ≥ maturity, COUPNUM returns the #NUM! error value. ✓
D. Output is always a dynamic array

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

11. What is the fix for #NUM! in =COUPNUM?

A. Text is always ignored
B. Check the order of the dates and the input values ✓
C. Output is always a dynamic array
D. Only works in old versions

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

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

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

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

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

Explanation: “settlement” is required.

14. Which function is NOT related to =COUPNUM?

A. ACCRINT
B. DISC ✓
C. COUPNCD
D. COUPDAYBS

Explanation: “DISC” is not related to COUPNUM.

15. What is the fix for #VALUE! in =COUPNUM?

A. Volatile and recalculates every time
B. مقدار frequency غیر از ۱، ۲ یا ۴ است، مبنای شمارش روز خارج از بازه ۰ تا ۴ است، یا تاریخ تسویه مساوی یا بعد از سررسید است.
C. تاریخ‌ها را با تابع DATE وارد کنید. ✓
D. Requires add-in

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