Answered step by step
Verified Expert Solution
Link Copied!

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
image text in transcribed
image text in transcribed
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

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions