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

Quiz =COUPDAYS — 10 Questions

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

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

← COUPDAYS ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

Which category does =COUPDAYS belong to?

Question 2 of 10 2/10

Is argument “maturity” required in =COUPDAYS?

Question 3 of 10 3/10

Since which Excel version is =COUPDAYS available?

Question 4 of 10 4/10

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

Question 5 of 10 5/10

What usually causes #VALUE! in =COUPDAYS?

Question 6 of 10 6/10

How many required arguments does =COUPDAYS have?

Question 7 of 10 7/10

Is argument “basis” required in =COUPDAYS?

Question 8 of 10 8/10

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

Question 9 of 10 9/10

Which function is related to =COUPDAYS?

Question 10 of 10 10/10

In =COUPDAYS, which is argument #3?

Click a question to see the answer.

1. Which category does =COUPDAYS belong to?

A. Text
B. Financial ✓
C. Lookup & Reference
D. Statistical

Explanation: Category is “Financial”.

2. Is argument “maturity” required in =COUPDAYS?

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

Explanation: “maturity” is required.

3. Since which Excel version is =COUPDAYS available?

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

Explanation: Version: “All versions”.

4. What is the fix for #NUM! in =COUPDAYS?

A. Only works in old versions
B. Check the order of the dates and the input values ✓
C. Requires add-in
D. Volatile and recalculates every time

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

5. What usually causes #VALUE! in =COUPDAYS?

A. Volatile and recalculates every time
B. Requires add-in
C. If settlement or maturity is not a valid date, COUPDAYS returns the #VALUE! error value. ✓
D. Only works in old versions

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

6. How many required arguments does =COUPDAYS have?

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

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

7. Is argument “basis” required in =COUPDAYS?

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

Explanation: “basis” is optional.

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

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

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

9. Which function is related to =COUPDAYS?

A. COUPDAYBS ✓
B. SUMSQ
C. FILTERXML
D. ISREF

Explanation: “COUPDAYBS” is related to COUPDAYS.

10. In =COUPDAYS, which is argument #3?

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

Explanation: Argument #3 is “frequency”.