how can i make this excel file? there more to the data but its too much to post plzzz help
D 1 2 Put your answers in the tables below. Format sales as currency. 3 4 5 A Which two countries (based on the country where the customer is headquartered (Customers table] 6 and the date the order was placed) had the highest sales in 2014 and which two had the highest sales in 2015? 7 Show the total sales (for each country by year) in dollar and cents format. 8 9 A. Highest Selling Countries by Year 10 Year Highest Sales Second Highest Sales 11 2014 12 2015 13 14 As you answer question B, use a report filter to drill down. 15 B. Based on the top two countries for 2014, which two cities (again based on the country 16 where the customer is headquartered (Customers table) and the date the order was placed) were responsible 17 for the most sales in each of those two countries for Q3 2014 and 04 2014? Provide sales amounts in dollars and cent 18 19 B. Highest City Sales in Top Countries 20 Q3 2014 21 Country Top city Sales amount Second highest city Sales amount 22 23 24 25 Q4 2014 26 Country Top city Sales amount Second highest city Sales amount 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 Instructions Data D Australia NSW Produce G'day, Male 38.13 New England Seafood Cannery USA 8.62 MA Seafood 8 Manjimup Dried Apples Jack's New England Clam Chowder Louisiana Flory Hor Pepper Sauce Louisiana Fiery Hot Pepper Sauce Gustaf's Knckebrd USA New Orleans Cajun Delights LA Condiments 17.69 New Orleans Cajun Delights 10 USA ILA 17.69 Condiments PB Knckebrd AB Sweden Grains/Cereals 20.19 11 Pasta Buttini s.r. Italy Grains/Cereals 15.35 Ravioll Angelo 12 France Golpatuage Dairy Products Camembert Pierrot 30.36 13 Norske Malerier Norway Dairy Products Gelost 1.91 14 UK Specialty Biscuits Ltd Confections Sr Rodney's Marmalade 65.85 15 Aux joyeux ecclesiastiques France Beverages Chartreuse verte 14.52 16 Formaggi Fortinis Italy Dairy Products 17 9.12 Gorgonzola Telino Kand Oy Finland Confections Maxilaku 18.52 Qubec 18.45 3 28 18 19 Ma Maison 20 Refrescos Americanas LTDA 21 Tokyo Traders Exotic Liquids 22 23 Gaipturage Canada Braz Lapan UK Mat/Poultry Beverages Produce Beverages Pate chinois Guarana Fantastica Longlife Tolu Chang 15.83 France Dairy Products Raclette Courdavau 40.15 24 Pavlova, L.id Australia (Vidona Confections Pavlova 13.22 25 Svensk foda AB Sweden Seafood Inlagd 16.52 NOW Moa Poultry Paith Pasties 24.48 Condiments 10.02 G'day, Mate Australia Plusspar Lebensmittelgrote A Gamany 27 28 Aux yeux desiatiques Her waren GmbH & Co. KG 29 Germany 30 Plusspar Lebensmittelgrims AG Demany Orginal Frankfurter online Sole Chartreuse verte Beverages 14.52 Confections 32.28 Schoggi Schokolade Original Frankfurter grne Solo Condimenta 10.92 Instructions Data fx SUPPLIERS.COMPANYNAME F G H M 38.13 20 42.4 35 $1.484.00 14-Jan-14 18-Jan-14 8.62 85 0 7.7 10 $77.00 14-Jan-14 18-Jan-14 17.69 76 0 16.8 15 $252.00 14-Jan-14 18-Jan-14 17.69 76 0 16.8 20 $336.00 14 Jan-14 21-Jan-14 4 20.19 104 0 16.8 6 $100.80 14-Jan-14 21 Jan-14 4 15.35 36 0 15.6 15 $234.00 14 Jan-14 21-Jan-14 41 30.36 19 0 272 40 $1,088.00 15-Jan.14 17-Jan-14 5 1.91 112 0 2 25 $50.00 15-Jan-14 17 Jan.14 51 65.85 40 0 64.B 40 $2.592.00 15-Jan-14 17-Jan-14 51 14.52 60 0 14.4 42 $504,80 16-Jan-14 22 Jan-14 581 1.12 0 70 10 20 $200.00 16-Jan-14 22-Jan-14 58.17 18.52 10 60 10 40 5640.00 18 Jan-14 58.17 16.40 3.28 21 115 20 4 0 g 20 102 30 $403.20 554.00 $160.00 5304.00 17 Jan 14 17Janita 17 Jan.14 22-Jan-14 29 Jan.14 29 Jan.14 29 Jan.14 21 Jan 14 2290 22.98 21 20 17 40 15.2 18-Jan-14 148 3310 wa 40.15 70 0 30 31.320.00 18 Jan.14 21 Jan.14 148.33 13.22 20 0 13.0 36 3486,50 18 Jan.14 21 Jan.14 14833 16.52 112 0 152 25 $380.00 T-Jan-14 21 Jan.14 140.336 0 202 5303.00 21 Jan 14 23-Jan-14 13.07R 1092 10.4 12 5124.30 21 Jan 14 23-Jan-14 13 97 Res 1452 69 144 10.40 22.14 28 Jan.14 1 San hokolade ankfurter 0 25 STO 22-Jan-14 28 Jan 14 81. San 10.02 32 0 10.4 15 $150.00 81.91 San Instruction MPANYNAME Q 0 553 Recanto Bracl Hanan Games Bri Rio de Janeiro United Package Peacock Margaret 653 Rio de Janeiro Oral Hanan Camos Bra Rio de Janeio United Package Peacock Margaret 658 Rio de Janeiro Hara Cames Rio de Janeiro United Package Peacock Margaret Sales Representative Sales Representative Sales Raparative Sales Ronsentative Isaks Recreatie 4134 Lyon France Visuales en Lyon Speedy Ex Lorong Janet 45 34 Lyon France Wichsen Lyon Speedy tap Levering Janar 41.34 L Sus Vidutie en ook Lyon Speedy Express 513 Charles Belgium Chantal Unted Package Pe Magent Supremes dels Sopredeces Belgium Belgium 513 Belour Charmi United Package JPeacon Mag Roosentative Sad Rentative Salsa Rementative Sales Representative Ba Apsve 01 Chanel Supremos dolces Charleroi United Package POR Margaret 4 56.17 RJ and Cams o de Janeiro Utah unted Package Levering Lever 4 58.17 Jenere Cames B Rode anet Roode Levering Janel 14 14 -14 -10 ta 08.17 Recento 2238 Bon Bwin 22.30 www 22.00 on San 1. Os wand names Cheesey Chop By Chinese Chery CSR Hartupem wand wand wand Strand Bem mam Bam United Pack United Package sted Paikape Page bleven Buchanan Duchas Buchanan Door Rarantie Bare Manager S Mariage Made Sale con Are 1481 Swand Centre Feel Dawrth Art . 18 wand Dan Shoping Dodewart Am One Duh 15 de On Ba Live an 14 13:47 word Bales Lewe ant | | | | | | | | | | | HILARION A Ver Basta For the Vanes SO Cal Vans 3131 CH V Pence PELARGONAL MILARA aprese Hop Sad Vanese Ban Peach Marat SUPPLIERS COMPANYNAME A B 1 2 2 4 5 6 7 Tofu 8 9 10 11 12 13 14 SUPPLIERS.COMPANYNAME | SUPPLIERS.COUNTRY SUPPLIERS.REGION CATEGORYNAME PRODUCTNAME UNITCOST Cooperativa de Quesos 'Las Cab Spain Asturias Dairy Products Queso Cabrales 20 Formaggi Fortini s.r.l. Italy Dairy Products Mozzarella di Gioy 29 Leka Trading Singapore Grains/Cereals Singaporean Hokk 10.22 G'day. Mate Australia NSW Produce Manjimup Dried Ad 38.13 Mayumi's Japan Produce 20.76 G'day, Mate Australia NSW Produce Manjimup Dried A! 38.13 New England Seafood Cannery USA MA Seafood Jack's New Englar 8.62 New Orleans Cajun Delights USA LA Condiments Louisiana Fiery Hd 17.69 New Orleans Cajun Delights USA LA Condiments Louisiana Fiery Hd 17.69 PB Knckebrd AB Sweden Grains/Cereals Gustaf's knacker 20.19 Pasta Buttini s.r.l. Italy Grains/Cereals Ravioli Angelo 15.35 Gai pturage France Dairy Products Camembert Pierro 30.36 Norske Meierier Norway Dairy Products Geitost 1.91 Specialty Biscuits, Ltd UK Confections Sir Rodney's Marr 65.85 Aux joyeux ecclsiastiques France Beverages Chartreuse verte 14.52 Formaggi Fortini s.r.l. Italy Dairy Products Gorgonzola Telino 9.12 Karkki Oy Finland Confections Maxilaku 18.52 Ma Maison Canada Qubec Meat Poultry Pt chinois 18.46 Refrescos Americanas LTDA Brazil Beverages Guarana Fantastic 3.28 Tokyo Traders Japan Produce Longlife Tofu 8.2 Exotic Liquids UK Beverages Chang 15.83 Gal pturage France Dairy Products Raclette Courdava 40.15 Pavlova, Ltd Australia Victoria Confections Pavlova 13.22 Svensk Sjfoda AB Sweden Seafood Inlagd Sill 16.52 G'day, Mate Australia NSW Meat Poultry Perth Pasties 24.48 Plusspar Lebensmittelgromrkt Germany Condiments Original Frankfurt 10.92 Aux joyeux ecclsiastiques France Beverages Chartreuse verte 14.52 16 17 TB 19 20 21 22 23 24 25 26 27 28 Instructions - Data 3 2 A1 SUPPLIERS.COMPANYNAME N K 1 2 3 4 5 6 7 10 11 104 12 13 14 H UNITSINSTOCK UNITSONORDER ORDERDETAILS.UNITPRICE QUANTITY 22 30 14 12 14 0 34.8 5 26 0 9.8 10 20 0 424 40 35 0 18.6 9 20 0 424 35 85 0 7.7 10 76 0 16.8 15 78 0 16.8 20 0 16.8 6 36 0 15.6 15 19 0 27.2 40 112 0 2 25 40 0 64.8 40 69 0 14.4 42 0 70 10 20 10 60 16 40 115 0 19.2 21 20 0 3.6 15 4 20 8 21 17 40 15.2 20 79 0 44 30 29 0 13.9 35 112 0 15,2 25 0 0 26.2 15 32 0 10.4 12 89 0 14.4 6 M ORDERDATE SHIPPEDDATE 10-Jan-14 22-Jan-14 10-Jan-14 22-Jan-14 10-Jan-14 22-Jan-14 11-Jan-14 16-Jan-14 11-Jan-14 16-Jan-14 14-Jan-14 18-Jan-14 14-Jan-14 18-Jan-14 14-Jan-14 18-Jan-14 14-Jan-14 21-Jan-14 14-Jan-14 21-Jan-14 14-Jan-14 21-Jan-14 15-Jan-14 17-Jan-14 15-Jan-14 17-Jan-14 15-Jan-14 17-Jan-14 16-Jan-14 22-Jan-14 16-Jan-14 22-Jan-14 16-Jan-14 22-Jan-14 17-Jan-14 29-Jan-14 17-Jan-14 29-Jan-14 17-Jan-14 29-Jan-14 18-Jan-14 21-Jan-14 18-Jan-14 21-Jan-14 18-Jan-14 21-Jan-14 18-Jan-14 21-Jan-14 21-Jan-14 23-Jan-14 21 Jan 14 23-Jan-14 22-Jan-14 28-Jan-14 SALES $168.00 $174.00 $98.00 $1,696.00 $167.40 $1,484.00 $77.00 $252.00 $336,00 $100.80 $234.00 $1,088.00 $50.00 $2,592.00 $604.80 $200.00 $640,00 $403.20 $54.00 $168.00 $304.00 $1,320,00 $486.50 $380.00 $393.00 $124,80 $86.40 FREIGHT 32.38 R 32.38 R 32.38 R 11.61 M 11.61 M 65.83 R 65.83 R 65.83 R 41.341 41,341 41.34 L 51.31 51.31 51.30 58,17 58,17 58.17 22.98 B 22.96 6 22.98 B 148.33 G 148.33 148.33 G 148.33 13.97 13.97 R 81.91 S 15 16 17 19 20 22 23 24 25 26 27 38 Instructions Data S A1 SUPPLIERS.COMPANYNAME 0 P R Q 1 SHIPCITY SHIPCOUNTRYCUSTOMERS.COMPANYNAME CUSTOMERS.COUNTRY 2 Reims France Vins et alcools Chevalier France 3 Reims France Vins et alcools Chevalier France 4 Reims France Vins et alcools Chevalier France 5 Mnster Germany Toms Spezialitten Germany 6 Mnster Germany Toms Spezialitten Germany 7 Rio de Janeiro Brazil Hanari Carnes Brazil 8 Rio de Janeiro Brazil Hanari Carnes Brazil 9 Rio de Janeiro Brazil Hanari Carnes Brazil 10 Lyon France Victuailles en stock France 11 Lyon France Victuailles en stock France 12 Lyon France Victuailles en stock France 13 Charleroi Belgium Suprmes dlices Belgium 74 Charleroi Belgium Suprmes dlices Belgium 15 Charleroi Belgium Suprmes dlices Belgium 16 Rio de Janeiro Brazil Hanari Carnes Brazil 17 Rio de Janeiro Brazil Hanari Carnes Brazil 18 Rio de Janeiro Brazil Hanari Carnes Brazil 19 Bern Switzerland Chop-suey Chinese Switzerland 20 Bern Switzerland Chop-suey Chinese Switzerland 21 Bern Switzerland Chop-suey Chinese Switzerland 22 Genve Switzerland Richter Supermarkt Switzerland 23 Genve Switzerland Richter Supermarkt Switzerland 24 Genve Switzerland Richter Supermarkt Switzerland 25 Genve Switzerland Richter Supermarkt Switzerland 26 Resende Brazil Wellington Importadora Brazil 27 Resende Brazil Wellington Importadora Brazil 28 San Cristbal Venezuela HILARION-Abastos Venezuela CUSTOMERS.CITYS Reims F Reims FE Reims FE Mnster SE Mnster Sp Rio de Janeiro Ur Rio de Janeiro Ur Rio de Janeiro Ur Lyon Sp Lyon SE Lyon Sc Charleroi Un Charleroi Un Charleroi Un Rio de Janeiro Un Rio de Janeiro Un Rio de Janeiro Un Bern Bern Un Bern Un Genve Fec Genve Fec Genve Fec Genve Fec Resende Uni Resende Uni San Cristbal Fed Un + Instructions Data 2
