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

How many required arguments does =PRICE have?

Question 2 of 15 2/15

In =PRICE, which is argument #1?

Question 3 of 15 3/15

Is argument “redemption” required in =PRICE?

Question 4 of 15 4/15

What usually causes #NUM! in =PRICE?

Question 5 of 15 5/15

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

Question 6 of 15 6/15

In =PRICE, which is argument #2?

Question 7 of 15 7/15

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

Question 8 of 15 8/15

Does =PRICE return a dynamic array?

Question 9 of 15 9/15

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

Question 10 of 15 10/15

Which function is related to =PRICE?

Question 11 of 15 11/15

Is argument “basis” required in =PRICE?

Question 12 of 15 12/15

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

Question 13 of 15 13/15

Which category does =PRICE belong to?

Question 14 of 15 14/15

Is =PRICE volatile?

Question 15 of 15 15/15

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

Click a question to see the answer.

1. How many required arguments does =PRICE have?

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

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

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

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

Explanation: Argument #1 is “settlement”.

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

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

Explanation: “redemption” is required.

4. What usually causes #NUM! in =PRICE?

A. Volatile and recalculates every time
B. Output is always a dynamic array
C. Only works in old versions
D. If yld < 0 or if rate < 0, PRICE returns the #NUM! error value. If redemption ≤ 0, PRICE returns the #NUM! error value. If frequency is any number other than 1, 2, or 4, PRICE returns the #NUM! error value. If basis < 0 or if basis > 4, PRICE returns the #NUM! error value. If settlement ≥ maturity, PRICE returns the #NUM! error value. ✓

Explanation: If yld < 0 or if rate < 0, PRICE returns the #NUM! error value. If redemption ≤ 0, PRICE returns the #NUM! error value. If frequency is any number other than 1, 2, or 4, PRICE returns the #NUM! error value. If basis < 0 or if basis > 4, PRICE returns the #NUM! error value. If settlement ≥ maturity, PRICE returns the #NUM! error value. — Fix: Check the order of the dates and the input values

5. What is the type of argument “basis” in =PRICE?

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

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

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

A. value
B. yld
C. criteria
D. maturity ✓

Explanation: Argument #2 is “maturity”.

7. What is the type of argument “frequency” in =PRICE?

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

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

8. Does =PRICE return a dynamic array?

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

Explanation: PRICE does not spill.

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

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

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

10. Which function is related to =PRICE?

A. DURATION ✓
B. IMCSC
C. MID
D. COSH

Explanation: “DURATION” is related to PRICE.

11. Is argument “basis” required in =PRICE?

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

Explanation: “basis” is optional.

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

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

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

13. Which category does =PRICE belong to?

A. Math & Trig
B. Lookup & Reference
C. Information
D. Financial ✓

Explanation: Category is “Financial”.

14. Is =PRICE volatile?

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

Explanation: PRICE is not volatile.

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

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

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