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

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

Arrange the following steps in correct order to create a Pivot Table in Excel?Answer areaChoose the type of calculation you want to perform on the data (e.g., sum, count, average).Review and analyze the summarized data presented in the PivotTable.Drag and drop the fields from the PivotTable Field List to the Rows, Columns, Values, or Filters areas.Select the data range that you want to analyze.Click on the "Insert" tab in the Excel ribbon.Click on the "PivotTable" button and select "PivotTable" from the dropdown menu.Adjust the layout and formatting of the PivotTable as needed.SubmitReset AnswerPreviousNext

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.

In MS Excel, what is the purpose of the "Group Field"  in a PivotTable?AIt allows you to sort data in ascending or descending order.BIt provides s to group dates or numeric values.CIt enables you to combine multiple data fields into one.DIt allows you to create calculated fields.