Financial =PRICEMAT(settlement, maturity, issue, rate, yld, [basis])

Quiz =PRICEMAT — 15 Questions

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

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

← PRICEMAT ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

Is argument “issue” required in =PRICEMAT?

Question 2 of 15 2/15

Is argument “maturity” required in =PRICEMAT?

Question 3 of 15 3/15

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

Question 4 of 15 4/15

Is argument “basis” required in =PRICEMAT?

Question 5 of 15 5/15

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

Question 6 of 15 6/15

What usually causes #VALUE! in =PRICEMAT?

Question 7 of 15 7/15

Which is the correct syntax of =PRICEMAT?

Question 8 of 15 8/15

Is argument “settlement” required in =PRICEMAT?

Question 9 of 15 9/15

Which function is NOT related to =PRICEMAT?

Question 10 of 15 10/15

Is argument “rate” required in =PRICEMAT?

Question 11 of 15 11/15

In =PRICEMAT, which is argument #3?

Question 12 of 15 12/15

Which statement about =PRICEMAT is correct?

Question 13 of 15 13/15

How many required arguments does =PRICEMAT have?

Question 14 of 15 14/15

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

Question 15 of 15 15/15

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

Click a question to see the answer.

1. Is argument “issue” required in =PRICEMAT?

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

Explanation: “issue” is required.

2. Is argument “maturity” required in =PRICEMAT?

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

Explanation: “maturity” is required.

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

A. Volatile and recalculates every time
B. مقدار rate یا yld منفی، basis خارج از بازه ۰ تا ۴، یا settlement مساوی یا بعد از maturity است.
C. Only works in old versions
D. تاریخ‌ها را با تابع DATE وارد کنید یا بررسی کنید سلول‌ها واقعاً تاریخ باشند. ✓

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

4. Is argument “basis” required in =PRICEMAT?

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

Explanation: “basis” is optional.

5. What is the type of argument “rate” in =PRICEMAT?

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

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

6. What usually causes #VALUE! in =PRICEMAT?

A. If settlement, maturity, or issue is not a valid date, PRICEMAT returns the #VALUE! error value. ✓
B. Select entire column for best performance
C. Requires add-in
D. Volatile and recalculates every time

7. Which is the correct syntax of =PRICEMAT?

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

Explanation: Correct syntax: =PRICEMAT(settlement, maturity, issue, rate, yld, [basis])

8. Is argument “settlement” required in =PRICEMAT?

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

Explanation: “settlement” is required.

9. Which function is NOT related to =PRICEMAT?

A. ACCRINTM
B. STDEVP ✓
C. YIELDMAT
D. PRICE

Explanation: “STDEVP” is not related to PRICEMAT.

10. Is argument “rate” required in =PRICEMAT?

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

Explanation: “rate” is required.

11. In =PRICEMAT, which is argument #3?

A. issue ✓
B. yld
C. value
D. maturity

Explanation: Argument #3 is “issue”.

12. Which statement about =PRICEMAT is correct?

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

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.

13. How many required arguments does =PRICEMAT have?

A. 7
B. 4
C. 5 ✓
D. 6

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

14. What is the fix for #NUM! in =PRICEMAT?

A. Volatile and recalculates every time
B. مقدار settlement یا maturity یا issue تاریخ معتبری نیست.
C. Check the order of the dates and the input values ✓
D. Requires add-in

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

15. What is the type of argument “issue” in =PRICEMAT?

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

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