What is the primary purpose of a Pivot Table in Excel?Group of answer choicesData sortingData encryptionData analysis and summarizationData validation

In Microsoft Excel, what are pivot tables mainly used for?AFixing a column to a position in order to organize other columns around itBSorting tables by the data in one or more columnsCGrouping rows by columns and computing aggregate statisticsDIntelligently rearranging columns to make spreadsheets easier to read

A pivot table is a data-summarization tool used in data processing. Which of the following tasks can pivot tables perform? Select all that apply.1 pointClean dataReorganize dataGroup dataCalculate totals from data

A pivot table is used to summarize, analyze, explore, and present summary data. True False

Which is NOT true about pivot table?Question 1Select one:a.It allows a static view of your data.b.The data should be organised as stacked data.c.You can manipulate various ways to see data summary.d.You can change the summary functions.

Question 2In the text box below, write 2-3 sentences (40-60 words) in response to each of the following questions:How can using pivot tables directly in a spreadsheet help you analyze data in the future?What are some of the benefits of being able to summarize data directly in your spreadsheet?