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

Quiz =YIELDMAT — 10 Questions

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

Question 1 of 10 1/10

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

Question 2 of 10 2/10

Is argument “pr” required in =YIELDMAT?

Question 3 of 10 3/10

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

Question 4 of 10 4/10

Is argument “issue” required in =YIELDMAT?

Question 5 of 10 5/10

Is argument “maturity” required in =YIELDMAT?

Question 6 of 10 6/10

Which is the correct syntax of =YIELDMAT?

Question 7 of 10 7/10

Which function is related to =YIELDMAT?

Question 8 of 10 8/10

Which statement about =YIELDMAT is correct?

Question 9 of 10 9/10

How many optional arguments does =YIELDMAT have?

Question 10 of 10 10/10

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

Click a question to see the answer.

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

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

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

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

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

Explanation: “pr” is required.

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

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

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

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

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

Explanation: “issue” is required.

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

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

Explanation: “maturity” is required.

6. Which is the correct syntax of =YIELDMAT?

A. YIELDMAT(settlement, maturity, issue, rate, pr, [basis])
B. =YIELDMAT(settlement, maturity, issue, rate, pr, [basis], 0)
C. =YIELDMAT(settlement, maturity, issue, rate, pr, [basis]) ✓
D. =PRICEMAT(settlement, maturity, issue, rate, pr, [basis])

Explanation: Correct syntax: =YIELDMAT(settlement, maturity, issue, rate, pr, [basis])

7. Which function is related to =YIELDMAT?

A. AGGREGATE
B. FORECAST.ETS.CONFINT
C. COUPPCD
D. PRICEMAT ✓

Explanation: “PRICEMAT” is related to YIELDMAT.

8. Which statement about =YIELDMAT is correct?

A. Only works in old versions
B. Requires add-in
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. Text is always ignored

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.

9. How many optional arguments does =YIELDMAT have?

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

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

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

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

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