Skip to content

Name the table which is… (Class 12 Accountancy 2026, Q33b)

questionbuddy.in/q/cbse-12-accountancy-2026-67-1-1-q33b-name-table-interactive-way-quickly

AccountancyCBSE Class 12 · Board exam 2026, set 67/1/1 · 4 marks · Long answer

CBSE Class 12 Accountancy 2026: question 33(b)

Set in the CBSE Class 12 board exam of 2026, paper 67/1/1, section B-II, question 33(b), for 4 marks. Try it first; the hints and our step-by-step solution are below.

Q33(b) · 4 marks · Long answerUse of Spreadsheet in Business Applications

Name the table which is an interactive way to quickly summaries large amounts of data. State any three reasons why this table is designed.

Source: official question paper from cbse.gov.in (PDF). See it in the full 2026 board paper, set 67/1/1.

Hints

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

Hint 1

The table "pivots" rows and columns.

Hint 2

Think about what you want to do with a large dataset: query, summarise, rearrange, filter.

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. The table is a Pivot Table.

    1 mark

  2. It is designed for querying large amounts of data in a user-friendly way, and for creating custom calculations and formulas.

    1 mark

  3. It lets the user expand and collapse levels of data to focus on results, and move rows to columns (and back) to see different summaries.

    1 mark

  4. It allows filtering, sorting, grouping and conditional formatting of the most useful subset of data, and presenting concise, attractive reports.

    1 mark

Answer: Pivot Table; designed for querying large data easily, custom calculations, expanding/collapsing and pivoting data, filtering/sorting and concise reports (any three)

Where the marks are

  • Pivot Table named (1 mark)
  • Any three reasons (1 mark each)

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 paper2026 board paper, set 67/1/1: 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.