CBSE Class 12 Accountancy sample paper 2024-25: question 27(a)
From the official CBSE sample question paper for 2024-25, section B-II, question 27(a), for 1 mark. Try it first; the hints and our step-by-step solution are below.
Q27(a) · 1 mark · MCQUse of Spreadsheet in Business Applications
The syntax of PMT Function is ___________
- (A)PMT (rate, pv, nper, [fv], [type])
- (B)PMT (rate, nper, pv, [fv], [type])
- (C)PMT (rate, pv, nper, [type], [fv])
- (D)PMT (rate, nper, pv, [type], [fv])
Source: official sample paper from cbseacademic.nic.in (PDF). See it in the full Sample paper 2024-25.
Hints
Open one hint at a time and try again before the next.
Hint 1
Required arguments come before the 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.
PMT takes the rate per period first, then the number of periods, then the present value; future value and type are optional.
- 1 mark
So the syntax is PMT(rate, nper, pv, [fv], [type]). Option (B).
Answer: (B) PMT (rate, nper, pv, [fv], [type])
Where the marks are
- Correct argument order of PMT (1 mark)
Revise the chapter
- Chapter: Use of Spreadsheet in Business Applications (notes, formulas, where marks are lost and every past question)
More questions from Use of Spreadsheet in Business Applications
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.