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:

Voting Shares

Shares that give the shareholder voting rights in company decisions, typically one vote per share.

Consolidated Financial Statements

Combined financial reporting documents that present the overall financial status of a parent company and its subsidiaries as a single entity.

Voting Rights

The rights of shareholders to vote on company matters, such as electing directors or approving major corporate actions.

Consolidated Financial Statements

Financial statements that aggregate all the financial information of a parent company and its subsidiaries into one document.