How do I make this excel file from this information? theres more to the data part but its too much to upload. An example of the formulas and how to do it pleaseeee
D E 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 cen 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 04 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 E Australia NSW Produce 38.13 G'day, Mate 7 USA New England Seafood Cannery MA Seafood 8.62 Manjimup Dried Apples Jack's New England Clam Chowder Louisiana Flery Hot Pepper Sauce Louisiana Fiory Hot Pepper Sauce Gustaf's Knckebrd USA New Orleans Cajun Delights LA Condiments 17 69 USA LA New Orleans Cajun Delights Condiments 17.69 10 PB Knckebrd AB Sweden Grains/Cereals 20.19 Pasta Buttini s.r.l. Italy Grains/Cereals Ravioll Angelo 15.35 12 France Gai paturago Dairy Products Camembert Pierrot 30.36 13 Norway Dairy Products Geitost 1.91 14 Norske Malerier 15 Specialty Biscuits Ltd UK Confections Sir Rodney's Marmalade 85.85 France Aux joyaux ecclastiques Beverages Chartreuse verte 14 52 16 Formaggi Fortinis.lt Italy Dairy Products 9.12 Gorgonzola Tolino 17 Confections Maxilaku 18.52 Qubec 18.48 3.28 Mat/Poultry Beverages Produce Beverages Pat chino Gunna Fantastica Longlife Tolu Chang 15.83 Dairy Products Raclette Courdavau 40.15 Victona Confections Pavlova 13.22 Kaski Oy Finland 18 19 Ma Maison Canada 20 Refrescos Americanas LTDA Brazi 21 Tokyo Trader Japan Erotic Cluids UK 22 23 Galpturage France Pavlova, Lid 24 Australia Svensk foda AD 25 tiden 26 Oday, Main Plusspar Lebensmittelgrote Ac Germany 27 28 Aux yeux ecclesiastiques France 29 He waren GmbH & Co. KG Cemany 30 Plusspar Lebensmittelgrote Aermany Seafood Inlagd 16.52 INOW MauPoultry 24.48 Condimente Paith Pasties Onginal Frankfurter arine Sole Chartreuse verte 10.92 Beverages 14.52 Confections 32.28 School Schokolade Orginal Frankfurter grne Son Condiments 10.02 nation Data fx SUPPLIERS.COMPANYNAME F G H J K 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 20.19 104 0 16.8 6 $100.80 14-Jan-14 21-Jan-14 15.35 36 0 15.6 15 $234.00 14-Jan-14 21-Jan-14 30.36 19 0 272 40 $1,088.00 15 Jan-14 17-Jan-14 1.91 112 2 25 $50.00 15-Jan-14 17-Jan-14 65.85 40 0 84.8 40 $2,592.00 15-Jan-14 17-Jan-14 14.52 59 o 14.4 42 $604.80 16 Jan.14 22-Jan-14 9.12 o 70 10 20 $200.00 15-Jan-14 22-Jan-14 18.52 10 60 16 40 $640.00 16 Jan-14 22 Jan 14 5 18.45 3.28 8.2 115 20 4 0 0 20 19.2 3.6 2 21 15 21 $403.20 $54.00 $168.00 17-Jan-14 17Jan-14 17 Jan.14 18 Jan.14 29-Jan-14 29-Jan-14 29 Jan.14 15.63 & INN 40 152 20 5304.00 21-Jan-14 40.15 79 14 30 $1,320.00 18 Jan-14 21.14 148 13 22 20 0 13.9 35 5486.50 18 Jan.14 21-Jan-14 148 16.52 512 0 15.2 25 $380.00 15-Jan-14 21 Jan.14 1483 2440 0 262 15 $393.00 21 Jan 14 23-Jan-14 + 13.9 10.92 32 10.4 12 $124.80 21-Jan.14 23-Jan-14 14.52 50 0 144 38640 22-Jan.14 ade 25-Jan-14 3220 0 351 ter S877 50 28-Jan-14 31 91 1092 32 104 15 $150.00 28-Jan-14 31 91 tructions Data a 5 U w 0583 Rodo Braxt Hanari Cames Bral Rodense United Package Peacock Margaret 653 Rio de Janeiro Brazil Harati Comes Braz Rio de Janeiro United Package Peacock Margaret 6583 Rio de Janera Brad Haranam de Janeiro United Package Peacock Margaret Sales Representat Sa Representative Sales Reprise Sales Representative Sana Rarantate 41.34 Lyon To victuales en stock France Lyon Speedy Express Levering Janet 41.30 Lyon Vidualius and France Lyon Speedy Express Levering Jan 141.34/Lyon France Victes on France Lyon Speedy Express Levering Janet 33 Crateri Den hvor de Carro United Package Peacock Magant 51 310 Belum Chanel United Package Peacock Margaret Belgium algum Bupremes delices tres dels Representative 5 Representative Said Renate Sais Fepasante Sa Representative Sales Chanel Begum Charleroi Unted Pacje Peach Mugarut 58.17 Po de Janeiro Hanat Games Brad Rode Levering Janet -4 6:10 Senarai Hantamos de Lavens net od Package United Package 14 Janet 14 16 141 14 1 c. Juner 228 wind 22.30 m son 1453 Oste Han Games Chop Buy One Chopy One Chery Ch Bune Rode Janeiro Dam Bem Ram Owind Bwand Brand Strand United Pada Levering whanan Buch Buchanan Representa Sales Manager Sam Manager Be Manager Sa France Con Anne Did Anne Pederlag Pershor 148 3 Ove But Down Anna Swand wand Perum trup tore SN 1483 Son Duh Anna 13 sendo . Resende und Page ana ve Brari Red Le and Saw Weing importado HLARION A AT 1 San Van Van tawal PO Jan ARONA Vene How 1 San C Vene San Cr Venus 10 HARONA Dar Pen
