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:

Courage

The mental or moral strength to venture, persevere, and withstand danger, fear, or difficulty.

Sign Of Vulnerability

An indicator or symptom that an individual, system, or organization may be weak, exposed, or susceptible to attack or harm.

Projecting Confidence

The act of displaying assurance and self-assuredness in one's capabilities and presence through body language, speech, and behavior.

Common Reactions

General or typical responses or behaviors in specific situations or under stress.