Critical Thinking Case-Based Questions Case 5-3 as He Prepares His

question 48

Multiple Choice

Critical Thinking Case-Based Questions Case 5-3 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:

Relocating Expatriates

The process of moving employees from their home country to a foreign country for work assignments.

Global Firms

Organizations that operate and have a presence in multiple countries across the world, often dealing with a global market and diverse cultures.

Japanese Firms

Companies or business entities based in Japan, often characterized by their management practices and approaches to manufacturing and service delivery.

Matsushita

A Japanese multinational electronics company, also known as Panasonic, known for its innovations and contributions to the electronics industry.