Financial =PRICE(settlement, maturity, rate, yld, redemption, frequency, [basis])

Quiz =PRICE — 15 Questions

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

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

← PRICE ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

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

Question 2 of 15 2/15

How many required arguments does =PRICE have?

Question 3 of 15 3/15

Which statement about =PRICE is correct?

Question 4 of 15 4/15

Which use case fits =PRICE?

Question 5 of 15 5/15

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

Question 6 of 15 6/15

Is argument “maturity” required in =PRICE?

Question 7 of 15 7/15

What is the output type of =PRICE?

Question 8 of 15 8/15

Is argument “redemption” required in =PRICE?

Question 9 of 15 9/15

In =PRICE, which is argument #2?

Question 10 of 15 10/15

How many arguments does =PRICE have in total?

Question 11 of 15 11/15

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

Question 12 of 15 12/15

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

Question 13 of 15 13/15

In =PRICE, which is argument #3?

Question 14 of 15 14/15

Does =PRICE return a dynamic array?

Question 15 of 15 15/15

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

Click a question to see the answer.

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

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

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

2. How many required arguments does =PRICE have?

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

Explanation: =PRICE has 6 required, 1 optional (7 total).

3. Which statement about =PRICE is correct?

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

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.

4. Which use case fits =PRICE?

A. Investment Appraisal
B. Financial Calculations ✓
C. Worksheet Info & Navigation
D. Reshape Tables

Explanation: Use case “Financial Calculations” fits PRICE.

5. What is the fix for #VALUE! in =PRICE?

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

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

6. Is argument “maturity” required in =PRICE?

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

Explanation: “maturity” is required.

7. What is the output type of =PRICE?

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

Explanation: Output is “Number”.

8. Is argument “redemption” required in =PRICE?

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

Explanation: “redemption” is required.

9. In =PRICE, which is argument #2?

A. value
B. settlement
C. maturity ✓
D. basis

Explanation: Argument #2 is “maturity”.

10. How many arguments does =PRICE have in total?

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

Explanation: =PRICE has 6 required, 1 optional (7 total).

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

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

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

12. What is the type of argument “yld” in =PRICE?

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

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

13. In =PRICE, which is argument #3?

A. frequency
B. rate ✓
C. maturity
D. settlement

Explanation: Argument #3 is “rate”.

14. Does =PRICE return a dynamic array?

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

Explanation: PRICE does not spill.

15. What is the type of argument “rate” in =PRICE?

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

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