Case 5-2
Cali has just discovered the power of using text filters to control which records display in his worksheet,and he has begun to use them often to find precisely the records he needs.The following questions are based on a camp directory table that includes First Name,Last Name,Date of Birth,Camp,and Phone Number.
-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

Case 5-2
Cali has just discovered the power of using text filters to control which records display in his worksheet,and he has begun to use them often to find precisely the records he needs.The following questions are based on a camp directory table that includes First Name,Last Name,Date of Birth,Camp,and Phone Number.
-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

To work with nonnumeric data in a PivotTable, the "Count" function is used to produce summaries by counting the number of entries in a dataset, rather than summing their values, which is not possible with nonnumeric data.

Case 5-2 Cali Has Just Discovered the Power of Using Text Filters