Financial =ACCRINTM(issue, settlement, rate, par, [basis])

Quiz =ACCRINTM — 15 Questions

15 quiz questions about =ACCRINTM — test syntax, arguments, examples & errors!

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

← ACCRINTM ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

What is the type of argument “rate” in =ACCRINTM?

Question 2 of 15 2/15

In =ACCRINTM, which is argument #1?

Question 3 of 15 3/15

What is the output type of =ACCRINTM?

Question 4 of 15 4/15

Which formula is a valid example of =ACCRINTM?

Question 5 of 15 5/15

Is argument “settlement” required in =ACCRINTM?

Question 6 of 15 6/15

Which function is NOT related to =ACCRINTM?

Question 7 of 15 7/15

In =ACCRINTM, which is argument #2?

Question 8 of 15 8/15

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

Question 9 of 15 9/15

What is the type of argument “par” in =ACCRINTM?

Question 10 of 15 10/15

Is argument “par” required in =ACCRINTM?

Question 11 of 15 11/15

Which category does =ACCRINTM belong to?

Question 12 of 15 12/15

Which statement about =ACCRINTM is correct?

Question 13 of 15 13/15

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

Question 14 of 15 14/15

In =ACCRINTM, which is argument #3?

Question 15 of 15 15/15

Which is the correct syntax of =ACCRINTM?

Click a question to see the answer.

1. What is the type of argument “rate” in =ACCRINTM?

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

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

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

A. par
B. criteria
C. issue ✓
D. rate

Explanation: Argument #1 is “issue”.

3. What is the output type of =ACCRINTM?

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

Explanation: Output is “Number”.

4. Which formula is a valid example of =ACCRINTM?

A. ACCRINTM(A2,A3,A4,A5,A6)
B. =ACCRINT(A2,A3,A4,A5,A6)
C. =ACCRINTM(A2,A3,A4,A5,A6, 0)
D. =ACCRINTM(A2,A3,A4,A5,A6) ✓

Explanation: Correct example: =ACCRINTM(A2,A3,A4,A5,A6)

5. Is argument “settlement” required in =ACCRINTM?

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

Explanation: “settlement” is required.

6. Which function is NOT related to =ACCRINTM?

A. PY ✓
B. ACCRINT
C. YEARFRAC
D. PRICEMAT

Explanation: “PY” is not related to ACCRINTM.

7. In =ACCRINTM, which is argument #2?

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

Explanation: Argument #2 is “settlement”.

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

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

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

9. What is the type of argument “par” in =ACCRINTM?

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

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

10. Is argument “par” required in =ACCRINTM?

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

Explanation: “par” is required.

11. Which category does =ACCRINTM belong to?

A. Statistical
B. Cube
C. Engineering
D. Financial ✓

Explanation: Category is “Financial”.

12. Which statement about =ACCRINTM 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. Output is always a dynamic array
C. Issue, settlement, and basis are truncated to integers.
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.

13. What is the fix for #NUM! in =ACCRINTM?

A. Text is always ignored
B. Volatile and recalculates every time
C. Check the order of the dates and the input values ✓
D. Select entire column for best performance

Explanation: If rate ≤ 0 or if par ≤ 0, ACCRINTM returns the #NUM! error value. If basis < 0 or if basis > 4, ACCRINTM returns the #NUM! error value. If issue ≥ settlement, ACCRINTM returns the #NUM! error value. — Fix: Check the order of the dates and the input values

14. In =ACCRINTM, which is argument #3?

A. rate ✓
B. lookup_value
C. basis
D. par

Explanation: Argument #3 is “rate”.

15. Which is the correct syntax of =ACCRINTM?

A. =ACCRINTM(issue, settlement, rate, par, [basis], 0)
B. =ACCRINT(issue, settlement, rate, par, [basis])
C. =ACCRINTM(issue, settlement, rate, par, [basis]) ✓
D. ACCRINTM(issue, settlement, rate, par, [basis])

Explanation: Correct syntax: =ACCRINTM(issue, settlement, rate, par, [basis])