Financial =YIELDMAT(settlement, maturity, issue, rate, pr, [basis])

Quiz =YIELDMAT — 15 Questions

15 quiz questions about =YIELDMAT — test syntax, arguments, examples & errors!

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

← YIELDMAT ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

Is argument “maturity” required in =YIELDMAT?

Question 2 of 15 2/15

What usually causes #VALUE! in =YIELDMAT?

Question 3 of 15 3/15

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

Question 4 of 15 4/15

Which statement about =YIELDMAT is correct?

Question 5 of 15 5/15

In =YIELDMAT, which is argument #1?

Question 6 of 15 6/15

What is the type of argument “issue” in =YIELDMAT?

Question 7 of 15 7/15

Which category does =YIELDMAT belong to?

Question 8 of 15 8/15

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

Question 9 of 15 9/15

In =YIELDMAT, which is argument #3?

Question 10 of 15 10/15

Which function is NOT related to =YIELDMAT?

Question 11 of 15 11/15

How many optional arguments does =YIELDMAT have?

Question 12 of 15 12/15

What usually causes #NUM! in =YIELDMAT?

Question 13 of 15 13/15

Is =YIELDMAT volatile?

Question 14 of 15 14/15

In =YIELDMAT, which is argument #2?

Question 15 of 15 15/15

Since which Excel version is =YIELDMAT available?

Click a question to see the answer.

1. Is argument “maturity” required in =YIELDMAT?

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

Explanation: “maturity” is required.

2. What usually causes #VALUE! in =YIELDMAT?

A. If settlement, maturity, or issue is not a valid date, YIELDMAT returns the #VALUE! error value. ✓
B. Requires add-in
C. Text is always ignored
D. Only works in old versions

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

3. What is the fix for #VALUE! in =YIELDMAT?

A. Only works in old versions
B. Select entire column for best performance
C. تاریخ‌ها را با تابع DATE وارد کنید و بررسی کنید سلول‌های تاریخ واقعاً تاریخ باشند، نه متن. ✓
D. نرخ منفی است، قیمت صفر یا منفی است، basis خارج از بازه ۰ تا ۴ است، یا settlement بزرگ‌تر یا مساوی maturity است.

4. Which statement about =YIELDMAT 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. Microsoft Excel stores dates as sequential serial numbers so they can be used in calculations. By default, January 1, 1900 is serial number 1, and January 1, 2008 is serial number 39448 because it is 39,448 days after January 1, 1900.
C. Only works in old versions
D. Requires add-in

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

A. issue
B. lookup_value
C. rate
D. settlement ✓

Explanation: Argument #1 is “settlement”.

6. What is the type of argument “issue” in =YIELDMAT?

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

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

7. Which category does =YIELDMAT belong to?

A. Database
B. Financial ✓
C. Statistical
D. Math & Trig

Explanation: Category is “Financial”.

8. What is the type of argument “pr” in =YIELDMAT?

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

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

9. In =YIELDMAT, which is argument #3?

A. rate
B. issue ✓
C. lookup_value
D. maturity

Explanation: Argument #3 is “issue”.

10. Which function is NOT related to =YIELDMAT?

A. PRICEMAT
B. YIELDDISC
C. FORMULATEXT ✓
D. YIELD

Explanation: “FORMULATEXT” is not related to YIELDMAT.

11. How many optional arguments does =YIELDMAT have?

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

Explanation: =YIELDMAT has 5 required, 1 optional (6 total).

12. What usually causes #NUM! in =YIELDMAT?

A. If rate < 0 or if pr ≤ 0, YIELDMAT returns the #NUM! error value. If basis < 0 or if basis > 4, YIELDMAT returns the #NUM! error value. If settlement ≥ maturity, YIELDMAT returns the #NUM! error value. ✓
B. Output is always a dynamic array
C. Only works in old versions
D. Select entire column for best performance

Explanation: If rate < 0 or if pr ≤ 0, YIELDMAT returns the #NUM! error value. If basis < 0 or if basis > 4, YIELDMAT returns the #NUM! error value. If settlement ≥ maturity, YIELDMAT returns the #NUM! error value. — Fix: Check the order of the dates and the input values

13. Is =YIELDMAT volatile?

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

Explanation: YIELDMAT is not volatile.

14. In =YIELDMAT, which is argument #2?

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

Explanation: Argument #2 is “maturity”.

15. Since which Excel version is =YIELDMAT available?

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

Explanation: Version: “All versions”.