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.

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

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

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

Pivot tables do not process dates like Excel usually does, because ordering dates can be necessary and grouping couldn't otherwise be done True False

is used to group rows based on distinct values for specified column.