Financial =INTRATE(settlement, maturity, investment, redemption, [basis])

Quiz =INTRATE — 10 Questions

10 quiz questions about =INTRATE — test syntax, arguments, examples & errors!

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

← INTRATE ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

What usually causes #VALUE! in =INTRATE?

Question 2 of 10 2/10

Is argument “settlement” required in =INTRATE?

Question 3 of 10 3/10

How many required arguments does =INTRATE have?

Question 4 of 10 4/10

In =INTRATE, which is argument #2?

Question 5 of 10 5/10

What is the output type of =INTRATE?

Question 6 of 10 6/10

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

Question 7 of 10 7/10

Which category does =INTRATE belong to?

Question 8 of 10 8/10

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

Question 9 of 10 9/10

How many optional arguments does =INTRATE have?

Question 10 of 10 10/10

Is argument “investment” required in =INTRATE?

Click a question to see the answer.

1. What usually causes #VALUE! in =INTRATE?

A. مقدار Investment یا Redemption صفر یا منفی است، Basis خارج از بازه ۰ تا ۴ است یا تاریخ تسویه مساوی یا بعد از سررسید است.
B. If settlement or maturity is not a valid date, INTRATE returns the #VALUE! error value. ✓
C. Volatile and recalculates every time
D. Output is always a dynamic array

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

2. Is argument “settlement” required in =INTRATE?

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

Explanation: “settlement” is required.

3. How many required arguments does =INTRATE have?

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

Explanation: =INTRATE has 4 required, 1 optional (5 total).

4. In =INTRATE, which is argument #2?

A. maturity ✓
B. investment
C. criteria
D. lookup_value

Explanation: Argument #2 is “maturity”.

5. What is the output type of =INTRATE?

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

Explanation: Output is “Number”.

6. What is the type of argument “maturity” in =INTRATE?

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

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

7. Which category does =INTRATE belong to?

A. Text
B. Financial ✓
C. Math & Trig
D. Date & Time

Explanation: Category is “Financial”.

8. What is the type of argument “settlement” in =INTRATE?

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

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

9. How many optional arguments does =INTRATE have?

A. 0
B. 1 ✓
C. 2
D. 3

Explanation: =INTRATE has 4 required, 1 optional (5 total).

10. Is argument “investment” required in =INTRATE?

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

Explanation: “investment” is required.