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

Quiz =COUPDAYBS — 15 Questions

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

Question 1 of 15 1/15

Does =COUPDAYBS return a dynamic array?

Question 2 of 15 2/15

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

Question 3 of 15 3/15

Is argument “settlement” required in =COUPDAYBS?

Question 4 of 15 4/15

Which function is related to =COUPDAYBS?

Question 5 of 15 5/15

In =COUPDAYBS, which is argument #3?

Question 6 of 15 6/15

Which statement about =COUPDAYBS is correct?

Question 7 of 15 7/15

How many required arguments does =COUPDAYBS have?

Question 8 of 15 8/15

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

Question 9 of 15 9/15

In =COUPDAYBS, which is argument #1?

Question 10 of 15 10/15

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

Question 11 of 15 11/15

Which use case fits =COUPDAYBS?

Question 12 of 15 12/15

In =COUPDAYBS, which is argument #2?

Question 13 of 15 13/15

Since which Excel version is =COUPDAYBS available?

Question 14 of 15 14/15

Is =COUPDAYBS volatile?

Question 15 of 15 15/15

Is argument “basis” required in =COUPDAYBS?

Click a question to see the answer.

1. Does =COUPDAYBS return a dynamic array?

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

Explanation: COUPDAYBS does not spill.

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

A. مقدار frequency غیر از ۱، ۲ یا ۴ است، مبنای شمارش روز (basis) خارج از بازه ۰ تا ۴ است، یا تاریخ تسویه مساوی یا بعد از تاریخ سررسید است.
B. Volatile and recalculates every time
C. Requires add-in
D. تاریخ‌ها را با تابع DATE وارد کنید یا بررسی کنید سلول‌های تاریخ واقعاً تاریخ باشند، نه متن. ✓

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

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

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

Explanation: “settlement” is required.

4. Which function is related to =COUPDAYBS?

A. MODE
B. HIDDEN
C. ACCRINT ✓
D. REGISTER.ID

Explanation: “ACCRINT” is related to COUPDAYBS.

5. In =COUPDAYBS, which is argument #3?

A. maturity
B. value
C. frequency ✓
D. criteria

Explanation: Argument #3 is “frequency”.

6. Which statement about =COUPDAYBS is correct?

A. All arguments are truncated to integers.
B. 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. ✓
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.

7. How many required arguments does =COUPDAYBS have?

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

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

8. What is the type of argument “frequency” in =COUPDAYBS?

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

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

9. In =COUPDAYBS, which is argument #1?

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

Explanation: Argument #1 is “settlement”.

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

A. Check the order of the dates and the input values ✓
B. Text is always ignored
C. Volatile and recalculates every time
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

11. Which use case fits =COUPDAYBS?

A. Probability & Hypothesis Testing
B. Securities & Bonds
C. Lookup & Retrieval
D. Financial Calculations ✓

Explanation: Use case “Financial Calculations” fits COUPDAYBS.

12. In =COUPDAYBS, which is argument #2?

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

Explanation: Argument #2 is “maturity”.

13. Since which Excel version is =COUPDAYBS available?

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

Explanation: Version: “All versions”.

14. Is =COUPDAYBS volatile?

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

Explanation: COUPDAYBS is not volatile.

15. Is argument “basis” required in =COUPDAYBS?

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

Explanation: “basis” is optional.