Critical Thinking Case-Based Questions Case 5-3 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. If Ted decides that he wants to work with nonnumeric data in his PivotTable, what function must he use to produce summaries?
A)Sum
B)Aggregate
C)Total
D)Count

Question

Critical Thinking Case-Based Questions Case 5-3 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. ​If Ted decides that he wants to work with nonnumeric data in his PivotTable, what function must he use to produce summaries?
A)Sum
B)Aggregate
C)Total
D)Count

Quizplus · Accepted Answer

The "Count" function is used in PivotTables to summarize nonnumeric data by counting the number of occurrences of each unique item.

Critical Thinking Case-Based Questions Case 5-3 as He Prepares His