Jamie Wants to Use Her PivotTable to Show the Total

question 77

Multiple Choice

Jamie wants to use her PivotTable to show the total value of the cars for a series of car dealerships but she wants to filter the display to show only those dealers whose total stock of cars is greater than $1 million.How would she accomplish this?

• A) She would develop a PivotTable using the aggregate filter.
• B) She would develop a PivotTable using the report filter.
• C) She would develop a PivotTable using the category filter.
• D) She would develop a PivotTable using the value filter.

---

Definitions:

Technology Close

A close in which the seller uses technology to present information.

Act Professionally

Conducting oneself in a manner that is ethical, responsible, and respectful within a professional environment, often adhering to the standards and expectations of the profession.

T-Account Close

The process of transferring the balances of temporary accounts to a permanent account at the end of an accounting period to prepare for a new period.

Benjamin Franklin Close

A sales technique that encourages a customer to make a decision by listing pros and cons of purchasing a product or service, akin to Benjamin Franklin's decision-making method.