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

Quiz =INTRATE — 15 Questions

15 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 — 15 questions 1 of 15

Question 1 of 15 1/15

Is argument “redemption” required in =INTRATE?

Question 2 of 15 2/15

Is argument “maturity” required in =INTRATE?

Question 3 of 15 3/15

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

Question 4 of 15 4/15

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

Question 5 of 15 5/15

In =INTRATE, which is argument #3?

Question 6 of 15 6/15

Is =INTRATE volatile?

Question 7 of 15 7/15

What is the output type of =INTRATE?

Question 8 of 15 8/15

Which use case fits =INTRATE?

Question 9 of 15 9/15

What usually causes #VALUE! in =INTRATE?

Question 10 of 15 10/15

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

Question 11 of 15 11/15

Which statement about =INTRATE is correct?

Question 12 of 15 12/15

In =INTRATE, which is argument #1?

Question 13 of 15 13/15

Which function is NOT related to =INTRATE?

Question 14 of 15 14/15

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

Question 15 of 15 15/15

Since which Excel version is =INTRATE available?

Click a question to see the answer.

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

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

Explanation: “redemption” is required.

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

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

Explanation: “maturity” is required.

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

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

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

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

A. Output is always a dynamic array
B. Text is always ignored
C. Only works in old versions
D. تاریخ‌ها را با تابع DATE وارد کنید و مطمئن شوید سلول‌های تاریخ واقعاً تاریخ هستند نه متن. ✓

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

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

A. value
B. range
C. investment ✓
D. redemption

Explanation: Argument #3 is “investment”.

6. Is =INTRATE volatile?

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

Explanation: INTRATE is not volatile.

7. What is the output type of =INTRATE?

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

Explanation: Output is “Number”.

8. Which use case fits =INTRATE?

A. Financial Calculations ✓
B. Depreciation
C. Scientific & Unit Conversion
D. Descriptive Statistics

Explanation: Use case “Financial Calculations” fits INTRATE.

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

A. Text is always ignored
B. Only works in old versions
C. Volatile and recalculates every time
D. If settlement or maturity is not a valid date, INTRATE returns the #VALUE! error value. ✓

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

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

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

11. Which statement about =INTRATE is correct?

A. Volatile and recalculates every time
B. Microsoft Excel stores dates as sequential serial numbers so they can be used in calculations. By default, January 1, 1900 is serial number 1, and January 1, 2008 is serial number 39448 because it is 39,448 days after January 1, 1900.
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. Only works in old versions

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.

12. In =INTRATE, which is argument #1?

A. range
B. investment
C. settlement ✓
D. criteria

Explanation: Argument #1 is “settlement”.

13. Which function is NOT related to =INTRATE?

A. YIELDDISC
B. RECEIVED
C. DISC
D. T.DIST ✓

Explanation: “T.DIST” is not related to INTRATE.

14. What is the fix for #NUM! in =INTRATE?

A. Requires add-in
B. Text is always ignored
C. Check the order of dates and the input values ✓
D. Volatile and recalculates every time

Explanation: If investment ≤ 0 or if redemption ≤ 0, INTRATE returns the #NUM! error value. If basis < 0 or if basis > 4, INTRATE returns the #NUM! error value. If settlement ≥ maturity, INTRATE returns the #NUM! error value. — Fix: Check the order of dates and the input values

15. Since which Excel version is =INTRATE available?

A. Excel 365
B. Excel 2019
C. Excel 2007 (Compatibility)
D. All versions ✓

Explanation: Version: “All versions”.