Question

What is a PivotTable? Describe its utility​

Answer 1

Explanation:

A Pivot Table is used to summarise, sort, reorganise , group, count, total or average data stored in a table.

Answer 2

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.