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

Quiz =PRICEMAT — 10 Questions

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

Question 1 of 10 1/10

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

Question 2 of 10 2/10

Which statement about =PRICEMAT is correct?

Question 3 of 10 3/10

Which category does =PRICEMAT belong to?

Question 4 of 10 4/10

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

Question 5 of 10 5/10

What is the output type of =PRICEMAT?

Question 6 of 10 6/10

In =PRICEMAT, which is argument #3?

Question 7 of 10 7/10

What usually causes #NUM! in =PRICEMAT?

Question 8 of 10 8/10

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

Question 9 of 10 9/10

Which formula is a valid example of =PRICEMAT?

Question 10 of 10 10/10

Which use case fits =PRICEMAT?

Click a question to see the answer.

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

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

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

2. Which statement about =PRICEMAT is correct?

A. Settlement, maturity, issue, and basis are truncated to integers.
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.

3. Which category does =PRICEMAT belong to?

A. Financial ✓
B. Database
C. Engineering
D. Compatibility

Explanation: Category is “Financial”.

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

A. Only works in old versions
B. Output is always a dynamic array
C. Check the order of the dates and the input values ✓
D. مقدار settlement یا maturity یا issue تاریخ معتبری نیست.

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

5. What is the output type of =PRICEMAT?

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

Explanation: Output is “Number”.

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

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

Explanation: Argument #3 is “issue”.

7. What usually causes #NUM! in =PRICEMAT?

A. Output is always a dynamic array
B. Select entire column for best performance
C. Volatile and recalculates every time
D. 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. ✓

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

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

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

9. Which formula is a valid example of =PRICEMAT?

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

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

10. Which use case fits =PRICEMAT?

A. Loans & Installments
B. Financial Calculations ✓
C. Conditional Logic
D. Numbering & Sample Data

Explanation: Use case “Financial Calculations” fits PRICEMAT.