Financial =ACCRINT(issue, first_interest, settlement, rate, par, frequency, [basis], [calc_method])

Quiz =ACCRINT — 15 Questions

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

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

← ACCRINT ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

Does =ACCRINT return a dynamic array?

Question 2 of 15 2/15

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

Question 3 of 15 3/15

Which statement about =ACCRINT is correct?

Question 4 of 15 4/15

Is argument “calc_method” required in =ACCRINT?

Question 5 of 15 5/15

How many required arguments does =ACCRINT have?

Question 6 of 15 6/15

How many arguments does =ACCRINT have in total?

Question 7 of 15 7/15

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

Question 8 of 15 8/15

Which function is related to =ACCRINT?

Question 9 of 15 9/15

What usually causes #VALUE! in =ACCRINT?

Question 10 of 15 10/15

Is argument “settlement” required in =ACCRINT?

Question 11 of 15 11/15

Is argument “issue” required in =ACCRINT?

Question 12 of 15 12/15

Which category does =ACCRINT belong to?

Question 13 of 15 13/15

Which formula is a valid example of =ACCRINT?

Question 14 of 15 14/15

Is argument “basis” required in =ACCRINT?

Question 15 of 15 15/15

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

Click a question to see the answer.

1. Does =ACCRINT return a dynamic array?

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

Explanation: ACCRINT does not spill.

2. What is the type of argument “settlement” in =ACCRINT?

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

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

3. Which statement about =ACCRINT 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. Issue, first_interest, settlement, frequency, and basis are truncated to integers.
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.

4. Is argument “calc_method” required in =ACCRINT?

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

Explanation: “calc_method” is optional.

5. How many required arguments does =ACCRINT have?

A. 7
B. 6 ✓
C. 5
D. 8

Explanation: =ACCRINT has 6 required, 2 optional (8 total).

6. How many arguments does =ACCRINT have in total?

A. 7
B. 10
C. 9
D. 8 ✓

Explanation: =ACCRINT has 6 required, 2 optional (8 total).

7. What is the type of argument “basis” in =ACCRINT?

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

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

8. Which function is related to =ACCRINT?

A. ERF.PRECISE
B. SUMPRODUCT
C. ACCRINTM ✓
D. NOW

Explanation: “ACCRINTM” is related to ACCRINT.

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

A. Requires add-in
B. If issue, first_interest, or settlement is not a valid date, ACCRINT returns the #VALUE! error value. ✓
C. Output is always a dynamic array
D. Select entire column for best performance

Explanation: If issue, first_interest, or settlement is not a valid date, ACCRINT returns the #VALUE! error value. — Fix: Enter valid dates, preferably with the DATE function

10. Is argument “settlement” required in =ACCRINT?

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

Explanation: “settlement” is required.

11. Is argument “issue” required in =ACCRINT?

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

Explanation: “issue” is required.

12. Which category does =ACCRINT belong to?

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

Explanation: Category is “Financial”.

13. Which formula is a valid example of =ACCRINT?

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

Explanation: Correct example: =ACCRINT(A2,A3,A4,A5,A6,A7,A8)

14. Is argument “basis” required in =ACCRINT?

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

Explanation: “basis” is optional.

15. What is the fix for #NUM! in =ACCRINT?

A. یکی از تاریخ‌های issue، first_interest یا settlement معتبر نیست.
B. Select entire column for best performance
C. Check the input values and the order of the dates ✓
D. Output is always a dynamic array

Explanation: If rate ≤ 0 or if par ≤ 0, ACCRINT returns the #NUM! error value. If frequency is any number other than 1, 2, or 4, ACCRINT returns the #NUM! error value. If basis < 0 or if basis > 4, ACCRINT returns the #NUM! error value. If issue ≥ settlement, ACCRINT returns the #NUM! error value. — Fix: Check the input values and the order of the dates