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

Quiz =ACCRINT — 10 Questions

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

Question 1 of 10 1/10

In =ACCRINT, which is argument #3?

Question 2 of 10 2/10

Is =ACCRINT volatile?

Question 3 of 10 3/10

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

Question 4 of 10 4/10

Which formula is a valid example of =ACCRINT?

Question 5 of 10 5/10

Which use case fits =ACCRINT?

Question 6 of 10 6/10

Which statement about =ACCRINT is correct?

Question 7 of 10 7/10

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

Question 8 of 10 8/10

How many arguments does =ACCRINT have in total?

Question 9 of 10 9/10

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

Question 10 of 10 10/10

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

Click a question to see the answer.

1. In =ACCRINT, which is argument #3?

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

Explanation: Argument #3 is “settlement”.

2. Is =ACCRINT volatile?

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

Explanation: ACCRINT is not volatile.

3. What is the type of argument “par” in =ACCRINT?

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

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

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

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

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

5. Which use case fits =ACCRINT?

A. Worksheet Info & Navigation
B. Securities & Bonds
C. Date & Time Calculations
D. Financial Calculations ✓

Explanation: Use case “Financial Calculations” fits ACCRINT.

6. Which statement about =ACCRINT is correct?

A. 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.
B. Text is always ignored
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. 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.

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

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

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

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

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

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

9. What is the fix for #VALUE! in =ACCRINT?

A. نرخ یا ارزش اسمی صفر/منفی است، تناوب غیر از ۱، ۲ یا ۴ است، مبنا خارج از ‎۰ تا ۴ است یا تاریخ انتشار مساوی/بعد از تسویه است.
B. Requires add-in
C. Text is always ignored
D. Enter valid dates, preferably with the DATE function ✓

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. What is the type of argument “frequency” in =ACCRINT?

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

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