Financial =TBILLYIELD(settlement, maturity, pr)

Quiz =TBILLYIELD — 10 Questions

10 quiz questions about =TBILLYIELD — test syntax, arguments, examples & errors!

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

← TBILLYIELD ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

What is the type of argument “maturity” in =TBILLYIELD?

Question 2 of 10 2/10

Is argument “maturity” required in =TBILLYIELD?

Question 3 of 10 3/10

Which statement about =TBILLYIELD is correct?

Question 4 of 10 4/10

In =TBILLYIELD, which is argument #2?

Question 5 of 10 5/10

Does =TBILLYIELD return a dynamic array?

Question 6 of 10 6/10

How many arguments does =TBILLYIELD have in total?

Question 7 of 10 7/10

How many required arguments does =TBILLYIELD have?

Question 8 of 10 8/10

Which formula is a valid example of =TBILLYIELD?

Question 9 of 10 9/10

Which function is NOT related to =TBILLYIELD?

Question 10 of 10 10/10

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

Click a question to see the answer.

1. What is the type of argument “maturity” in =TBILLYIELD?

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

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

2. Is argument “maturity” required in =TBILLYIELD?

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

Explanation: “maturity” is required.

3. Which statement about =TBILLYIELD is correct?

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

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. In =TBILLYIELD, which is argument #2?

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

Explanation: Argument #2 is “maturity”.

5. Does =TBILLYIELD return a dynamic array?

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

Explanation: TBILLYIELD does not spill.

6. How many arguments does =TBILLYIELD have in total?

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

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

7. How many required arguments does =TBILLYIELD have?

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

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

8. Which formula is a valid example of =TBILLYIELD?

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

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

9. Which function is NOT related to =TBILLYIELD?

A. TBILLPRICE
B. VARP ✓
C. TBILLEQ
D. YIELDDISC

Explanation: “VARP” is not related to TBILLYIELD.

10. What is the type of argument “settlement” in =TBILLYIELD?

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

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