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

Other questions on the subject: Business

Business, 22.06.2019 01:10, isaiahmichel93081

Technology corp. is considering a $238,160 investment in a new marketing campaign that it anticipates will provide annual cash flows of $52,000 for the next five years. the firm has a 6% cost of capital. what should the analysis indicate to the firm's managers?

Answers: 2

continue

Business, 22.06.2019 18:00, Aethis

Biochemical corp. requires $600,000 in financing over the next three years. the firm can borrow the funds for three years at 10.80 percent interest per year. the ceo decides to do a forecast and predicts that if she utilizes short-term financing instead, she will pay 7.50 percent interest in the first year, 12.15 percent interest in the second year, and 8.25 percent interest in the third year. assume interest is paid in full at the end of each year. a)determine the total interest cost under each plan. a) long term fixed rate: b) short term fixed rate: b) which plan is less costly? a) long term fixed rate plan b) short term variable rate plan

Answers: 2

continue

Business, 22.06.2019 21:00, nikkiwoodward1ovgszp

Warner inc. sells a high-speed retrieval system for mining information. it provides the following information for the year. budgeted actual overhead cost $965,700 $905,000 machine hours 58,570 49,200 direct labor hours 107,300 104,200 overhead is applied on the basis of direct labor hours. compute the predetermined overhead rate. predetermined overhead rate $ per direct labor hour link to text determine the amount of overhead applied for the year. the amount of overhead applied $

Answers: 1

continue

Business, 22.06.2019 23:10, 401666

Mr. pines is considering buying a house and renting it to students. the yearly operating costs are $1,900. the house can be sold for $175,000 at the end of 10 years and it is considered 18% to be a suitable annual effective interest rate. if the house costs $100,000 to purchase, how much would you need to charge your tenants each year in rent? (assume a single payment for the years rent at the end of each year)

Answers: 1

continue

You know the right answer?

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