Financial =TBILLPRICE(settlement, maturity, discount)

Quiz =TBILLPRICE — 15 Questions

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

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

← TBILLPRICE ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

In =TBILLPRICE, which is argument #2?

Question 2 of 15 2/15

Is argument “discount” required in =TBILLPRICE?

Question 3 of 15 3/15

Which statement about =TBILLPRICE is correct?

Question 4 of 15 4/15

What usually causes #NUM! in =TBILLPRICE?

Question 5 of 15 5/15

Which function is related to =TBILLPRICE?

Question 6 of 15 6/15

How many optional arguments does =TBILLPRICE have?

Question 7 of 15 7/15

Which category does =TBILLPRICE belong to?

Question 8 of 15 8/15

Is argument “maturity” required in =TBILLPRICE?

Question 9 of 15 9/15

What is the type of argument “settlement” in =TBILLPRICE?

Question 10 of 15 10/15

Which function is NOT related to =TBILLPRICE?

Question 11 of 15 11/15

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

Question 12 of 15 12/15

What is the output type of =TBILLPRICE?

Question 13 of 15 13/15

Does =TBILLPRICE return a dynamic array?

Question 14 of 15 14/15

Is argument “settlement” required in =TBILLPRICE?

Question 15 of 15 15/15

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

Click a question to see the answer.

1. In =TBILLPRICE, which is argument #2?

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

Explanation: Argument #2 is “maturity”.

2. Is argument “discount” required in =TBILLPRICE?

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

Explanation: “discount” is required.

3. Which statement about =TBILLPRICE is correct?

A. Select entire column for best performance
B. Text is always ignored
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. Volatile and recalculates every time

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.

4. What usually causes #NUM! in =TBILLPRICE?

A. If discount ≤ 0, TBILLPRICE returns the #NUM! error value. If settlement > maturity, or if maturity is more than one year after settlement, TBILLPRICE returns the #NUM! error value. ✓
B. اگر settlement یا maturity تاریخ معتبری نباشد، تابع TBILLPRICE خطای #VALUE! را برمی‌گرداند.
C. Text is always ignored
D. Volatile and recalculates every time

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

5. Which function is related to =TBILLPRICE?

A. IMAGE
B. PRICEDISC ✓
C. SHEETS
D. MEDIAN

Explanation: “PRICEDISC” is related to TBILLPRICE.

6. How many optional arguments does =TBILLPRICE have?

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

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

7. Which category does =TBILLPRICE belong to?

A. Database
B. Financial ✓
C. Math & Trig
D. Cube

Explanation: Category is “Financial”.

8. Is argument “maturity” required in =TBILLPRICE?

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

Explanation: “maturity” is required.

9. What is the type of argument “settlement” in =TBILLPRICE?

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

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

10. Which function is NOT related to =TBILLPRICE?

A. CSC ✓
B. PRICEDISC
C. TBILLEQ
D. TBILLYIELD

Explanation: “CSC” is not related to TBILLPRICE.

11. What is the type of argument “discount” in =TBILLPRICE?

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

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

12. What is the output type of =TBILLPRICE?

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

Explanation: Output is “Number”.

13. Does =TBILLPRICE return a dynamic array?

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

Explanation: TBILLPRICE does not spill.

14. Is argument “settlement” required in =TBILLPRICE?

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

Explanation: “settlement” is required.

15. What is the fix for #VALUE! in =TBILLPRICE?

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

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