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

Quiz =COUPDAYBS — 10 Questions

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

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

← COUPDAYBS ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

Which statement about =COUPDAYBS is correct?

Question 2 of 10 2/10

In =COUPDAYBS, which is argument #1?

Question 3 of 10 3/10

How many arguments does =COUPDAYBS have in total?

Question 4 of 10 4/10

Is =COUPDAYBS volatile?

Question 5 of 10 5/10

Since which Excel version is =COUPDAYBS available?

Question 6 of 10 6/10

Which function is related to =COUPDAYBS?

Question 7 of 10 7/10

Which function is NOT related to =COUPDAYBS?

Question 8 of 10 8/10

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

Question 9 of 10 9/10

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

Question 10 of 10 10/10

Which formula is a valid example of =COUPDAYBS?

Click a question to see the answer.

1. Which statement about =COUPDAYBS is correct?

A. Volatile and recalculates every time
B. All arguments are truncated to integers.
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. Requires add-in

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. In =COUPDAYBS, which is argument #1?

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

Explanation: Argument #1 is “settlement”.

3. How many arguments does =COUPDAYBS have in total?

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

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

4. Is =COUPDAYBS volatile?

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

Explanation: COUPDAYBS is not volatile.

5. Since which Excel version is =COUPDAYBS available?

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

Explanation: Version: “All versions”.

6. Which function is related to =COUPDAYBS?

A. FORECAST.ETS.CONFINT
B. ACCRINT ✓
C. BYCOL
D. BAHTTEXT

Explanation: “ACCRINT” is related to COUPDAYBS.

7. Which function is NOT related to =COUPDAYBS?

A. COT ✓
B. COUPNCD
C. ACCRINT
D. COUPNUM

Explanation: “COT” is not related to COUPDAYBS.

8. What is the fix for #NUM! in =COUPDAYBS?

A. Select entire column for best performance
B. Only works in old versions
C. Check the order of the dates and the input values ✓
D. Output is always a dynamic array

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

9. What is the fix for #VALUE! in =COUPDAYBS?

A. Only works in old versions
B. تاریخ‌ها را با تابع DATE وارد کنید یا بررسی کنید سلول‌های تاریخ واقعاً تاریخ باشند، نه متن. ✓
C. مقدار frequency غیر از ۱، ۲ یا ۴ است، مبنای شمارش روز (basis) خارج از بازه ۰ تا ۴ است، یا تاریخ تسویه مساوی یا بعد از تاریخ سررسید است.
D. Text is always ignored

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

10. Which formula is a valid example of =COUPDAYBS?

A. =COUPDAYBS(A2,A3,A4,A5, 0)
B. =COUPDAYBS(A2,A3,A4,A5) ✓
C. =ACCRINT(A2,A3,A4,A5)
D. COUPDAYBS(A2,A3,A4,A5)

Explanation: Correct example: =COUPDAYBS(A2,A3,A4,A5)