Skip to content

State the advantag… (Class 12 Accountancy SQP 2026-27, Q31B)

questionbuddy.in/q/cbse-12-accountancy-2026-27-sqp-q31b-advantages-pivot-table-report

AccountancyCBSE Class 12 · Sample paper, session 2026-27 · 3 marks · Short answer

CBSE Class 12 Accountancy sample paper 2026-27: question 31(B)

From the official CBSE sample question paper for 2026-27, section B-II, question 31(B), for 3 marks. Try it first; the hints and our step-by-step solution are below.

Q31(B) · 3 marks · Short answerUse of Spreadsheet in Business Applications

State the advantages of 'Pivot Table Report'.

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

Hints

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

Hint 1

What does a pivot table do with a long list of transactions?

Hint 2

Think of dragging fields between rows and columns.

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. Summarises large data quickly, with totals, averages and counts produced automatically.

    1 mark

  2. Flexible: rows and columns can be rearranged easily to see the data from different angles.

    1 mark

  3. Quick comparison and time saving: it is easy to compare groups of data, and it is user-friendly.

    1 mark

Answer: Any three: summarises large data quickly; easy analysis with automatic totals, averages and counts; flexible rearrangement of rows and columns; quick comparison; time-saving and user-friendly

Where the marks are

  • 1 mark for each of three advantages (3 marks)

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 2026-27: 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.