Answer:
Pivot Table is a cross tabulation report based on list-type data.
Explanation:
This type of table summarizes and analyze the data from different source. It makes the information readable and easy to comprehend even for large set of data.
We go for creating a pivot table for the following reasons:
a. Extract smaller amount of data from a huge data
b. Compare data
c. Organize the data in sub-categories within larger-categories of data
The spreadsheet or other excel software allows the user to modify the layout and data of the pivot table from a Pivot Chart.
