Target Exam

CUET

Subject

Accountancy Part C

Chapter

Use of Spreadsheet in Business Applications

Question:

In what cell is the Rate for PMT function where = PMT (C8, C9, C10, C11, C12)?

Options:

C8

C9

C10

C12

Correct Answer:

C8

Explanation:

Correct answer: Option (1) → C8

Concept: The PMT (loan instalment) financial function, from Use of Spreadsheet in Business Applications.

The syntax is PMT(Rate, Nper, Pv, [Fv], [Type]), where the FIRST argument is the interest rate per period. In =PMT(C8, C9, C10, C11, C12) the first argument is C8, so the Rate is contained in cell C8. Hence Option (1).