Question: Using the Detail tab as your data source: This extends down to row 3003 Generate a pivot table and related bar chart depicted on a

Using the Detail tab as your data source: ThisUsing the Detail tab as your data source: ThisUsing the Detail tab as your data source: This

Using the Detail tab as your data source: This extends down to row 3003

  • Generate a pivot table and related bar chart depicted on a new sheet entitled "Sales by Rep"
  • Generate a second pivot table and related bar chart on a new sheet entitled "Product Sales"
  • Generate a third pivot table with a related pie chart on a new sheet entitled "Region Sales"
A 1 Date 2 1/1/2018 3 1/2/2018 4 1/3/2018 5 1/20/2018 6 1/30/2018 7 1/31/2018 8 2/1/2018 9 2/2/2018 10 2/3/2018 2/5/2018 11 2/4/2018 12 13 2/6/2018 14 2/7/2018 15 2/8/2018 16 2/9/2018 17 2/10/2018 18 2/11/2018 19 2/12/2018 20 2/13/2018 21 2/14/2018 22 2/15/2018 B Employee E D Employee Rol Employee First Name Employee Last Nam Last Nam Y 7 Sales Rep Employee Marley Moore 2 Sales Rep Jacob Roger Roger Fred 2 Sales Rep Moore 14 Sales Rep Mertz 3 Sales Rep Sam Smith 3 Sales Rep Sam Smith 3 Sales Rep Sam Smith 3 Sales Rep Sam Smith 3 Sales Rep Sam Smith 2 Sales Rep Roger Moore 2 Sales Rep Roger Moore 5 Sales Rep Harry 5 Sales Rep Harry 5 Sales Rep Harry Knowles Knowles Knowles Knowles Knowles Decker 5 Sales Rep Harry Harry 5 Sales Rep 8 Sales Rep Matt 14 Sales Rep Fred Mertz 14 Sales Rep Fred Mertz 14 Sales Rep Fred Mertz 9 Sales Rep Noah Prophet F G H I Employee SS Employee Phone Numbe Employee Email Address Region Name 9435-78-2201 8642-35-9012 West West 8642-35-9012 6657-43-2185 7785-43-6213 7785-43-6213 7785-43-6213 7785-43-6213 7785-43-6213 8642-35-9012 8642-35-9012 8854-67-2391 8854-67-2391 8854-67-2391 8854-67-2391 8854-67-2391 9278-45-6691 6657-43-2185 6657-43-2185 6657-43-2185 9874-32-5738 (361) 745-2251 jmarley@widgets.com East (216) 728-5581|rmoore@widgets.com West (216) 728-5581 rmoore@widgets.com West (970) 385-3351 fmertz@widgets.com Central (213) 564-7784 ssmith@widgets.com West (213) 564-7784 ssmith@widgets.com West (213) 564-7784 ssmith@widgets.com West (213) 564-7784 ssmith@widgets.com (213) 564-7784 ssmith@widgets.com (216) 728-5581 rmoore@widgets.com West (216) 728-5581 rmoore@widgets.com West (803) 775-4389 hknowles@widgets.com West (803) 775-4389 hknowles@widgets.com West (803) 775-4389 hknowles@widgets.com West (803) 775-4389 hknowles@widgets.com West (803) 775-4389 hknowles@widgets.com West (365) 334-8952 mdecker@widgets.com East (970) 385-3351 fmertz@widgets.com (970) 385-3351 fmertz@widgets.com (970) 385-3351 fmertz@widgets.com (404) 385-6791 nprophet@widgets.com East Central Central Central J Customer ID 1 6 6 11 8 8 8 8 8 5 CONNANimaga 5 7 7 7 7 7 3 10 10 10 4 L 1 Customer Last Name 2 Gates 3 Pippen 4 Pippen 5 Bongiovi 6 Rushdie 7 Rushdie 8 Rushdie 9 Rushdie 10 Rushdie 11 Dillinger 12 Dillinger 13 Donohue 14 Donohue 15 Donohue 16 Donohue 17 Donohue 18 Lopez 19 Koch 20 Koch 21 Koch 22 Smith M Customer Street Address 120 Vine Street 67 Victory Street 67 Victory Street 22 Seaside Avenue 5 Wacker Drive 5 Wacker Drive 5 Wacker Drive 5 Wacker Drive 5 Wacker Drive 144 Raven Lane 144 Raven Lane 20 Miracle Mile 20 Miracle Mile 20 Miracle Mile 20 Miracle Mile 20 Miracle Mile 13 Main Street 5577 Bedford Ave 5577 Bedford Ave 5577 Bedford Ave 13 Avant Garde Row N Customer City Cupertino Northbrook Northbrook Asbury Park Chicago Chicago Chicago Chicago Chicago Oak Park Oak Park Chicago Chicago Chicago Chicago Chicago Bel Air Brooklyn Brooklyn Brooklyn Portland Customer State CA IL IL NJ IL IL IL 8 33 3 8 = = = = = = = = = CA NY NY NY OR P Customer Postal Code Q Customer Phone Number 95014 60062 60062 22918 60290 60290 60290 60290 60290 60301 60301 60290 60290 60290 60290 60290 90049 11228 11228 11228 97201 R Customer EMail (805) 467-2259 bgates@innovate.com (331) 445-3276 spippen@nike.com (331) 445-3276 spippen@nike.com (201) 391-8432|jbongiovi@bonjovi.com (217) 567-2345 srushdie@laureate.com (217) 567-2345 srushdie@laureate.com (217) 567-2345 srushdie@laureate.com (217) 567-2345 srushdie@laureate.com (217) 567-2345 srushdie@laureate.com (224) 567-8834|jdillinger@badboyz.com (224) 567-8834 jdillinger@badboyz.com (312) 546-3281 pdonahue@omagazine.com (312) 546-3281|pdonahue@omagazine.com (312) 546-3281|pdonahue@omagazine.com (312) 546-3281 pdonahue@omagazine.com (312) 546-3281|pdonahue@omagazine.com (805) 723-4578 jlopez@jloproduction.com (718) 544-2737 ekoch@politik.com (718) 544-2737 ekoch@politik.com (718) 544-2737 ekoch@politik.com (951) 234-7754 jsmith@portlandia.com S 1 Customer Notes 2 Billy prefers meeting via video conference. 3 4 5 6 7 8 9 10 11 Buy John a new baseball bat for Christmas. 12 Buy John a new baseball bat for Christmas. 13 Ask about his favorit book. 14 Ask about his favorit book. 15 Ask about his favorit book. 16 Ask about his favorit book. 17 Ask about his favorit book. 18 19 Call to congratulate him if the Mets make the playoffs. 20 Call to congratulate him if the Mets make the playoffs. 21 Call to congratulate him if the Mets make the playoffs. 22 As Fred to do an impression for you. He loves it! T Product ID U Product Name 5 Ball Park Franks 5 Ball Park Franks 5 Ball Park Franks 1 Axe Body Wash 1 Axe Body Wash 2 Listerine Mouthwash 2 Listerine Mouthwash 3 Magnavox Television Set 10 Kindle Paperwhite E-Reader 10 Kindle Paperwhite E-Reader 4 Manichewitz Wine 3 Magnavox Television Set 4 Manichewitz Wine 6 All-new Echo Dot with Alexa 3 Magnavox Television Set 9 6 Pack Budwieser 7 Jordan Brushed Steel Tree 1 Axe Body Wash 4 Manichewitz Wine 8 Nautica Voyage Eau de Toilette Spray 7 Jordan Brushed Steel Tree V Product Description They plump when you cook 'em! They plump when you cook 'em! They plump when you cook 'em! A great toothpaste for dazzling white teeth. A great toothpaste for dazzling white teeth. Wonderful fresh scent. Wonderful fresh scent. The best TV of yesteryear For geeks who don't want to carry ten books while travelling For geeks who don't want to carry ten books while travelling It'll give you chutzpah! The best TV of yesteryear It'll give you chutzpah! Well atleast Alexa will listen to you guys The best TV of yesteryear For your buds The floor lamp that brigthens up your dull life A great toothpaste for dazzling white teeth. It'll give you chutzpah! When you don't want to smell for that first date The floor lamp that brigthens up your dull life Product Cost W $5.00 $5.00 $5.00 $1.97 $1.97 $3.50 $3.50 $150.00 $119.00 $119.00 $12.00 $150.00 $12.00 $49.50 $150.00 $10.00 $99.99 $1.97 $12.00 $17.89 $99.99

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Q:

Topics covered TABLES, SUBTOTALS, PIVOT TABLES Tables (10 points) Examine the Assignment details worksheet and enter your full name. Copy the customer relations data onto the next worksheet and name...

Q:

The resulting bar chart shows that when HMK is the AR Clerk and FKL is the Cash Receipts Clerk, CT is the GL Accounting Clerk for $226,851 of current AR balances. However, there are $25,352 of...

Q:

The resulting bar chart shows that when HMK is the AR Clerk and FKL is the Cash Receipts Clerk, CT is the GL Accounting Clerk for $226,851 of current AR balances. However, there are $25,352 of...

Q:

The resulting bar chart shows that when HMK is the AR Clerk and FKL is the Cash Receipts Clerk, CT is the GL Accounting Clerk for $226,851 of current AR balances. However, there are $25,352 of...

Q:

Requirement 1 : The following articles will introduce you to the intersection of big data and the accounting profession. Even if you are working in groups, I expect EVERY STUDENT to read ALL of these...

Q:

QSO 320 Milestone One Guidelines and Rubric Overview Finding out about organizational inefficiencies is the first step to improving performance. To determine what inefficiencies exist, you need to...

Q:

QSO 320 Milestone One Guidelines and Rubric Overview Finding out about organizational inefficiencies is the first step to improving performance. To determine what inefficiencies exist, you need to...

Q:

Open the salesdata.xlsx file ( Copy thir into a browser and it will come up ) Select cell A 1 , and insert a pivot table. ( Insert , Pivot Table, and press OK ) In the pivot table fields task pane on...

Q:

Open the salesdata.xlsx file Select cell A 1 , and insert a pivot table. ( Insert , Pivot Table, and press OK ) In the pivot table fields task pane on the right, check the boxes for Region and Total...

Q:

BATCH 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67...

Q:

The Miller Company reported gross sales of $850,000, sales returns and allowances of $15.000 and sales discounts of $5,000. The company has average total assets of $500,000, of which $250000 is...

Q:

Suppose four Demogorgans are considered a random sample. The maximum order statistic for that random sample is actually (due to distance being negative) the Demogorgan closest to Eleven. The harsh...

Q:

Consider Merck s common shares. i . How many common shares is Merck authorized to issue?

Q:

02 Calculate the magnetic flux density for the current distribution in free space to be A = (3x y + yz ) d, +(xy - x23 )ay -(7xyz - 3x2 y2 ) a, Wb/m. (a) dy (-7xz + 6.x2 y + 3x=? ) + az (-3x2 -= )...