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 function is NOT related to =COUPDAYS?

Question 2 of 10 2/10

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

Question 3 of 10 3/10

Is =COUPDAYS volatile?

Question 4 of 10 4/10

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

Question 5 of 10 5/10

Which function is related to =COUPDAYS?

Question 6 of 10 6/10

Since which Excel version is =COUPDAYS available?

Question 7 of 10 7/10

What usually causes #VALUE! in =COUPDAYS?

Question 8 of 10 8/10

Is argument “basis” required in =COUPDAYS?

Question 9 of 10 9/10

Which statement about =COUPDAYS is correct?

Question 10 of 10 10/10

Which is the correct syntax of =COUPDAYS?

Click a question to see the answer.

1. Which function is NOT related to =COUPDAYS?

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

Explanation: “LOGEST” is not related to COUPDAYS.

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

A. Text is always ignored
B. مقدار settlement یا maturity تاریخ معتبری نیست.
C. Requires add-in
D. Check the order of the dates and the input values ✓

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

3. Is =COUPDAYS volatile?

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

Explanation: COUPDAYS is not volatile.

4. What is the type of argument “frequency” in =COUPDAYS?

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

Explanation: Type of “frequency” is “Number”.

5. Which function is related to =COUPDAYS?

A. PERCENTILE.INC
B. RTD
C. COUPDAYBS ✓
D. AVEDEV

Explanation: “COUPDAYBS” is related to COUPDAYS.

6. Since which Excel version is =COUPDAYS available?

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

Explanation: Version: “All versions”.

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

A. Only works in old versions
B. If settlement or maturity is not a valid date, COUPDAYS returns the #VALUE! error value. ✓
C. Select entire column for best performance
D. Volatile and recalculates every time

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

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

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

Explanation: “basis” is optional.

9. Which statement about =COUPDAYS is correct?

A. 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. ✓
B. All arguments are truncated to integers.
C. 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.
D. Only works in old versions

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 is the correct syntax of =COUPDAYS?

A. =COUPDAYS(settlement, maturity, frequency, [basis], 0)
B. =COUPDAYBS(settlement, maturity, frequency, [basis])
C. =COUPDAYS(settlement, maturity, frequency, [basis]) ✓
D. COUPDAYS(settlement, maturity, frequency, [basis])

Explanation: Correct syntax: =COUPDAYS(settlement, maturity, frequency, [basis])