Financial =TBILLPRICE(settlement, maturity, discount)

Quiz =TBILLPRICE — 10 Questions

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

Question 1 of 10 1/10

Which function is related to =TBILLPRICE?

Question 2 of 10 2/10

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

Question 3 of 10 3/10

How many arguments does =TBILLPRICE have in total?

Question 4 of 10 4/10

Which statement about =TBILLPRICE is correct?

Question 5 of 10 5/10

Which is the correct syntax of =TBILLPRICE?

Question 6 of 10 6/10

In =TBILLPRICE, which is argument #2?

Question 7 of 10 7/10

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

Question 8 of 10 8/10

Is =TBILLPRICE volatile?

Question 9 of 10 9/10

Since which Excel version is =TBILLPRICE available?

Question 10 of 10 10/10

Which formula is a valid example of =TBILLPRICE?

Click a question to see the answer.

1. Which function is related to =TBILLPRICE?

A. SUM
B. PRICEDISC ✓
C. UNICHAR
D. ACCRINT

Explanation: “PRICEDISC” is related to TBILLPRICE.

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

A. Reference
B. Date ✓
C. Mixed
D. Number

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

3. How many arguments does =TBILLPRICE have in total?

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

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

4. Which statement about =TBILLPRICE is correct?

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

5. Which is the correct syntax of =TBILLPRICE?

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

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

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

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

Explanation: Argument #2 is “maturity”.

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

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

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

8. Is =TBILLPRICE volatile?

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

Explanation: TBILLPRICE is not volatile.

9. Since which Excel version is =TBILLPRICE available?

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

Explanation: Version: “All versions”.

10. Which formula is a valid example of =TBILLPRICE?

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

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