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 “settlement” in =PRICEMAT?

Question 2 of 10 2/10

Is argument “rate” required in =PRICEMAT?

Question 3 of 10 3/10

How many required arguments does =PRICEMAT have?

Question 4 of 10 4/10

What usually causes #VALUE! in =PRICEMAT?

Question 5 of 10 5/10

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

Question 6 of 10 6/10

Which statement about =PRICEMAT is correct?

Question 7 of 10 7/10

Which function is related to =PRICEMAT?

Question 8 of 10 8/10

How many arguments does =PRICEMAT have in total?

Question 9 of 10 9/10

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

Question 10 of 10 10/10

Does =PRICEMAT return a dynamic array?

Click a question to see the answer.

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

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

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

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

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

Explanation: “rate” is required.

3. How many required arguments does =PRICEMAT have?

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

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

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

A. If settlement, maturity, or issue is not a valid date, PRICEMAT returns the #VALUE! error value. ✓
B. Only works in old versions
C. Select entire column for best performance
D. Output is always a dynamic array

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

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

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

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

6. Which statement about =PRICEMAT is correct?

A. 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. ✓
B. 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.
C. Volatile and recalculates every time
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.

7. Which function is related to =PRICEMAT?

A. PERCENTOF
B. DMAX
C. ACCRINTM ✓
D. DAYS

Explanation: “ACCRINTM” is related to PRICEMAT.

8. How many arguments does =PRICEMAT have in total?

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

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

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

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

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

10. Does =PRICEMAT return a dynamic array?

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

Explanation: PRICEMAT does not spill.