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 “settlement” in =TBILLYIELD?

Question 2 of 10 2/10

What is the output type of =TBILLYIELD?

Question 3 of 10 3/10

Which formula is a valid example of =TBILLYIELD?

Question 4 of 10 4/10

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

Question 5 of 10 5/10

Which statement about =TBILLYIELD is correct?

Question 6 of 10 6/10

Which is the correct syntax of =TBILLYIELD?

Question 7 of 10 7/10

Which function is NOT related to =TBILLYIELD?

Question 8 of 10 8/10

In =TBILLYIELD, which is argument #2?

Question 9 of 10 9/10

Since which Excel version is =TBILLYIELD available?

Question 10 of 10 10/10

What usually causes #VALUE! in =TBILLYIELD?

Click a question to see the answer.

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

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

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

2. What is the output type of =TBILLYIELD?

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

Explanation: Output is “Number”.

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

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

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

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

A. Select entire column for best performance
B. Requires add-in
C. Check the dates and the third argument ✓
D. Output is always a dynamic array

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

5. Which statement about =TBILLYIELD is correct?

A. 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. ✓
B. Select entire column for best performance
C. Text is always ignored
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.

6. Which is the correct syntax of =TBILLYIELD?

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

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

7. Which function is NOT related to =TBILLYIELD?

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

Explanation: “COUPNCD” is not related to TBILLYIELD.

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

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

Explanation: Argument #2 is “maturity”.

9. Since which Excel version is =TBILLYIELD available?

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

Explanation: Version: “All versions”.

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

A. اگر pr کوچک‌تر یا مساوی ۰ باشد، یا settlement بزرگ‌تر یا مساوی maturity باشد، یا سررسید بیش از یک سال پس از تسویه باشد، تابع TBILLYIELD خطای #NUM! را برمی‌گرداند.
B. Output is always a dynamic array
C. Requires add-in
D. If settlement or maturity is not a valid date, TBILLYIELD returns the #VALUE! error value. ✓

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