______ feature allows us to create a cross tabulation summary of data in which heading can subsequently moved to give different views of the 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.
Solution
Pivot Table is the feature that allows creation of cross-tabulation summaries where headings can be moved to provide different views of the same data.
A Pivot Table is a dynamic tool that summarizes large amounts of data by allowing users to:
- Drag and drop row and column headings to reorganize information
- Create different perspectives of the same dataset without changing the original data
- Generate cross-tabulated summaries automatically
Why other options are incorrect:
Data Table is used for what-if analysis, showing how changes in input values affect formula results. It cannot reorganize headings for different data views.
Data Cells are simply regular cells that contain data. They don't provide any summarization or reorganization functionality.
Print Area defines the specific range of cells to be printed. It has no relation to data summarization or cross-tabulation.
The key distinguishing feature of a Pivot Table is its ability to dynamically reorganize data by moving fields between rows, columns, and values areas, which matches exactly what the question describes.
Related questions:
2025: 27 May Shift 1
2023: 20 June Shift 2
2025: 27 May Shift 1
2025: 27 May Shift 2