Answered step by step
Verified Expert Solution
Question
1 Approved Answer
i want the steps to the marked qustuin please niswer the following questionis using a Pivot Table (see detalled instructions below): 1. In what quarters
i want the steps to the marked qustuin please
niswer the following questionis using a Pivot Table (see detalled instructions below): 1. In what quarters did our customer Black Angus Steakhouse order the two hightest dollar amounts worth of products? 2. Who is the best performer among our sales force (highest order amount)? 3. Don Jones did not bring orders in what quarter? 4. What is our besteseiling product and bow much tevenue (order amount) did it generate? 5. What products only sold in Quarter 12 (use Quarter) Exed adds two new columns (helda) to the pivot table. Quarters and Years. Use the ociginal Quarter column for this question Note: In finding answers. let MS Excel do the work for you. Although finding the answers visually in this exercise is possible, you would not be able to do it if you had thousands of ph of customens. Une the sorting and fitering functions to your advantage. For example, if you need to find the highest amount, sort descending by amount. Doing this will show the an the top, Bee rescurcelul if Notei Do not use slbets ouly to fotmat the plwot table atter visually finding the answer. That is. if you found the best salesperson by visually finding then highest order ainount, do not get al slicer to fitter by the salesperson's name This is an incorrect use of the tools so points will be deducted. Now let's do int niswer the following questionis using a Pivot Table (see detalled instructions below): 1. In what quarters did our customer Black Angus Steakhouse order the two hightest dollar amounts worth of products? 2. Who is the best performer among our sales force (highest order amount)? 3. Don Jones did not bring orders in what quarter? 4. What is our besteseiling product and bow much tevenue (order amount) did it generate? 5. What products only sold in Quarter 12 (use Quarter) Exed adds two new columns (helda) to the pivot table. Quarters and Years. Use the ociginal Quarter column for this question Note: In finding answers. let MS Excel do the work for you. Although finding the answers visually in this exercise is possible, you would not be able to do it if you had thousands of ph of customens. Une the sorting and fitering functions to your advantage. For example, if you need to find the highest amount, sort descending by amount. Doing this will show the an the top, Bee rescurcelul if Notei Do not use slbets ouly to fotmat the plwot table atter visually finding the answer. That is. if you found the best salesperson by visually finding then highest order ainount, do not get al slicer to fitter by the salesperson's name This is an incorrect use of the tools so points will be deducted. Now let's do int Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started