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
Progress — 10 questions
1 of 10
Question 1 of 10
1/10
How many optional arguments does =PRICEMAT have?
Explanation: =PRICEMAT has 5 required, 1 optional (6 total).
Question 2 of 10
2/10
In =PRICEMAT, which is argument #2?
Explanation: Argument #2 is “maturity”.
Question 3 of 10
3/10
Is argument “yld” required in =PRICEMAT?
Explanation: “yld” is required.
Question 4 of 10
4/10
Is argument “settlement” required in =PRICEMAT?
Explanation: “settlement” is required.
Question 5 of 10
5/10
Is argument “basis” required in =PRICEMAT?
Explanation: “basis” is optional.
Question 6 of 10
6/10
What is the type of argument “maturity” in =PRICEMAT?
Explanation: Type of “maturity” is “Date”.
Question 7 of 10
7/10
What is the type of argument “basis” in =PRICEMAT?
Explanation: Type of “basis” is “Number”.
Question 8 of 10
8/10
What is the type of argument “settlement” in =PRICEMAT?
Explanation: Type of “settlement” is “Date”.
Question 9 of 10
9/10
Is argument “rate” required in =PRICEMAT?
Explanation: “rate” is required.
Question 10 of 10
10/10
Is argument “issue” required in =PRICEMAT?
Explanation: “issue” is required.