Answer:
D. Pivot table
Step-by-step explanation:
Microsoft Excel is a software application or program designed and developed by Microsoft Inc., for analyzing and visualizing spreadsheet documents.
A spreadsheet can be defined as a file or document which comprises of cells in a tabulated format (rows and columns) typically used for formatting, arranging, analyzing, storing, calculating and sorting data on computer systems.
Generally, it is extremely difficult and considered to be a herculean task to understand, analyze and summarize data when they are raw and unorganized.
In order to overcome this challenge or hurdle, Microsoft inc. designed and developed Pivot tables and charts to avail end users the ability to visualize, understand, analyze and summarize data in its raw form.
Hence, Pivot table allows you to organize and summarize selected columns and rows of data in a spreadsheet to obtain a desired report. It is an in-built feature of the Microsoft Excel software application or program.