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

Is argument “discount” required in =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

How many optional arguments does =TBILLPRICE have?

Question 5 of 10 5/10

Which is the correct syntax of =TBILLPRICE?

Question 6 of 10 6/10

Which category does =TBILLPRICE belong to?

Question 7 of 10 7/10

Which function is related to =TBILLPRICE?

Question 8 of 10 8/10

Which statement about =TBILLPRICE is correct?

Question 9 of 10 9/10

Which formula is a valid example of =TBILLPRICE?

Question 10 of 10 10/10

In =TBILLPRICE, which is argument #1?

Click a question to see the answer.

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

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

Explanation: “discount” is required.

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

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

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

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

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

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

4. How many optional arguments does =TBILLPRICE have?

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

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

5. Which is the correct syntax of =TBILLPRICE?

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

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

6. Which category does =TBILLPRICE belong to?

A. Statistical
B. Engineering
C. Financial ✓
D. Compatibility

Explanation: Category is “Financial”.

7. Which function is related to =TBILLPRICE?

A. PHI
B. PRICEDISC ✓
C. ACOS
D. NORM.S.DIST

Explanation: “PRICEDISC” is related to TBILLPRICE.

8. Which statement about =TBILLPRICE is correct?

A. Output is always a dynamic array
B. Requires add-in
C. Select entire column for best performance
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.

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

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

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

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

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

Explanation: Argument #1 is “settlement”.