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

Is argument “discount” required in =TBILLEQ?

Question 2 of 10 2/10

Which function is related to =TBILLEQ?

Question 3 of 10 3/10

Which category does =TBILLEQ belong to?

Question 4 of 10 4/10

Which use case fits =TBILLEQ?

Question 5 of 10 5/10

Which statement about =TBILLEQ is correct?

Question 6 of 10 6/10

Is =TBILLEQ volatile?

Question 7 of 10 7/10

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

Question 8 of 10 8/10

In =TBILLEQ, which is argument #2?

Question 9 of 10 9/10

Which formula is a valid example of =TBILLEQ?

Question 10 of 10 10/10

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

Click a question to see the answer.

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

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

Explanation: “discount” is required.

2. Which function is related to =TBILLEQ?

A. GROWTH
B. TODAY
C. TBILLPRICE ✓
D. COVARIANCE.P

Explanation: “TBILLPRICE” is related to TBILLEQ.

3. Which category does =TBILLEQ belong to?

A. Web
B. Compatibility
C. Financial ✓
D. Database

Explanation: Category is “Financial”.

4. Which use case fits =TBILLEQ?

A. Investment Appraisal
B. Depreciation
C. Data Cleaning
D. Financial Calculations ✓

Explanation: Use case “Financial Calculations” fits TBILLEQ.

5. Which statement about =TBILLEQ is correct?

A. 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. ✓
B. Settlement and maturity are truncated to integers.
C. Only works in old versions
D. 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.

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. Is =TBILLEQ volatile?

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

Explanation: TBILLEQ is not volatile.

7. What is the fix for #VALUE! in =TBILLEQ?

A. Select entire column for best performance
B. تاریخ‌ها را با تابع DATE وارد کنید و مطمئن شوید سلول‌ها واقعاً تاریخ هستند، نه متن. ✓
C. Output is always a dynamic array
D. اگر discount کوچک‌تر یا مساوی ۰ باشد، یا settlement بزرگ‌تر از maturity باشد، یا سررسید بیش از یک سال پس از تسویه باشد، تابع TBILLEQ خطای #NUM! را برمی‌گرداند.

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

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

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

Explanation: Argument #2 is “maturity”.

9. Which formula is a valid example of =TBILLEQ?

A. =TBILLPRICE(A2,A3,A4)
B. =TBILLEQ(A2,A3,A4, 0)
C. =TBILLEQ(A2,A3,A4) ✓
D. TBILLEQ(A2,A3,A4)

Explanation: Correct example: =TBILLEQ(A2,A3,A4)

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

A. Value
B. Number ✓
C. Mixed
D. Logical

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