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

Which function is related to =PRICEMAT?

Question 2 of 15 2/15

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

Question 3 of 15 3/15

Which use case fits =PRICEMAT?

Question 4 of 15 4/15

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

Question 5 of 15 5/15

Does =PRICEMAT return a dynamic array?

Question 6 of 15 6/15

Which is the correct syntax of =PRICEMAT?

Question 7 of 15 7/15

Which statement about =PRICEMAT is correct?

Question 8 of 15 8/15

Is argument “maturity” required in =PRICEMAT?

Question 9 of 15 9/15

Since which Excel version is =PRICEMAT available?

Question 10 of 15 10/15

How many optional arguments does =PRICEMAT have?

Question 11 of 15 11/15

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

Question 12 of 15 12/15

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

Question 13 of 15 13/15

What usually causes #VALUE! in =PRICEMAT?

Question 14 of 15 14/15

What is the output type of =PRICEMAT?

Question 15 of 15 15/15

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

Click a question to see the answer.

1. Which function is related to =PRICEMAT?

A. CHISQ.INV
B. CLEAN
C. BIN2DEC
D. ACCRINTM ✓

Explanation: “ACCRINTM” is related to PRICEMAT.

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

A. تاریخ‌ها را با تابع DATE وارد کنید یا بررسی کنید سلول‌ها واقعاً تاریخ باشند. ✓
B. Volatile and recalculates every time
C. Text is always ignored
D. Only works in old versions

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

3. Which use case fits =PRICEMAT?

A. Ranking & Top N
B. Error Handling
C. Daily Tasks
D. Financial Calculations ✓

Explanation: Use case “Financial Calculations” fits PRICEMAT.

4. What is the type of argument “yld” in =PRICEMAT?

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

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

5. Does =PRICEMAT return a dynamic array?

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

Explanation: PRICEMAT does not spill.

6. 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])

7. Which statement about =PRICEMAT is correct?

A. 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.
B. Only works in old versions
C. Text is always ignored
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. Is argument “maturity” required in =PRICEMAT?

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

Explanation: “maturity” is required.

9. Since which Excel version is =PRICEMAT available?

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

Explanation: Version: “All versions”.

10. How many optional arguments does =PRICEMAT have?

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

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

11. What is the type of argument “settlement” in =PRICEMAT?

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

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

12. What is the type of argument “maturity” in =PRICEMAT?

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

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

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

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

14. What is the output type of =PRICEMAT?

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

Explanation: Output is “Number”.

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

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

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