Financial =TBILLYIELD(settlement, maturity, pr)

Quiz =TBILLYIELD — 15 Questions

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

Question 1 of 15 1/15

Which statement about =TBILLYIELD is correct?

Question 2 of 15 2/15

Since which Excel version is =TBILLYIELD available?

Question 3 of 15 3/15

In =TBILLYIELD, which is argument #2?

Question 4 of 15 4/15

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

Question 5 of 15 5/15

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

Question 6 of 15 6/15

What is the fix for #NUM! in =TBILLYIELD?

Question 7 of 15 7/15

Which is the correct syntax of =TBILLYIELD?

Question 8 of 15 8/15

Is argument “maturity” required in =TBILLYIELD?

Question 9 of 15 9/15

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

Question 10 of 15 10/15

Is argument “settlement” required in =TBILLYIELD?

Question 11 of 15 11/15

Which function is NOT related to =TBILLYIELD?

Question 12 of 15 12/15

What is the output type of =TBILLYIELD?

Question 13 of 15 13/15

What usually causes #VALUE! in =TBILLYIELD?

Question 14 of 15 14/15

How many arguments does =TBILLYIELD have in total?

Question 15 of 15 15/15

Is argument “pr” required in =TBILLYIELD?

Click a question to see the answer.

1. Which statement about =TBILLYIELD is correct?

A. Requires add-in
B. Volatile and recalculates every time
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. Output is always a dynamic array

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.

2. Since which Excel version is =TBILLYIELD available?

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

Explanation: Version: “All versions”.

3. In =TBILLYIELD, which is argument #2?

A. maturity ✓
B. settlement
C. lookup_value
D. range

Explanation: Argument #2 is “maturity”.

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

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

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

5. What is the fix for #VALUE! in =TBILLYIELD?

A. Only works in old versions
B. Select entire column for best performance
C. تاریخ‌ها را با تابع DATE وارد کنید و مطمئن شوید مقادیر تاریخ معتبر هستند. ✓
D. Volatile and recalculates every time

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

6. What is the fix for #NUM! in =TBILLYIELD?

A. Output is always a dynamic array
B. Volatile and recalculates every time
C. Text is always ignored
D. Check the dates and the third argument ✓

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

7. Which is the correct syntax of =TBILLYIELD?

A. TBILLYIELD(settlement, maturity, pr)
B. =TBILLEQ(settlement, maturity, pr)
C. =TBILLYIELD(settlement, maturity, pr, 0)
D. =TBILLYIELD(settlement, maturity, pr) ✓

Explanation: Correct syntax: =TBILLYIELD(settlement, maturity, pr)

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

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

Explanation: “maturity” is required.

9. What is the type of argument “pr” in =TBILLYIELD?

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

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

10. Is argument “settlement” required in =TBILLYIELD?

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

Explanation: “settlement” is required.

11. Which function is NOT related to =TBILLYIELD?

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

Explanation: “OFFSET” is not related to TBILLYIELD.

12. What is the output type of =TBILLYIELD?

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

Explanation: Output is “Number”.

13. What usually causes #VALUE! in =TBILLYIELD?

A. Volatile and recalculates every time
B. Requires add-in
C. If settlement or maturity is not a valid date, TBILLYIELD returns the #VALUE! error value. ✓
D. Output is always a dynamic array

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

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

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

15. Is argument “pr” required in =TBILLYIELD?

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

Explanation: “pr” is required.