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

Quiz =COUPDAYS — 15 Questions

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

Question 1 of 15 1/15

In =COUPDAYS, which is argument #2?

Question 2 of 15 2/15

Is argument “frequency” required in =COUPDAYS?

Question 3 of 15 3/15

Since which Excel version is =COUPDAYS available?

Question 4 of 15 4/15

Is argument “maturity” required in =COUPDAYS?

Question 5 of 15 5/15

Which function is NOT related to =COUPDAYS?

Question 6 of 15 6/15

Is argument “basis” required in =COUPDAYS?

Question 7 of 15 7/15

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

Question 8 of 15 8/15

Which statement about =COUPDAYS is correct?

Question 9 of 15 9/15

How many optional arguments does =COUPDAYS have?

Question 10 of 15 10/15

Which use case fits =COUPDAYS?

Question 11 of 15 11/15

How many arguments does =COUPDAYS have in total?

Question 12 of 15 12/15

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

Question 13 of 15 13/15

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

Question 14 of 15 14/15

How many required arguments does =COUPDAYS have?

Question 15 of 15 15/15

Which category does =COUPDAYS belong to?

Click a question to see the answer.

1. In =COUPDAYS, which is argument #2?

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

Explanation: Argument #2 is “maturity”.

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

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

Explanation: “frequency” is required.

3. Since which Excel version is =COUPDAYS available?

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

Explanation: Version: “All versions”.

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

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

Explanation: “maturity” is required.

5. Which function is NOT related to =COUPDAYS?

A. HYPGEOMDIST ✓
B. COUPNUM
C. COUPDAYBS
D. COUPNCD

Explanation: “HYPGEOMDIST” is not related to COUPDAYS.

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

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

Explanation: “basis” is optional.

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

A. Text is always ignored
B. Check the order of the dates and the input values ✓
C. Select entire column for best performance
D. Requires add-in

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

8. Which statement about =COUPDAYS is correct?

A. Output is always a dynamic array
B. 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.
C. Only works in old versions
D. 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. ✓

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.

9. How many optional arguments does =COUPDAYS have?

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

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

10. Which use case fits =COUPDAYS?

A. Dynamic Ranges & Dashboards
B. Workdays & Due Dates
C. Data Cleaning
D. Financial Calculations ✓

Explanation: Use case “Financial Calculations” fits COUPDAYS.

11. How many arguments does =COUPDAYS have in total?

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

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

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

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

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

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

A. تاریخ‌ها را با تابع DATE وارد کنید و مطمئن شوید سلول‌ها واقعاً تاریخ هستند. ✓
B. Volatile and recalculates every time
C. مقدار frequency غیر از ۱، ۲ یا ۴ است، مبنای شمارش روز خارج از بازه ۰ تا ۴ است، یا تاریخ تسویه مساوی یا بعد از سررسید است.
D. Select entire column for best performance

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

14. How many required arguments does =COUPDAYS have?

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

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

15. Which category does =COUPDAYS belong to?

A. Information
B. Lookup & Reference
C. Financial ✓
D. Compatibility

Explanation: Category is “Financial”.