What is the main purpose of a pivot table in Excel?

$q,$

A$.$ To summarize and analyze information in a data set

B$.$ To perform calculations across several worksheets

C$.$ To create graphs of data across time

D$.$ To remove data that is not useful