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

Quiz =ACCRINTM — 10 Questions

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

Question 1 of 10 1/10

In =ACCRINTM, which is argument #2?

Question 2 of 10 2/10

Which statement about =ACCRINTM is correct?

Question 3 of 10 3/10

Which is the correct syntax of =ACCRINTM?

Question 4 of 10 4/10

Which function is NOT related to =ACCRINTM?

Question 5 of 10 5/10

Since which Excel version is =ACCRINTM available?

Question 6 of 10 6/10

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

Question 7 of 10 7/10

What usually causes #VALUE! in =ACCRINTM?

Question 8 of 10 8/10

Does =ACCRINTM return a dynamic array?

Question 9 of 10 9/10

Is argument “par” required in =ACCRINTM?

Question 10 of 10 10/10

Which function is related to =ACCRINTM?

Click a question to see the answer.

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

A. settlement ✓
B. range
C. par
D. basis

Explanation: Argument #2 is “settlement”.

2. Which statement about =ACCRINTM is correct?

A. Only works in old versions
B. 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. ✓
C. Issue, settlement, and basis are truncated to integers.
D. Volatile and recalculates every time

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.

3. Which is the correct syntax of =ACCRINTM?

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

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

4. Which function is NOT related to =ACCRINTM?

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

Explanation: “FINDB” is not related to ACCRINTM.

5. Since which Excel version is =ACCRINTM available?

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

Explanation: Version: “All versions”.

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

A. Check the order of the dates and the input values ✓
B. Output is always a dynamic array
C. Volatile and recalculates every time
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

7. What usually causes #VALUE! in =ACCRINTM?

A. If issue or settlement is not a valid date, ACCRINTM returns the #VALUE! error value. ✓
B. نرخ (Rate) یا ارزش اسمی (Par) صفر یا منفی است، مبنای شمارش روز (Basis) خارج از بازه ۰ تا ۴ است، یا تاریخ انتشار مساوی یا بعد از تاریخ سررسید است.
C. Volatile and recalculates every time
D. Only works in old versions

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

8. Does =ACCRINTM return a dynamic array?

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

Explanation: ACCRINTM does not spill.

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

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

Explanation: “par” is required.

10. Which function is related to =ACCRINTM?

A. ACCRINT ✓
B. SORTBY
C. NOMINAL
D. YIELDMAT

Explanation: “ACCRINT” is related to ACCRINTM.