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

question 63

Multiple Choice

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

---

Definitions:

Cease and Desist Order

A legal order issued by a government authority or court directing an individual or entity to stop an alleged illegal activity.

Misleading Advertisement

Marketing materials that deceive or mislead consumers about the nature or value of a product.

Federal Consumer Credit Protection Act

A United States law enacted in 1968 aimed at protecting consumers in financial transactions by requiring clear disclosure of terms and costs of credit and establishing consumer rights regarding credit billing and electronic fund transfers.

Garnishment Proceedings

A legal process by which a creditor can collect what is owed from a debtor's salary, bank accounts, or other assets directly from the third party holding them.