Question

______ is a tool built into Microsoft Excel to summarize, sort, reorganize, group, count, total or average data stored in a database.
1. Filtering and Sorting
2. Data Analysis
3. Pivot Table
4. Power View

Answer 1

Correct Answer - Option 3 : Pivot Table

The correct answer is "Pivot Table".

Pivot Table: 

• We can use pivot tables to sort, reorganize, group, count, total or average data stored in a database.
• They are the perfect solution when you need to summarize and analyze large amounts of information.

• The Pivot Table feature allows the user to create a cross-tabulation summary of data in which heading can subsequently move to give different views of the data.
• Pivot tables are useful with large amounts of data that would be time-consuming to calculate by hand. 
• It flips and sums data in seconds and allows us to perform data analysis and generating reports like periodic financial statements, statistical reports, etc.