Financial =TBILLEQ(settlement, maturity, discount)

Quiz =TBILLEQ — 10 Questions

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

Question 1 of 10 1/10

Which function is related to =TBILLEQ?

Question 2 of 10 2/10

Which use case fits =TBILLEQ?

Question 3 of 10 3/10

In =TBILLEQ, which is argument #2?

Question 4 of 10 4/10

What usually causes #VALUE! in =TBILLEQ?

Question 5 of 10 5/10

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

Question 6 of 10 6/10

Which category does =TBILLEQ belong to?

Question 7 of 10 7/10

Is =TBILLEQ volatile?

Question 8 of 10 8/10

How many optional arguments does =TBILLEQ have?

Question 9 of 10 9/10

Which is the correct syntax of =TBILLEQ?

Question 10 of 10 10/10

Is argument “settlement” required in =TBILLEQ?

Click a question to see the answer.

1. Which function is related to =TBILLEQ?

A. LAMBDA
B. MAXA
C. TBILLPRICE ✓
D. FORECAST.LINEAR

Explanation: “TBILLPRICE” is related to TBILLEQ.

2. Which use case fits =TBILLEQ?

A. Conditional Logic
B. Descriptive Statistics
C. Financial Calculations ✓
D. Workdays & Due Dates

Explanation: Use case “Financial Calculations” fits TBILLEQ.

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

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

Explanation: Argument #2 is “maturity”.

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

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

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

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

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

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

6. Which category does =TBILLEQ belong to?

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

Explanation: Category is “Financial”.

7. Is =TBILLEQ volatile?

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

Explanation: TBILLEQ is not volatile.

8. How many optional arguments does =TBILLEQ have?

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

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

9. Which is the correct syntax of =TBILLEQ?

A. TBILLEQ(settlement, maturity, discount)
B. =TBILLPRICE(settlement, maturity, discount)
C. =TBILLEQ(settlement, maturity, discount, 0)
D. =TBILLEQ(settlement, maturity, discount) ✓

Explanation: Correct syntax: =TBILLEQ(settlement, maturity, discount)

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

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

Explanation: “settlement” is required.