Financial =TBILLEQ(settlement, maturity, discount)

Quiz =TBILLEQ — 15 Questions

15 quiz questions about =TBILLEQ — test syntax, arguments, examples & errors!

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

← TBILLEQ ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

What is the output type of =TBILLEQ?

Question 2 of 15 2/15

How many arguments does =TBILLEQ have in total?

Question 3 of 15 3/15

In =TBILLEQ, which is argument #3?

Question 4 of 15 4/15

Is argument “settlement” required in =TBILLEQ?

Question 5 of 15 5/15

Which statement about =TBILLEQ is correct?

Question 6 of 15 6/15

In =TBILLEQ, which is argument #2?

Question 7 of 15 7/15

What usually causes #NUM! in =TBILLEQ?

Question 8 of 15 8/15

Which function is related to =TBILLEQ?

Question 9 of 15 9/15

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

Question 10 of 15 10/15

Does =TBILLEQ return a dynamic array?

Question 11 of 15 11/15

How many required arguments does =TBILLEQ have?

Question 12 of 15 12/15

Is argument “discount” required in =TBILLEQ?

Question 13 of 15 13/15

What is the type of argument “discount” in =TBILLEQ?

Question 14 of 15 14/15

What usually causes #VALUE! in =TBILLEQ?

Question 15 of 15 15/15

How many optional arguments does =TBILLEQ have?

Click a question to see the answer.

1. What is the output type of =TBILLEQ?

A. Value
B. Number ✓
C. Array
D. Text

Explanation: Output is “Number”.

2. How many arguments does =TBILLEQ have in total?

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

Explanation: =TBILLEQ has 3 required, 0 optional (3 total).

3. In =TBILLEQ, which is argument #3?

A. discount ✓
B. maturity
C. settlement
D. value

Explanation: Argument #3 is “discount”.

4. Is argument “settlement” required in =TBILLEQ?

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

Explanation: “settlement” is required.

5. Which statement about =TBILLEQ is correct?

A. Only works in old versions
B. Requires add-in
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. 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.

6. In =TBILLEQ, which is argument #2?

A. value
B. maturity ✓
C. lookup_value
D. settlement

Explanation: Argument #2 is “maturity”.

7. What usually causes #NUM! in =TBILLEQ?

A. Text is always ignored
B. Output is always a dynamic array
C. Select entire column for best performance
D. If discount ≤ 0, TBILLEQ returns the #NUM! error value. If settlement > maturity, or if maturity is more than one year after settlement, TBILLEQ returns the #NUM! error value. ✓

Explanation: If discount ≤ 0, TBILLEQ returns the #NUM! error value. If settlement > maturity, or if maturity is more than one year after settlement, TBILLEQ returns the #NUM! error value. — Fix: Check the dates and the third argument

8. Which function is related to =TBILLEQ?

A. SLOPE
B. NORM.S.DIST
C. TBILLPRICE ✓
D. BITAND

Explanation: “TBILLPRICE” is related to TBILLEQ.

9. What is the type of argument “maturity” in =TBILLEQ?

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

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

10. Does =TBILLEQ return a dynamic array?

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

Explanation: TBILLEQ does not spill.

11. How many required arguments does =TBILLEQ have?

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

Explanation: =TBILLEQ has 3 required, 0 optional (3 total).

12. Is argument “discount” required in =TBILLEQ?

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

Explanation: “discount” is required.

13. What is the type of argument “discount” in =TBILLEQ?

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

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

14. What usually causes #VALUE! in =TBILLEQ?

A. Output is always a dynamic array
B. Only works in old versions
C. Requires add-in
D. If settlement or maturity is not a valid date, TBILLEQ returns the #VALUE! error value. ✓

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

15. How many optional arguments does =TBILLEQ have?

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

Explanation: =TBILLEQ has 3 required, 0 optional (3 total).