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

Is argument “redemption” required in =INTRATE?

Question 2 of 10 2/10

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

Question 3 of 10 3/10

How many required arguments does =INTRATE have?

Question 4 of 10 4/10

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

Question 5 of 10 5/10

What is the output type of =INTRATE?

Question 6 of 10 6/10

Which statement about =INTRATE is correct?

Question 7 of 10 7/10

Which function is NOT related to =INTRATE?

Question 8 of 10 8/10

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

Question 9 of 10 9/10

Which function is related to =INTRATE?

Question 10 of 10 10/10

Is argument “basis” required in =INTRATE?

Click a question to see the answer.

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

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

Explanation: “redemption” is required.

2. What is the type of argument “basis” in =INTRATE?

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

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

3. How many required arguments does =INTRATE have?

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

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

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

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

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

5. What is the output type of =INTRATE?

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

Explanation: Output is “Number”.

6. Which statement about =INTRATE is correct?

A. 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. ✓
B. The settlement date is the date a buyer purchases a coupon, such as a bond. The maturity date is the date when a coupon expires. For example, suppose a 30-year bond is issued on January 1, 2008, and is purchased by a buyer six months later. The issue date would be January 1, 2008, the settlement date would be July 1, 2008, and the maturity date would be January 1, 2038, which is 30 years after the January 1, 2008, issue date.
C. Select entire column for best performance
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.

7. Which function is NOT related to =INTRATE?

A. WORKDAY ✓
B. DISC
C. RECEIVED
D. YIELDDISC

Explanation: “WORKDAY” is not related to INTRATE.

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

A. تاریخ‌ها را با تابع DATE وارد کنید و مطمئن شوید سلول‌های تاریخ واقعاً تاریخ هستند نه متن. ✓
B. Select entire column for best performance
C. Requires add-in
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 وارد کنید و مطمئن شوید سلول‌های تاریخ واقعاً تاریخ هستند نه متن.

9. Which function is related to =INTRATE?

A. RADIANS
B. FILTERXML
C. DISC ✓
D. DAYS

Explanation: “DISC” is related to INTRATE.

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

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

Explanation: “basis” is optional.