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 is the type of argument “investment” in =INTRATE?

Question 2 of 10 2/10

What is the output type of =INTRATE?

Question 3 of 10 3/10

Is =INTRATE volatile?

Question 4 of 10 4/10

In =INTRATE, which is argument #3?

Question 5 of 10 5/10

Which category does =INTRATE belong to?

Question 6 of 10 6/10

Is argument “basis” required in =INTRATE?

Question 7 of 10 7/10

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

Question 8 of 10 8/10

Which statement about =INTRATE is correct?

Question 9 of 10 9/10

Which function is related to =INTRATE?

Question 10 of 10 10/10

Is argument “redemption” required in =INTRATE?

Click a question to see the answer.

1. What is the type of argument “investment” in =INTRATE?

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

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

2. What is the output type of =INTRATE?

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

Explanation: Output is “Number”.

3. Is =INTRATE volatile?

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

Explanation: INTRATE is not volatile.

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

A. value
B. criteria
C. basis
D. investment ✓

Explanation: Argument #3 is “investment”.

5. Which category does =INTRATE belong to?

A. Statistical
B. Financial ✓
C. Math & Trig
D. Compatibility

Explanation: Category is “Financial”.

6. Is argument “basis” required in =INTRATE?

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

Explanation: “basis” is optional.

7. What is the fix for #VALUE! in =INTRATE?

A. تاریخ‌ها را با تابع DATE وارد کنید و مطمئن شوید سلول‌های تاریخ واقعاً تاریخ هستند نه متن. ✓
B. مقدار Investment یا Redemption صفر یا منفی است، Basis خارج از بازه ۰ تا ۴ است یا تاریخ تسویه مساوی یا بعد از سررسید است.
C. Only works in old versions
D. Volatile and recalculates every time

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

8. Which statement about =INTRATE is correct?

A. Only works in old versions
B. Settlement, maturity, and basis are truncated to integers.
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. Text is always ignored

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.

9. Which function is related to =INTRATE?

A. AMORDEGRC
B. AVERAGEIFS
C. DISC ✓
D. ROWS

Explanation: “DISC” is related to INTRATE.

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

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

Explanation: “redemption” is required.