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

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

Question 2 of 15 2/15

Which function is related to =YIELDMAT?

Question 3 of 15 3/15

Which use case fits =YIELDMAT?

Question 4 of 15 4/15

Does =YIELDMAT return a dynamic array?

Question 5 of 15 5/15

In =YIELDMAT, which is argument #3?

Question 6 of 15 6/15

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

Question 7 of 15 7/15

Which statement about =YIELDMAT is correct?

Question 8 of 15 8/15

Which formula is a valid example of =YIELDMAT?

Question 9 of 15 9/15

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

Question 10 of 15 10/15

Is argument “pr” required in =YIELDMAT?

Question 11 of 15 11/15

Is argument “basis” required in =YIELDMAT?

Question 12 of 15 12/15

Is argument “issue” required in =YIELDMAT?

Question 13 of 15 13/15

Is argument “rate” required in =YIELDMAT?

Question 14 of 15 14/15

In =YIELDMAT, which is argument #1?

Question 15 of 15 15/15

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

Click a question to see the answer.

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

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

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

2. Which function is related to =YIELDMAT?

A. BAHTTEXT
B. FIXED
C. PRICEMAT ✓
D. COLUMN

Explanation: “PRICEMAT” is related to YIELDMAT.

3. Which use case fits =YIELDMAT?

A. Numbering & Sample Data
B. Financial Calculations ✓
C. Lookup & Retrieval
D. Data Cleaning

Explanation: Use case “Financial Calculations” fits YIELDMAT.

4. Does =YIELDMAT return a dynamic array?

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

Explanation: YIELDMAT does not spill.

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

A. basis
B. issue ✓
C. maturity
D. criteria

Explanation: Argument #3 is “issue”.

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

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

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

7. Which statement about =YIELDMAT is correct?

A. Volatile and recalculates every time
B. Text is always ignored
C. Output is always a dynamic array
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.

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

A. =PRICEMAT(A2,A3,A4,A5,A6,A7)
B. YIELDMAT(A2,A3,A4,A5,A6,A7)
C. =YIELDMAT(A2,A3,A4,A5,A6,A7, 0)
D. =YIELDMAT(A2,A3,A4,A5,A6,A7) ✓

Explanation: Correct example: =YIELDMAT(A2,A3,A4,A5,A6,A7)

9. What is the type of argument “rate” in =YIELDMAT?

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

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

10. Is argument “pr” required in =YIELDMAT?

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

Explanation: “pr” is required.

11. Is argument “basis” required in =YIELDMAT?

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

Explanation: “basis” is optional.

12. Is argument “issue” required in =YIELDMAT?

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

Explanation: “issue” is required.

13. Is argument “rate” required in =YIELDMAT?

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

Explanation: “rate” is required.

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

A. basis
B. issue
C. settlement ✓
D. range

Explanation: Argument #1 is “settlement”.

15. What is the type of argument “maturity” in =YIELDMAT?

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

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