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

Which category does =COUPNUM belong to?

Question 3 of 15 3/15

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

Question 4 of 15 4/15

Which function is NOT related to =COUPNUM?

Question 5 of 15 5/15

Does =COUPNUM return a dynamic array?

Question 6 of 15 6/15

Is argument “settlement” required in =COUPNUM?

Question 7 of 15 7/15

Is argument “maturity” required in =COUPNUM?

Question 8 of 15 8/15

What usually causes #NUM! in =COUPNUM?

Question 9 of 15 9/15

What usually causes #VALUE! in =COUPNUM?

Question 10 of 15 10/15

In =COUPNUM, which is argument #2?

Question 11 of 15 11/15

How many required arguments does =COUPNUM have?

Question 12 of 15 12/15

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

Question 13 of 15 13/15

In =COUPNUM, which is argument #1?

Question 14 of 15 14/15

Is =COUPNUM volatile?

Question 15 of 15 15/15

Which use case fits =COUPNUM?

Click a question to see the answer.

1. Which statement about =COUPNUM is correct?

A. Microsoft Excel stores dates as sequential serial numbers so they can be used in calculations. By default, January 1, 1900 is serial number 1, and January 1, 2008 is serial number 39448 because it is 39,448 days after January 1, 1900.
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(2008,5,23) for the 23rd day of May, 2008. Problems can occur if dates are entered as text. ✓
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. Which category does =COUPNUM belong to?

A. Logical
B. Financial ✓
C. Engineering
D. Web

Explanation: Category is “Financial”.

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

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

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

4. Which function is NOT related to =COUPNUM?

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

Explanation: “MID” is not related to COUPNUM.

5. Does =COUPNUM return a dynamic array?

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

Explanation: COUPNUM does not spill.

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

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

Explanation: “settlement” is required.

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

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

Explanation: “maturity” is required.

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

A. Only works in old versions
B. 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. ✓
C. Select entire column for best performance
D. Volatile and recalculates every time

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

9. What usually causes #VALUE! in =COUPNUM?

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

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

10. In =COUPNUM, which is argument #2?

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

Explanation: Argument #2 is “maturity”.

11. How many required arguments does =COUPNUM have?

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

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

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

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

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

13. In =COUPNUM, which is argument #1?

A. settlement ✓
B. basis
C. frequency
D. value

Explanation: Argument #1 is “settlement”.

14. Is =COUPNUM volatile?

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

Explanation: COUPNUM is not volatile.

15. Which use case fits =COUPNUM?

A. Financial Calculations ✓
B. Investment Appraisal
C. Loans & Installments
D. Conditional Logic

Explanation: Use case “Financial Calculations” fits COUPNUM.