Accountancy Part CSpreadsheet

_____ feature allows us to create a cross tabulation summary of data…

_____ feature allows us to create a cross tabulation summary of data in which heading can subsequently moved to give different views of the data.

Answer & explanation

Correct answer: option 1

The correct answer is Option (1) → Pivot Table

A Pivot Table summarises a list of data in rows and columns (a cross tabulation). Its headings can be dragged to other positions, so the same data can be viewed in different ways without retyping it.

NCERT (2026-27 edition):
Pivot Tables – “… The Pivot Table feature allows us to create a cross tabulation summary of data in which heading can subsequently moved to give different views of the data.”