Skip to content

The syntax of PMT… (Class 12 Accountancy SQP 2023-24, Q30a)

questionbuddy.in/q/cbse-12-accountancy-2023-24-sqp-q30a-syntax-pmt-function

AccountancyCBSE Class 12 · Sample paper, session 2023-24 · 1 mark · MCQ

CBSE Class 12 Accountancy sample paper 2023-24: question 30(a)

From the official CBSE sample question paper for 2023-24, section B-II, question 30(a), for 1 mark. Try it first; the hints and our step-by-step solution are below.

Q30(a) · 1 mark · MCQUse of Spreadsheet in Business Applications

The syntax of PMT Function is ___________

  1. (A)PMT(rate,pv,nper, [fv],[type])
  2. (B)PMT(rate,nper,pv,[fv],[type])
  3. (C)PMT(rate,pv,nper,[type],[fv])
  4. (D)PMT(rate,nper,pv,[type],[fv])

Source: official sample paper from cbseacademic.nic.in (PDF). See it in the full Sample paper 2023-24.

Hints

Open one hint at a time and try again before the next.

Hint 1

Required arguments come before optional ones in square brackets.

Hint 2

Rate, then number of periods, then present value.

Step-by-step solution

Each step shows the marks it earns, as an examiner would award them. Checked by an independent re-solve from the question paper.

  1. PMT takes the interest rate per period first, then the number of periods, then the present value; future value and type are optional.

  2. So the syntax is PMT(rate, nper, pv, [fv], [type]). Option (B).

    1 mark

Answer: (B) PMT(rate,nper,pv,[fv],[type])

Where the marks are

  • Correct argument order of PMT (1 mark)

Revise the chapter

Practise this chapterBoard-style questions from Use of Spreadsheet in Business Applications, one at a time, marked against the answer key and marking points.Back to the full paperSample paper 2023-24: every question, by section.

The question is transcribed from the official paper; figures are described in words. The solution, hints and chapter tag are ours. Spotted an error? Write tosupport@questionbuddy.in.