As He Prepares His Assignment for His Marketing Class, Ted

question 85

Multiple Choice

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 use his PivotTable to show the total value of the motorcycles for a series of motorcycle dealerships but he wants to filter the display to show only those dealers whose total stock of motorcycle is greater than $1 million.How would he accomplish this?

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

---

Definitions:

Banks

Financial institutions that accept deposits from the public, lend money, and offer various other financial services.

National Railroad Network

A comprehensive system of railway lines and routes covering a national territory, facilitating passenger and freight transport.

Civil War

An internal conflict between factions or regions within the same country, where the factions fight for political control, ethnic or religious reasons, or territorial independence.

Protective Tariffs

Taxes imposed on imported goods to protect domestic industries from foreign competition by making imported goods more expensive.