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

Since which Excel version is =COUPDAYBS available?

Question 2 of 10 2/10

Is argument “settlement” required in =COUPDAYBS?

Question 3 of 10 3/10

What usually causes #NUM! in =COUPDAYBS?

Question 4 of 10 4/10

Which statement about =COUPDAYBS is correct?

Question 5 of 10 5/10

Is argument “maturity” required in =COUPDAYBS?

Question 6 of 10 6/10

Does =COUPDAYBS return a dynamic array?

Question 7 of 10 7/10

How many arguments does =COUPDAYBS have in total?

Question 8 of 10 8/10

Which category does =COUPDAYBS belong to?

Question 9 of 10 9/10

Is argument “frequency” required in =COUPDAYBS?

Question 10 of 10 10/10

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

Click a question to see the answer.

1. Since which Excel version is =COUPDAYBS available?

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

Explanation: Version: “All versions”.

2. Is argument “settlement” required in =COUPDAYBS?

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

Explanation: “settlement” is required.

3. What usually causes #NUM! in =COUPDAYBS?

A. Output is always a dynamic array
B. مقدار settlement یا maturity تاریخ معتبری نیست.
C. Select entire column for best performance
D. 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. ✓

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

4. Which statement about =COUPDAYBS is correct?

A. Requires add-in
B. Volatile and recalculates every time
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. Output is always a dynamic array

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.

5. Is argument “maturity” required in =COUPDAYBS?

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

Explanation: “maturity” is required.

6. Does =COUPDAYBS return a dynamic array?

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

Explanation: COUPDAYBS does not spill.

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

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

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

8. Which category does =COUPDAYBS belong to?

A. Statistical
B. Financial ✓
C. Text
D. Logical

Explanation: Category is “Financial”.

9. Is argument “frequency” required in =COUPDAYBS?

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

Explanation: “frequency” is required.

10. What is the type of argument “maturity” in =COUPDAYBS?

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

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