What is a PivotTable? Describe its utility
Answers
Explanation:
A Pivot Table is used to summarise, sort, reorganise , group, count, total or average data stored in a table.
A pivot table is a statistics tool that summarizes and reorganizes selected columns and rows of data in a spreadsheet or database table to obtain a desired report. The tool does not actually change the spreadsheet or database itself, it simply “pivots” or turns the data to view it from different perspectives.
When users create a pivot table, there are four main components:
1. Columns- When a field is chosen for the column area, only the unique values of the field are listed across the top.
2. Rows- When a field is chosen for the row area, it populates as the first column. Similar to the columns, all row labels are the unique values and duplicates are removed.
3. Values- Each value is kept in a pivot table cell and display the summarized information. The most common values are sum, average, minimum and maximum.
4. Filters- Filters apply a calculation or restriction to the entire table.