Business, 11.05.2021 18:10 tatipop49

A sales manager for an auto dealer has created a PivotTable showing monthly sales as the column labels and the automobile models as the row labels. However, the raw data that the table is based on has many more columns that list out whether or not each model has certain features, such as satellite radio or four-wheel drive. The sales manager would like to show the company’s owner how filtering out certain options affects the sums of sales. What should the sales manager do in order to present the owner with a PivotTable in which the owner can most easily filter certain vehicle options in or out to see buyer demands for those options?
A The sales manager should create slicers for each option that should be filtered and let the owner click within those slicers.
B The sales manager should create a collection of PivotTables that each use different vehicle options in the Report Filter section.
C The sales manager should place every vehicle option in the Report Filter section and show the owner how to open the different filters.
D The sales manager should place a vehicle option in the Row Labels section instead of the vehicle model and let the owner try different options as the row labels.

Answers: 2

Show answers

Another question on Business

Business, 22.06.2019 17:30

The purchasing agent for a company that assembles and sells air-conditioning equipment in a latin american country noted that the cost of compressors has increased significantly each time they have been reordered. the company uses an eoq model to determine order size. what are the implications of this price escalation with respect to order size? what factors other than price must be taken into consideration?

Answers: 1

Answer

Business, 22.06.2019 18:00

When peter metcalf describes black diamond’s manufacturing facility in china as a “greenfield project,” he means that partnered with a chinese company to buy the plant . of all market entry strategies, this one carries the lowest risk. because black diamond manufactures its outdoor sports products outside the united states, what risks must its managers be aware of?

Answers: 1

Answer

Business, 22.06.2019 21:50

Abus pass costs $5 per week. which of the following equations shows the total cost in dollars, t, of the bus pass for a certain number of weeks, w? t = 5w w = 5t t = 5 + w w = 5 + t

Answers: 3

Answer

Business, 23.06.2019 00:00

An attorney came to work on a saturday. when he signed in, he was advised by the morning security guard employed by the building management that he must be out of the building by 5 p.m., when it closes. however, he stayed past 5 p.m. to complete a brief that had to be filed on monday morning. at 5: 15 p.m., the afternoon security guard set the locks on all the doors of the building and left. because she was in a hurry, she did not check the sign-in sheet to make sure that everyone had signed out, contrary to mandatory procedures. when the attorney tried to exit 15 minutes later, he discovered that the doors were all locked and could not be opened from the inside. he used his cell phone to call for , and a supervisor from the building arrived and let him out shortly thereafter. if the attorney sues the building management for false imprisonment, is he likely to win?

Answers: 1

Answer

You know the right answer?

A sales manager for an auto dealer has created a PivotTable showing monthly sales as the column labe...

Questions