What is the purpose of a pivot table?

A. to summarize, sort, reorganize, group, count, total or average data stored in a table.

B. to transpose the rows and columns (change rows to columns and change columns to rows) in a table.

C. to rotate a table

D. to enable Excel to calculate the inverse of a matrix