Please answer the questions on the excel spreadsheet. Data is in link below.? https://elearn.mtsu.edu/d2l/le/dropbox/8816297/8048484/DownloadAttachment?fid=255080115 ?

Please answer the questions on the excel spreadsheet. Data is in link below. 

https://elearn.mtsu.edu/d2l/le/dropbox/8816297/8048484/DownloadAttachment?fid=255080115

 PivotTable Manipulation & Slicers 1 – YouTube 

 PivotTable Manipulation & Slicer 2 – YouTube 

 PivotTable Manipulation & Slicers 3 – YouTube 

[email protected]

Pivot Table design

Get Raw Data from Sales Analysis Data.txt
Insert a column for Extended Price ; Pivot Table, Analyze-Slicer
Which country did the most $ in sales?
Which country did the least $ in sales?
Which country did the most $ in sales for Vintage Cars?
How many planes did Italy order?
Who ordered the fewest ships (not including 0)?
How many orders did Handji Gifts place for vintage cars?
What was the average number of units ordered from Sweden on Motorcycles?
Which Product Line did France order the largest quantity of?
Which Product Line did Singapore place the largest single order for?
Vintage cars are what % of Japans total $ orders?
UK represents what % of the total Plane $ orders ?

pivto table

SalesPerson ORDERNUMBER QUANTITYORDERED PRICEEACH ORDERLINENUMBER ORDERDATE STATUS QTR_ID MONTH_ID Year PRODUCTLINE PRODUCTCODE CUSTOMERNAME PHONE ADDRESSLINE1 ADDRESSLINE2 CITY STATE POSTALCODE COUNTRY TERRITORY CONTACTLASTNAME CONTACTFIRSTNAME DEALSIZE
10168 36 96.66 1 10/28/03 0:00 Shipped 4 10 2013 Motorcycles S10_1678 Technics Stores Inc. 6505556809 9408 Furth Circle Burlingame CA 94217 USA NA Hirano Juri Medium
10188 48 100 1 11/18/03 0:00 Shipped 4 11 2013 Motorcycles S10_1678 Herkku Gifts +47 2267 3215 Drammen 121, PR 744 Sentrum Bergen N 5804 Norway EMEA Oeztan Veysel Medium
10223 37 100 1 2/20/04 0:00 Shipped 1 2 2014 Motorcycles S10_1678 Australian Collectors, Co. 03 9520 4555 636 St Kilda Road Level 3 Melbourne Victoria 3004 Australia APAC Ferguson Peter Medium
10275 45 92.83 1 7/23/04 0:00 Shipped 3 7 2014 Motorcycles S10_1678 La Rochelle Gifts 40.67.8555 67, rue des Cinquante Otages Nantes 44000 France EMEA Labrune Janine Medium
10318 46 94.74 1 11/2/04 0:00 Shipped 4 11 2014 Motorcycles S10_1678 Diecast Classics Inc. 2155551555 7586 Pompton St. Allentown PA 70267 USA NA Yu Kyung Medium
10329 42 100 1 11/15/04 0:00 Shipped 4 11 2014 Motorcycles S10_1678 Land of Toys Inc. 2125557818 897 Long Airport Avenue NYC NY 10022 USA NA Yu Kwai Medium
10112 29 100 1 3/24/03 0:00 Shipped 1 3 2013 Classic Cars S10_1949 Volvo Model Replicas, Co 0921-12 3555 Berguvsv„gen 8 Lule S-958 22 Sweden EMEA Berglund Christina Large
10163 21 100 1 10/20/03 0:00 Shipped 4 10 2013 Classic Cars S10_1949 Classic Legends Inc. 2125558493 5905 Pompton St. Suite 750 NYC NY 10022 USA NA Hernandez Maria Medium
10322 40 100 1 11/4/04 0:00 Shipped 4 11 2014 Classic Cars S10_1949 Online Diecast Creations Co. 6035558647 2304 Long Airport Avenue Nashua NH 62005 USA NA Young Valarie Medium
10347 30 100 1 11/29/04 0:00 Shipped 4 11 2014 Classic Cars S10_1949 Australian Collectors, Co. 03 9520 4555 636 St Kilda Road Level 3 Melbourne Victoria 3004 Australia APAC Ferguson Peter Medium
10236 22 100 1 4/3/04 0:00 Shipped 2 4 2014 Motorcycles S10_2016 Motor Mint Distributors Inc. 2155559857 11328 Douglas Av. Philadelphia PA 71270 USA NA Hernandez Rosa Small
10298 39 96.34 1 9/27/04 0:00 Shipped 3 9 2014 Motorcycles S10_2016 Atelier graphique 40.32.2555 54, rue Royale Nantes 44000 France EMEA Schmitt Carine Medium
10402 45 100 1 4/7/05 0:00 Shipped 2 4 2015 Motorcycles S10_2016 Auto Canal Petit (1) 47.55.6555 25, rue Lauriston Paris 75016 France EMEA Perrier Dominique Medium
10210 34 100 1 1/12/04 0:00 Shipped 1 1 2014 Motorcycles S10_4698 Osaka Souveniers Co. +81 06 6342 5555 Dojima Avanza 4F, 1-6-20 Dojima, Kita-ku Osaka Osaka 530-0003 Japan Japan Kentary Mory Medium
10308 20 100 1 10/15/04 0:00 Shipped 4 10 2014 Motorcycles S10_4698 Mini Classics 9145554562 3758 North Pendale Street White Plains NY 24067 USA NA Frick Steve Medium
10374 22 100 1 2/2/05 0:00 Shipped 1 2 2015 Motorcycles S10_4698 Australian Gift Network, Co 61-7-3844-6555 31 Duncan St. West End South Brisbane Queensland 4101 Australia APAC Calaghan Tony Medium
10261 27 100 1 6/17/04 0:00 Shipped 2 6 2014 Classic Cars S10_4757 Quebec Home Shopping Network (514) 555-8054 43 rue St. Laurent Montreal Quebec H1J 1C3 Canada NA Fresnisre Jean Medium
10295 24 100 1 9/10/04 0:00 Shipped 3 9 2014 Classic Cars S10_4757 Gifts4AllAges.com 6175559555 8616 Spinnaker Dr. Boston MA 51003 USA NA Yoshido Juri Medium
10150 20 100 1 9/19/03 0:00 Shipped 3 9 2013 Classic Cars S10_4962 Dragon Souveniers, Ltd. +65 221 7555 Bronz Sok., Bronz Apt. 3/6 Tesvikiye Singapore 79903 Singapore Japan Natividad Eric Medium
10183 28 100 1 11/13/03 0:00 Shipped 4 11 2013 Classic Cars S10_4962 Classic Gift Ideas, Inc 2155554695 782 First Street Philadelphia PA 71270 USA NA Cervantes Francisca Medium
10395 33 69.12 1 3/17/05 0:00 Shipped 1 3 2015 Classic Cars S12_1108 Lyon Souveniers +33 1 46 62 7555 27 rue du Colonel Pierre Avia Paris 75508 France EMEA Da Cunha Daniel Small
10174 43 100 1 11/6/03 0:00 Shipped 4 11 2013 Trucks and Buses S12_1666 Australian Gift Network, Co 61-7-3844-6555 31 Duncan St. West End South Brisbane Queensland 4101 Australia APAC Calaghan Tony Medium
10216 43 100 1 2/2/04 0:00 Shipped 1 2 2014 Trucks and Buses S12_1666 Auto Assoc. & Cie. 30.59.8555 67, avenue de l'Europe Versailles 78000 France EMEA Tonini Daniel Medium
10381 20 100 1 2/17/05 0:00 Shipped 1 2 2015 Trucks and Buses S12_1666 Corporate Gift Ideas Co. 6505551386 7734 Strong St. San Francisco CA USA NA Brown Julie Small
10107 21 100 1 2/24/03 0:00 Shipped 1 2 2013 Motorcycles S12_2823 Land of Toys Inc. 2125557818 897 Long Airport Avenue NYC NY 10022 USA NA Yu Kwai Medium
10134 20 100 1 7/1/03 0:00 Shipped 3 7 2013 Motorcycles S12_2823 Lyon Souveniers +33 1 46 62 7555 27 rue du Colonel Pierre Avia Paris 75508 France EMEA Da Cunha Daniel Small
10189 28 100 1 11/18/03 0:00 Shipped 4 11 2013 Motorcycles S12_2823 Toys4GrownUps.com 6265557265 78934 Hillside Dr. Pasadena CA 90003 USA NA Young Julie Medium
10201 25 100 1 12/1/03 0:00 Shipped 4 12 2013 Motorcycles S12_2823 Mini Wheels Co. 6505555787 5557 North Pendale Street San Francisco CA USA NA Murphy Julie Medium
10251 46 100 1 5/18/04 0:00 Shipped 2 5 2014 Motorcycles S12_2823 Tekni Collectables Inc. 2015559350 7476 Moss Rd. Newark NJ 94019 USA NA Brown William Large
10263 48 100 1 6/28/04 0:00 Shipped 2 6 2014 Motorcycles S12_2823 Gift Depot Inc. 2035552570 25593 South Bay Ln. Bridgewater CT 97562 USA NA King Julie Medium
10362 22 100 1 1/5/05 0:00 Shipped 1 1 2015 Motorcycles S12_2823 Technics Stores Inc. 6505556809 9408 Furth Circle Burlingame CA 94217 USA NA Hirano Juri Medium
10417 21 100 1 5/13/05 0:00 Disputed 2 5 2015 Motorcycles S12_2823 Euro Shopping Channel (91) 555 94 44 C/ Moralzarzal, 86 Madrid 28034 Spain EMEA Freyre Diego Medium
10104 34 100 1 1/31/03 0:00 Shipped 1 1 2013 Classic Cars S12_3148 Euro Shopping Channel (91) 555 94 44 C/ Moralzarzal, 86 Madrid 28034 Spain EMEA Freyre Diego Medium
10230 43 100 1 3/15/04 0:00 Shipped 1 3 2014 Classic Cars S12_3148 Blauer See Auto, Co. +49 69 66 90 2555 Lyonerstr. 34 Frankfurt 60528 Germany EMEA Keitel Roland Large
10324 27 54.33 1 11/5/04 0:00 Shipped 4 11 2014 Classic Cars S12_3148 Vitachrome Inc. 2125551500 2678 Kingston Rd. Suite 101 NYC NY 10022 USA NA Frick Michael Small
10191 40 100 1 11/20/03 0:00 Shipped 4 11 2013 Classic Cars S12_3380 Toms Spezialitten, Ltd 0221-5554327 Mehrheimerstr. 369 Koln 50739 Germany EMEA Pfalzheim Henriette Medium
10238 29 100 1 4/9/04 0:00 Shipped 2 4 2014 Classic Cars S12_3380 Danish Wholesale Imports 31 12 3555 Vinb'ltet 34 Kobenhavn 1734 Denmark EMEA Petersen Jytte Medium
10276 47 100 1 8/2/04 0:00 Shipped 3 8 2014 Classic Cars S12_3380 Online Mini Collectables 6175557555 7635 Spinnaker Dr. Brickhaven MA 58339 USA NA Barajas Miguel Medium
10320 35 100 1 11/3/04 0:00 Shipped 4 11 2014 Classic Cars S12_3380 Volvo Model Replicas, Co 0921-12 3555 Berguvsv„gen 8 Lule S-958 22 Sweden EMEA Berglund Christina Medium
10341 44 95.93 1 11/24/04 0:00 Shipped 4 11 2014 Classic Cars S12_3380 Salzburg Collectables 6562-9555 Geislweg 14 Salzburg 5020 Austria EMEA Pipps Georg Medium
10376 35 100 1 2/8/05 0:00 Shipped 1 2 2015 Classic Cars S12_3380 Boards & Toys Co. 3105552373 4097 Douglas Av. Glendale CA 92561 USA NA Young Leslie Medium
10127 42 100 1 6/3/03 0:00 Shipped 2 6 2013 Classic Cars S12_3891 Muscle Machine Inc 2125557413 4092 Furth Circle Suite 400 NYC NY 10022 USA NA Young Jeff Large
10176 50 100 1 11/6/03 0:00 Shipped 4 11 2013 Classic Cars S12_3891 L'ordine Souveniers 0522-556555 Strada Provinciale 124 Reggio Emilia 42100 Italy EMEA Moroni Maurizio Large
10220 27 100 1 2/12/04 0:00 Shipped 1 2 2014 Classic Cars S12_3891 Clover Collections, Co. +353 1862 1555 25 Maiden Lane Floor No. 4 Dublin 2 Ireland EMEA Cassidy Dean Medium
10231 49 100 1 3/19/04 0:00 Shipped 1 3 2014 Classic Cars S12_3891 CAF Imports +34 913 728 555 Merchants House, 27-30 Merchant's Quay Madrid 28023 Spain EMEA Fernandez Jesus Medium
10247 27 100 1 5/5/04 0:00 Shipped 2 5 2014 Classic Cars S12_3891 Suominen Souveniers +358 9 8045 555 Software Engineering Center, SEC Oy Espoo FIN-02271 Finland EMEA Suominen Kalle Medium
10272 39 100 1 7/20/04 0:00 Shipped 3 7 2014 Classic Cars S12_3891 Diecast Classics Inc. 2155551555 7586 Pompton St. Allentown PA 70267 USA NA Yu Kyung Large
10325 24 100 1 11/5/04 0:00 Shipped 4 11 2014 Classic Cars S12_3891 Baane Mini Imports 07-98 9555 Erling Skakkes gate 78 Stavern 4110 Norway EMEA Bergulfsen Jonas Small
10336 49 63.38 1 11/20/04 0:00 Shipped 4 11 2014 Classic Cars S12_3891 La Corne D'abondance, Co. (1) 42.34.2555 265, boulevard Charonne Paris 75012 France EMEA Bertrand Marie Medium
10372 34 100 1 1/26/05 0:00 Shipped 1 1 2015 Classic Cars S12_3891 Tokyo Collectables, Ltd +81 3 3584 0555 2-2-8 Roppongi Minato-ku Tokyo 106-0032 Japan Japan Shimamura Akiko Medium
10413 22 100 1 5/5/05 0:00 Shipped 2 5 2015 Classic Cars S12_3891 Gift Depot Inc. 2035552570 25593 South Bay Ln. Bridgewater CT 97562 USA NA King Julie Medium
10175 26 100 1 11/6/03 0:00 Shipped 4 11 2013 Trucks and Buses S12_4473 Stylish Desk Decors, Co. (171) 555-0297 35 King George London WX3 6FW UK EMEA Brown Ann Medium
10229 36 100 1 3/11/04 0:00 Shipped 1 3 2014 Trucks and Buses S12_4473 Mini Gifts Distributors Ltd. 4155551450 5677 Strong St. San Rafael CA 97562 USA NA Nelson Valarie Medium
10281 41 100 1 8/19/04 0:00 Shipped 3 8 2014 Trucks and Buses S12_4473 Diecast Classics Inc. 2155551555 7586 Pompton St. Allentown PA 70267 USA NA Yu Kyung Medium
10277 28 100 1 8/4/04 0:00 Shipped 3 8 2014 Classic Cars S12_4675 Dragon Souveniers, Ltd. +65 221 7555 Bronz Sok., Bronz Apt. 3/6 Tesvikiye Singapore 79903 Singapore Japan Natividad Eric Medium
10377 50 100 1 2/9/05 0:00 Shipped 1 2 2015 Classic Cars S12_4675 Toys of Finland, Co. 90-224 8555 Keskuskatu 45 Helsinki 21240 Finland EMEA Karttunen Matti Medium
10228 32 100 1 3/10/04 0:00 Shipped 1 3 2014 Trucks and Buses S18_1097 Cambridge Collectables Co. 6175555555 4658 Baden Av. Cambridge MA 51247 USA NA Tseng Kyung Medium
10280 24 100 1 8/17/04 0:00 Shipped 3 8 2014 Trucks and Buses S18_1097 Amica Models & Co. 011-4988555 Via Monte Bianco 34 Torino 10100 Italy EMEA Accorti Paolo Small
10357 39 98 1 12/10/04 0:00 Shipped 4 12 2014 Trucks and Buses S18_1097 Mini Gifts Distributors Ltd. 4155551450 5677 Strong St. San Rafael CA 97562 USA NA Nelson Valarie Medium
10370 27 100 1 1/20/05 0:00 Shipped 1 1 2015 Trucks and Buses S18_1097 Anna's Decorations, Ltd 02 9936 8555 201 Miller Street Level 15 North Sydney NSW 2060 Australia APAC O'Hara Anna Medium
10225 32 100 1 2/22/04 0:00 Shipped 1 2 2014 Classic Cars S18_1129 Vida Sport, Ltd 0897-034555 Grenzacherweg 237 Gensve 1203 Switzerland EMEA Holz Michael Medium
10365 30 87.06 1 1/7/05 0:00 Shipped 1 1 2015 Classic Cars S18_1129 Mini Creations Ltd. 5085559555 4575 Hillside Dr. New Bedford MA 50553 USA NA Tam Wing C Small
10125 32 100 1 5/21/03 0:00 Shipped 2 5 2013 Vintage Cars S18_1342 Australian Collectors, Co. 03 9520 4555 636 St Kilda Road Level 3 Melbourne Victoria 3004 Australia APAC Ferguson Peter Medium
10102 41 50.14 1 1/10/03 0:00 Shipped 1 1 2013 Vintage Cars S18_1367 Vitachrome Inc. 2125551500 2678 Kingston Rd. Suite 101 NYC NY 10022 USA NA Frick Michael Small
10162 45 51.21 1 10/18/03 0:00 Shipped 4 10 2013 Vintage Cars S18_1367 Corporate Gift Ideas Co. 6505551386 7734 Strong St. San Francisco CA USA NA Brown Julie Small
10205 48 63.61 1 12/3/03 0:00 Shipped 4 12 2013 Vintage Cars S18_1367 Euro Shopping Channel (91) 555 94 44 C/ Moralzarzal, 86 Madrid 28034 Spain EMEA Freyre Diego Medium
10256 29 51.75 1 6/8/04 0:00 Shipped 2 6 2014 Vintage Cars S18_1367 Danish Wholesale Imports 31 12 3555 Vinb'ltet 34 Kobenhavn 1734 Denmark EMEA Petersen Jytte Small
10289 24 56.07 1 9/3/04 0:00 Shipped 3 9 2014 Vintage Cars S18_1367 Herkku Gifts +47 2267 3215 Drammen 121, PR 744 Sentrum Bergen N 5804 Norway EMEA Oeztan Veysel Small
10422 25 51.75 1 5/30/05 0:00 In Process 2 5 2015 Vintage Cars S18_1367 Diecast Classics Inc. 2155551555 7586 Pompton St. Allentown PA 70267 USA NA Yu Kyung Small
10253 24 100 1 6/1/04 0:00 Cancelled 2 6 2014 Classic Cars S18_1589 UK Collectables, Ltd. (171) 555-2282 Berkeley Gardens 12 Brewery Liverpool WX1 6LT UK EMEA Devon Elizabeth Medium
10367 49 56.3 1 1/12/05 0:00 Resolved 1 1 2015 Classic Cars S18_1589 Toys4GrownUps.com 6265557265 78934 Hillside Dr. Pasadena CA 90003 USA NA Young Julie Small
10419 37 100 1 5/17/05 0:00 Shipped 2 5 2015 Classic Cars S18_1589 Salzburg Collectables 6562-9555 Geislweg 14 Salzburg 5020 Austria EMEA Pipps Georg Medium
10167 43 100 1 10/23/03 0:00 Cancelled 4 10

Collepals.com Plagiarism Free Papers

Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.

Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS

Why Hire Collepals.com writers to do your paper?

Quality- We are experienced and have access to ample research materials.

We write plagiarism Free Content

Confidential- We never share or sell your personal information to third parties.

Support-Chat with us today! We are always waiting to answer all your questions.

Related Posts

All Rights Reserved Terms and Conditions
College pals.com Privacy Policy 2010-2018