As he prepares his assignment for his Marketing class, Ted goes to his friend Carter for help with PivotTables because Carter has had a lot of experience with them in his job.
-Ted wants to be able to analyze date data in his PivotTable by month.What must he do with the date field in his PivotTable?
A)He must aggregate the data by the date field.
B)He must cluster the data by the date field.
C)He must sort the data by the date field.
D)He must group the data by the date field.

Question

Quizplus · Accepted Answer

In order to analyze date data by month, Ted must group the data by the date field. Grouping allows the user to combine dates into larger time periods, such as months, quarters, or years, which makes it easier to analyze the data. Aggregating the data would simply sum or count the values in each date, which would not achieve Ted's goal of analyzing by month. Clustering and sorting the data would not change the grouping of the dates.

As He Prepares His Assignment for His Marketing Class, Ted