Target Exam

CUET

Subject

-- Accountancy Part C

Chapter

Spreadsheet

Question:

In what type of financial situation is the ACCRINT function most useful?

Options:

Calculating sales tax

Tracking inventory

Calculating interest on periodic-pay securities

Summing values across columns

Correct Answer:

Calculating interest on periodic-pay securities

Explanation:

The correct answer is option 3- Calculating interest on periodic-pay securities.

ACCRINT function returns the accrued interest for a security that pays periodic interest. The syntax of this is as follows: ACCRINT (issue, first_interest, settlement, rate, par, frequency, basis, calc_method).