Please at the end give me a excel folder link please I should take as a excel class folder Pls not as screen shots

I will give you upvote if u will do it thank you

IS100 ASSIGNMENT 2-Data Analysis and MS Excel Q1: 20 points(a-4 b-7e-9 points),Q2: 40 points(8 points each), 03:40 points(a-5 b-10 e-10 d-10 e-5 points) The data file in txt format includes information about goods that are delivered by an international freight'shipping company 41) You are asked to do the following steps Import data provided in.ixt format into the sheet called "DATA b- Sort the data with respect to the content type from Z to A c-Insert a new column to the left hand side of the column "Delivery Type" and name it as "Label ID. By using AutoFill property af 7Excel, fil this column with label IDs from CK01 through CK49 for Handla, from ENO1 through EN42 for Engine, from BU01 through BU44 for Bumper, from B001 through 8070 for Bonnet and from BLO01 through BL45 for Binker material types of content 2) Do the following steps a- In the sheet named as "DATA", split the text including cities-countries in the column Destination-From into two columns with titles From City.."From Country. and repeat the same procedure for the colum-Destination-To" by creating two new colums with ttes; To City" and "To Country by using available options of the Data Rbbon b- Copy all the contents of the sheet "DATA" into the sheet called "Filtered Goods", By using the Fiter option of Excel, display only the 0 goods which are delivered via TRUCKLOAD, from countries that begin with the letter "S" and the destination countries contain the etter "A" c- In the sheet"DATA", create a new column next to the column "Posting Via", with the title as "Ratio" and calculate the folowing 1 formula for each good Rato (Weightwwidh Height'Length) 2 d-Format the "Ratio" column so that only three decimal places are displayed e-Find the goods which have a Ratio value biger than 0,6. Locate these goods into the sheet called "Chart. Calculate the sum of these ratio values. Draw an appropriate chart for these goods with the label IDs. The type of the chart should ilustrate the contribution of each good lo the sum of these ratio values Note: Display percentages and the legend informetion on the chwt, with the chavt htle as Ratio 1 3) Do the following steps 5 a-Copy the content of the sheet "DATA into the sheet called "Mailing Price b-Create a new colum next to the column "Ratio" with the ttie as-Mailing Price. and calculate the price for each good as folowing: Compute the mailing price of each good, by multplying the unit price 10TL for the HANDLE and TTL for the rest of the "content type materials by its quantity c-There a 20% discount in the maing price f a good is sent by TRUCKLOAD. Create a column name it as "Discounted Price" next to the column named as Mailing Price and compute the discounted price for each good. 7 Hint: Use appropriate predefined Excel functions. You can obtain more information about how to use a certain function by clicking on Help on this function" from Tnsert Function feature You can copy and paste avalable examples of the Help to the Excel sheet and try to figure out how t works. Optionaly you can search via Google on how to use a specic function. d- Calculate the mean and minimum value of discounted price, and mean and maximum value of mailing price of all goods by 18 using the appropriate formulas. The results should be located into the undermost cels of "Discounted Price and "Mailing Price" columns, respectively e-Select all the data in the sheet called "Mailing Price", align cel contents to left, format the "Maling Price" and "Discount Price columns so that only two decimal places are shown Important Note: When using predefined functions of Excel or calculating manually, DO NOT provide only the results of the calculation. The functionMormula that you have used should be visible in the formula bar. Values written without functions/tormulas will be graded as zerol 20 Mail Delivery Type Content Type Destination-From Destination-To Quantity Weight (gr) Height (cm) Length {cm} Posting via Width (cm) Priority Blinker Vaduz-Liechtenstein Stockholm- Registered Blinker Registered Blinker Funafuti-Tuvalu Dhaka-Bangladesh 3 Registered Blinker Registered Blinker Guatemala City-Guatemala 1091 133 29 SURFACE London-England ontevideo-Uruguay 8210 126 133 9 SURFACE vilnius-Lithuania Cardiff- 4062 187 4 SURFACE Basseterre-Saint Kitts and Nevis 9 120 AIR 2703 178 3 First-Class Blinker Stanley-Falkland Islands Adamstown-Pitcairn Islands 5 3327 196 138 AIR Express Blinker Putrajaya-Malaysia Dibouti- Djibouti 1 First-Class Blinker 899 165 69 8 Pago Pago-American Samoa Dushanbe-Tajikistan 94261 104 147 128 First-class Blinker victoria-Seychelles Janestown- Saint Helena 4977 186 40 Priority Blinker Douglas-Isle of Man Dodoma 11 133 63 SURFACE Express Blinker Beijing-People's Republic of China Lom ogo 9 4591 81 177 193 AIR Minsk-Belarus Blinker Gibraltar- Expres3 Gibraltar8 Expresa Blinker virgin Islands 7 First-Class Blinker Amman-Jordan 5092 146 61 173 TRUCKLOAD Dhaka-Bangladesh Road Town-British 1704 BO 8 135 SURFACE San Marino-San 1378 186 43 Express Blinker Belfast-United Kingdom Northern Ireland Abu Dhabi-United Arab Emirates 169 101 25 AIR 35 B Priority Blinker Bujumbura-Burundi 95 Bandar Seri Begawan-Brunei st Santiago- 3197 35 104 SURFACE First-Class Blinker Peter Port-Guernsey 5 Express Blinker ntiago-chile Guatemala city- 9438 18 178 124 AIR Guatemala 2 First-class Blinker 2829 187 193 133 AIR The Valley-Anguilla Maputo- 90 SURFACE Priority Blinker Honduras 10 9841 81 Reqular Blinker Tripol1-Libva N D1amena-Chad 4 Kigali-Rwanda Tegucigalpa 161 42 TRUCKLOAD 75 190 SURFACE Priority Blinker aghdad-Iraq New Guinea 9 Priority Blinker Grytviken-Georgia and the South Sandwich Willemstad-Netherlands Antilles 2 Port Moresby-Papua 1463 146 122 153 SURFACE 5911 97 TRUCKLOAD Bamako-MaliWellington-New 2ealand 1 118 AIR Tiraspol-Transnistria Belgrade- First-Class Blinker 5478 78 48 First-Class Blinker Serbia 8989 65 2 Regular Blinker 4684 173 91 16 Blinker T avn-Faroe Islands Paris-France SURFACE Priority Port Moresby-Papua New Guinea Budapest-Hungary 7866 112 128 37 Express Blinker Paris-France New Delhi-India 2 5694 87 194 57 SURFACE First-class Blinker elgrade-serbia Riyadh-saudi Arabia Express Blinker Belmopan-Belize Jerusalem- 7032 13 1574 TRUCKLOAD alesti First-Class Blinker 9297 47 191 111 AIR Palikir-Federated States of Micronesia Libreville-Gabon 2 9440 167 32 124 Blinker Bratislava-slovakia Express Antananarivo-Madagascar 2071 96 144 13 SURFACE Priority Bli nker Georgetown-Guyana 1784 92 72 Priority Blinker Lima-Peru Marigot-saint Martin 5 6008 42 First-Class Blinker Turkey Express Blinker Miquelo Bern-switzerland l Gibraltar-Gibraltar Istanbul- 4330 126 42 1B8 SURFACE St. Pierre-Saint Pierre and 3712 154 131 18 Blinker Asuncilaraguay laanbaatar- Express Mongolia 6 Express Blinker 1031 114 61 142 AIR San Salvador-El Salvador Pretoria-Soyth Africa (official) 1 SUREACE Priority Blinker Basseterre-Saint Ritts and Nevis Harare-Zimbabwe 3 1799 128 98 174 AIR Priority Blinker Abu Dhabi-United Arab Emirates Sarajevo-Boania and Herzegovina 228177 64 151 AIR 10 6124 193 10 66 AIR 5483 82 3398 138 146 71 AIR Priority Blinker stockholm-Sweden BogotoaDolombia Express Blinker Marigot-saint Martin Tokyo-Japan 2 94 SURFACE Havana-CubaNindhoek-Namibia 7 Blinker First-Class Blinker Ethiopia 8 First-class Blinker Addis Ababa-Ethiopia Port-au 8 Canberra-Australia 8742 182 172 45 934 80 Registered Bonnet Mamoudzou-Mayotte Bridgetown-Barbados Brazzaville- South Sandwich Islands-British Over Dublin- 202 138 57 Expres Bonnet Republic of the Congo 5 Registered Bonnet SURFACEs Territory 5158 19 136 17B AIR Hamilton-Bermuda 8 Bucharest-Romania Ankara-Turkey Ashgabat- 435 32 AIR Priority Bonnet Lebanon Registered Bonnet Turkmenistan Beirut- 9202 B0 130 168 TRUCKLOAD 8952 111 10 110 SURFACE Priority Bonnet Dublin-Ireland Oslo-Norwayl 5136 67 12 196 SURFACE Priority Bonnet Amsterdam-Netherlands (official) st. John's-Antigua and Bar 133 181 TRUCKLOAD 3918 87 Bonnet Istanbul-Turkey Kigal1-Rwanda 8 192 127 12 16 AIR First-Clas5Bonnet OversURFACEs Territory-South Sandwich Ilands Jamestown-Saint Helena British 9676 199 142 179 TRUCKLOAD First-Class Bonnet Manama-Bahrain Helsinki-Finland 7 4940 115 119 79 SURFACE Naypyidaw-Myanma:r First-Class Bonnet Philippines 7 First-Clas5Bonnet Manila- Papeete-French Polynesia 1458 168 70 91 SURFACE Banjul-Gambia Porto-Novo 3 117 59 194 114 SURFACE First-Clas5Bonnet Istanbul-Turkey Yamoussoukro-Cote Nouakchott-Mauritania Skopje- Vatican city-Vatican City 631 18 First-Clas5Bonnet Macedonia5 Priority Bonnet 599 75 153 188 AIR Jakarta-Indonesia SUREACE 7822 129 188 121 First-Clas5Bonnet Grenadines Canberra-Australia Kingstown-Saint Vincent and the 5375 145 10 AIR Priority Bonnet First-Clas5Bonnet Priority Bonnet Algiers-Algeria Mata-Utu 2209 136 106 75 TRUCKLOAD 510 109 62 Cairo-Egypt 10 1594 134 86 138 TRUCKLOAD Bishkek-Kyrgyzstan Yaren-Nauru4 107 SURFACE Road Town-British Virin Islands Paramaribo-Suriname Chisinau- Port of Spain-Trinidad and Tobago Alofi-Niue Dakar-Senegal 2 Riyadh-Saudi Arabia Maudzou Windhoek-Namibia South Tara Podgorica-Montenegro Baghdad-Iraq Monrovia-Liberia Khartoum-Sudan 7 Berlin-Gmany Luka-Zambia First-Class Bonnet MoLdova Priority Bonnet 1707 45 6 56 SURFACE Pristina-Kosovo 5 3407 58 52 77 AIR Priority Bonnet 573B 151 46 70 TRUCKLOAD Priority Bonnet Mayotte First-Clas5Bonnet Kiribati 9 First-Class Bonnet 6103 73 92134 SUREACE 2353 196 19 196 AIR 10 9208 2B 140 27 SURFACE 3215 161 98 9609 59 147 184 AIR Priority Bonnet First-Clas5Bonnet First-Class Bonnet verde 1 San Marino-san Marino Praia-Cape 20 Panama City-Pama Luxmbourg 3231 162 124 103 TRUCKLOAD Tbilisi-Georgia Prague-czech 5647 96 Bornne 132 TRUCKLOAD city-Luxembour First-Clas5Bonnet Republic 48347 55 62 143 AIR Priority Bonnet Kyrenia-cyprus Accra-Ghana 3 9052 131 26 102 AIR First-class Bumper Bissau-Guinea Bissau-Guinea8 545B BT 158 123 TRUCKLOAD Castries-Saint Lucia Yaound 3921 72 43 69TRUCKLOAD Priority Bumper Central African Republic 2 Wellington-New 2ealand Bangui- 2586 27 SUREACE First-class Bumper Edinburgh-scotland Lima-Peru 3105 75 166 64 SURFACE Priority Bumper Falkland Islands B Stanley- Seoul-South Korea 1993 109 72 172 SURFACE Rabat-Morocco Vatican city- 196 AIR Vatican City First-class Bumper 10 2910 189 67 Abuja-Nigeria ReykjavDIceland S 172 AIR Willemstad-Netherlands Antilles 9332 196 80 Priority Bumper Minsk-Belarus 6441 101 7 AIR First-class Bumper Morocco First-class Bumper Malabo-Equatorial Guinea abat- 803 23 147 19 TRUCKLOAD Washington D.C.-United States 5745 149 190 170 AIR Kiev-Ukraine First-class Bumper Oranjestad-Aruba 7 3680 112 152 22 TRUCKLOAD First-class Bumper Kenya 6 First-class Bumper Kabul-Afghanistan Mbabane-Swaziland Tegucigalpa-Honduras Amsterdam- Malaldives Zagreb-Croatia George Town-ca Nairobi- 2636 124 105 124 SUREACE Naypyidaw 8952 89 110 80 SURFACE First-class Bumper Netherlands 1 4174 14 148 153 AIR 10 B110 160 154 13 AIR First-class Bumper yman Islands 6085 12 25 24 Tiraspol-Transnistria 4 AIR valletta-Malta Malaldives 10 3767 51 190 87AIR Priority Bumper Burkina Faso Yerevan-Armenia uagadougou- 163 42 97 3 AIR Yaound ameroon Pyongyang-North 176 154 SUREACE Yaren-NauruQuito-Ecuador Expre55 8891 8 140 111 147 11 AIR First-class Bumper Oranjestad-Aruba Copenhagen-Denmark Niamey-Wiger Dili-East Timor (Timor) Istanbul- Asmara-Eritrea Ottawa-Canada 3 Tirana-Albania Hargeisa- Harare-2imbabwe Singapore- Tokyo-JapanMaseru-Lesotho 3 2140 154 146 18 AIR First-class Bumper Barbados 10 8527 134 199 170 AIR Turkey Priority Bumper 9695 81 179 191 SURFACE 5281 79 129 131 SURFACE Somaliland 10 7957 75 153 179 AIR singapore 10 3036 135 56 147 SURFACE First-class Bumper 3733 39 74 39 AIR Priority Bumper Porto-Novo Port Vila-Vanuatu 1441 120 132 119 AIR Express Engine Aires-Argentina 2 South Tarawa-Kiribati Buenos B594 B3 Skopje-Macedonia San Jos osta Kingston-Jamaica Cockburn Town- 10 20 AIR Priority Engine Rica Express Engine 98B6 181 139 56 AIR Turks and Caicos Islands 1 3B74 120 88 Priority Engine Islands Priority Engine Monaco Priority Engine 3963 82 2063 25 4742 103 101 113 SUREACE Nuuk-Greenland Majuro-Marshall Bratialava-Slovakia Monaco- Monaco-Monaco Roseau-Dominica 1 66 194 SURFACE Firt-Cla53 Engine Bern-Switzerland Suva-Fiji 3 Express Engine Tom ao Tome and Principe 10 4459 103 187 159 Express Engine Express 523 181 198 76 TRUCKLOAD LaDune El Aain)-Western Sahara S TRUCKLOAD Jerusalem-Palestine St. Helier- Rome-Italy Islanabad-Pakistan1 Phnom Penh-Cambodia Bujumbura- Luxembourg city-Luxembourg Gustavia-Saint Barthelemy 8607 77 157 120 AIR Eng 6553 160 127 84 SURFACE First-class Engine Burundi Express Engine 5254 196 187 139 AIR Istanbul-Turkey 10 3154 175 125 AIR First-class Engine Algiers-Algeria 1 1890 44 194 AIR First-class Engine Korea 10 1099 101 First-ciass Engine D..-United States First-class Engine Prague-czech Republic Seoul-South 28 Maputo-Mozambique 75 AIR 5324 47139 86 SUREACE Cardiff-Wales Avarua-Cook 907 64 177 13 AIR First-class Engine Congo Amman-Jordan First-class Engine Islands Kinshasa-Democratic Republic of the 10 487 33 19 43SURFACE Lilongve-Malawi George Town-Cayman 49 Luanda-Angola Banjul-Gambia 6 749 138 190 AIR Eng 9762 117 95 144 AIR Regular Engine Kingdom 3693 125 192 115 AIP Priority Engine Nairobi-Kenya Yamoussoukro-Cote d'Ivoire Tashkent-Uzbekistan AIR 4 9474 125 185 125 First-class Engine Apia-Samoa San Juan-Puerto Rico 1 1248 45 153 121 TRUCKLOAD Regular Engine Port-au aduz-Liechtenstein 1 2138 163 92 105 SURFACE First-class Engine Western Sahara First-class Engine Helsinki-Finland LaDune (El Aain)- 4545 135 160 135 TRUCKLOAD Kampala-Uganda Nuuk-Greenland 4 6194 41 17 193 SURFACE Priority Engine Kathmandu-Nepal Tbilisi-Georgia 1 4308 35 200 119 AIR Port Louis-Mauritius Vienna First-classEngine Austria 2 9664 8 31 110 AIR san Jos osta Rica wait city Doha-Qatar Kyrenia-Cyprus 9 RoSUREACEu-Dominica Istanbul- Suva-Fii Freetown-sierra Leone 4 BrasOa-Brazil Gaborone-Botswana Bangkok-Thailand Kingstown-saint First-classEngine Kuwait Regular 6035 158 119 9 AIR Enqine B080 107 112 86 AIR Engine 3011 146 133 66 AIR First-classEngine 7922 98 107 104 AIR Engine 10 862 37 37 102 AIR First-clas5Engine vincent and the Grenadines 10 1127 198 36 175 First-classEngine First-clas5Engine AIR ucre-Bolivia Tripo1i-Libya 9 3386 73 29 165 AIR Santo Domingo-Dominican Republic Lisbon-Portugal 8 TRUCKLOAD 2121 7 151 24 First-class Engine American Samoa 5 First-classEngine Ashgabat-Turkmenistan Pago Pago- 9174 29 34 132 AIR Dakar-senegal Damascu:s 150 AIR 715 114 42 Bangui-Central African Republic Moscow-Russia ity Engine 6949 128 68 AIR PrioritY Freetown-Sierra Leone Asmara Eritrea First-classEngine Priority Engine Priority Engine 10 4619 105 147 173 AIR Lom ogo Malabo-Equatorial Guinea 153 200 174 155 AIR Tomao Tome and Principe 4521 115 97 B4 SURFACE N'Djamena-Chad St. Pierre-Saint 3 Port Vila-Vanuatu 171 160 TRUCKLOAD Moroni-Comoros Flying Fish Cove- Havana-Cuba 5 Pierre and Miquelon 843 120 BO SURFACE Handle 5084 46 Ngerulmud- Priority Handle Christmas Island 10 9247 55 40198 TRUCKLOAD Registered Handle Regiatered Handle Priority Handle Priority Handle Accra-Ghana Di11-East Timor (Timor) Chisinau-Moldova Hag j a-Guam Pristina-Kosovo Itanbul-Turkey 5 Saipan-Northern Mariana Islands 9678 26 135 19 TRUCKLOAD 6482 22 107 8 5615 67 101 170 SURFACE Kinshasa-Democratic Republic of the Congo 1 SURFACE 7801 56 165 25 AIR Regiatered Handle Saint Barthelemy 6 Registered Handle St. Helier-Jersey 6847 28 Copenhagen-Denmark Gustavia- 124 183 TRUCRLOAD 3965 88 73 AIR First-Class Handle Hargeisa-Somaliland Victoria- Seychel1es g 9073 149 132 152 AIR Handle Damascus-Syria Kingston-Jamaica 10 9271 184 153 40 SURFACE First-Class Handle Sri Jayavardenepura [g]-sri Lanka Moroni-Comoros 6 1166 197 B1 12 AIR singapore-Singapore Monrovia- First-Class Handle Liberia First-class Handle Zagreb-Croatia Conakry-Guinea 1398 43 195 AIR 10 4739 57 9 52 SURFACE First-Class Handle Tuvalu Priority Handle Pyongyang-North Korea Funafuti- 741198 45 190 TRUCKLOAD st. John'3-Antigua and Barbuda Edinburgh-Scotland 1 460 169 95106 AIR Madrid-Spain SanaDemen Kabul-Afghanistan Athens- Caracas-Venezuela Thimphu-Bhutan Athens-Greece 9 Vienna-Austria The Valley- Gaborone-Botswana Ankara-Turkey 9 361 48 32 196 938 71 104 1B3 SURFACE Greece Vilnius-Lithuania 4047 2B SURFACE Priority Handle 691 SURFACE Regular 7428 154 155 172 TRUCKLOAD First-Class Handle Anguilla 3 Regular Handle Nicaragua 10 6463 16 194 192 AIF First-Class Handle Caledonia 8 Priority Handle Suriname 6 First-Class Handle 3299 94 162 170 SURFACE Avarua-Cook Islands NoumNe Istanbul-Turkey Paramaribo- Praia-Cape Verde Warsaw-Poland 3 Brazzaville-Republic of the Congo United Kingdom Akrotiri and 9217 172 111 65 AIR AIR B69 B7 60 137 SURFACE First-Class Handle Charlotte Amalie-United States Virgin Islands 8161 B5 9B 175 SURFACE Regular Dhekelia -Episkopi Cantonment First-Class Handle Priority Handle First-Class Handle First-Class Handle Manama-Bahrain 984 69 144 116 SURFACE 6648 103 119 110 AIR 9791 131 150 172 AIR 5580 195 97 28 AIR Dodoma-Tanzania Nukualofa-Tonga 4 Khartoum-Sudan Bangkok-Thailand 2 Ngerulmud-Palau Vientiane-Laos 1 Djibouti-Djibouti 71 Tallinn-Estonia Mbabane-Swaziland Madrid-Spain 2658 13 9058 162 154 40 AIR Priority Handle Libreville-Gabon Valletta-Malta 3 9307 135 190 178 TRUCKLOAD Priority Handle Penh-Cambodia 1 Phnom St. peter Port-Guernsey 1752 126 116 40 SURFACE ottawa-Canada Ljubljana-slovenia 10 3344 177 169 135 AIR First-Class Handle Istanbul-Turkey Kingston-Norfolk St. George's-Grenada South 3977 16 6 166 AIR 1842 32 152 AIR First-Class Handle Georgia and the South Sandwich Islands South Georgia and the-Grytviken 4 First-Class Handle Albania Priority Handle Madagascar First-Class Handle virgin Islands United Kingdom Northern Ireland-Belfast Adamstown-Pitcairn Islands Tirana- Nukualofa-Tonga Antananarivo- Charlotte Amalie-United States 6025 197 63185 TRUCKLOAD 10 9094 13 193 7 AIR 10 9411 162 48 188 AIR Priority Handle Flying Fish Cove-Christmas Island 3108 26 3 Buenos Aires-Argentina Santo Doha-Qatar 5 12 AIR Handle Expres Domingo-Dominican Republic 1 554 162 156 84 AIR Cairo-Egypt Saipan-Northern Mariana Nassau-Bahamas Mexico city-Mexico Hanoi-Vietnam Itabul-Turkey 7 Ulaanbaatar-Mongolia Podgorica- First-Class Handle Ialands Priority Handle 4570 160 61 154 AIR 10 809 20 200 106 SUREACE Express Handle 3192 118 177 96 AIR First-Clas5Handle Montenegro 6 Express George's-Grenada 5 First-Class Handle Belgium Express Somalia 9127 96 191 157 TRUCKLOAD Handle Pretoria-South Africa St. 9713 174 123 70 TRUCKLOAD Kuala Lumpur-Malaysia Brussels- 9793 50 122 87 SUURFACE Handle 10 814 152 27 139 SUREACE Astana-Kazakhstan Mogadishu- IS100 ASSIGNMENT 2-Data Analysis and MS Excel Q1: 20 points(a-4 b-7e-9 points),Q2: 40 points(8 points each), 03:40 points(a-5 b-10 e-10 d-10 e-5 points) The data file in txt format includes information about goods that are delivered by an international freight'shipping company 41) You are asked to do the following steps Import data provided in.ixt format into the sheet called "DATA b- Sort the data with respect to the content type from Z to A c-Insert a new column to the left hand side of the column "Delivery Type" and name it as "Label ID. By using AutoFill property af 7Excel, fil this column with label IDs from CK01 through CK49 for Handla, from ENO1 through EN42 for Engine, from BU01 through BU44 for Bumper, from B001 through 8070 for Bonnet and from BLO01 through BL45 for Binker material types of content 2) Do the following steps a- In the sheet named as "DATA", split the text including cities-countries in the column Destination-From into two columns with titles From City.."From Country. and repeat the same procedure for the colum-Destination-To" by creating two new colums with ttes; To City" and "To Country by using available options of the Data Rbbon b- Copy all the contents of the sheet "DATA" into the sheet called "Filtered Goods", By using the Fiter option of Excel, display only the 0 goods which are delivered via TRUCKLOAD, from countries that begin with the letter "S" and the destination countries contain the etter "A" c- In the sheet"DATA", create a new column next to the column "Posting Via", with the title as "Ratio" and calculate the folowing 1 formula for each good Rato (Weightwwidh Height'Length) 2 d-Format the "Ratio" column so that only three decimal places are displayed e-Find the goods which have a Ratio value biger than 0,6. Locate these goods into the sheet called "Chart. Calculate the sum of these ratio values. Draw an appropriate chart for these goods with the label IDs. The type of the chart should ilustrate the contribution of each good lo the sum of these ratio values Note: Display percentages and the legend informetion on the chwt, with the chavt htle as Ratio 1 3) Do the following steps 5 a-Copy the content of the sheet "DATA into the sheet called "Mailing Price b-Create a new colum next to the column "Ratio" with the ttie as-Mailing Price. and calculate the price for each good as folowing: Compute the mailing price of each good, by multplying the unit price 10TL for the HANDLE and TTL for the rest of the "content type materials by its quantity c-There a 20% discount in the maing price f a good is sent by TRUCKLOAD. Create a column name it as "Discounted Price" next to the column named as Mailing Price and compute the discounted price for each good. 7 Hint: Use appropriate predefined Excel functions. You can obtain more information about how to use a certain function by clicking on Help on this function" from Tnsert Function feature You can copy and paste avalable examples of the Help to the Excel sheet and try to figure out how t works. Optionaly you can search via Google on how to use a specic function. d- Calculate the mean and minimum value of discounted price, and mean and maximum value of mailing price of all goods by 18 using the appropriate formulas. The results should be located into the undermost cels of "Discounted Price and "Mailing Price" columns, respectively e-Select all the data in the sheet called "Mailing Price", align cel contents to left, format the "Maling Price" and "Discount Price columns so that only two decimal places are shown Important Note: When using predefined functions of Excel or calculating manually, DO NOT provide only the results of the calculation. The functionMormula that you have used should be visible in the formula bar. Values written without functions/tormulas will be graded as zerol 20 Mail Delivery Type Content Type Destination-From Destination-To Quantity Weight (gr) Height (cm) Length {cm} Posting via Width (cm) Priority Blinker Vaduz-Liechtenstein Stockholm- Registered Blinker Registered Blinker Funafuti-Tuvalu Dhaka-Bangladesh 3 Registered Blinker Registered Blinker Guatemala City-Guatemala 1091 133 29 SURFACE London-England ontevideo-Uruguay 8210 126 133 9 SURFACE vilnius-Lithuania Cardiff- 4062 187 4 SURFACE Basseterre-Saint Kitts and Nevis 9 120 AIR 2703 178 3 First-Class Blinker Stanley-Falkland Islands Adamstown-Pitcairn Islands 5 3327 196 138 AIR Express Blinker Putrajaya-Malaysia Dibouti- Djibouti 1 First-Class Blinker 899 165 69 8 Pago Pago-American Samoa Dushanbe-Tajikistan 94261 104 147 128 First-class Blinker victoria-Seychelles Janestown- Saint Helena 4977 186 40 Priority Blinker Douglas-Isle of Man Dodoma 11 133 63 SURFACE Express Blinker Beijing-People's Republic of China Lom ogo 9 4591 81 177 193 AIR Minsk-Belarus Blinker Gibraltar- Expres3 Gibraltar8 Expresa Blinker virgin Islands 7 First-Class Blinker Amman-Jordan 5092 146 61 173 TRUCKLOAD Dhaka-Bangladesh Road Town-British 1704 BO 8 135 SURFACE San Marino-San 1378 186 43 Express Blinker Belfast-United Kingdom Northern Ireland Abu Dhabi-United Arab Emirates 169 101 25 AIR 35 B Priority Blinker Bujumbura-Burundi 95 Bandar Seri Begawan-Brunei st Santiago- 3197 35 104 SURFACE First-Class Blinker Peter Port-Guernsey 5 Express Blinker ntiago-chile Guatemala city- 9438 18 178 124 AIR Guatemala 2 First-class Blinker 2829 187 193 133 AIR The Valley-Anguilla Maputo- 90 SURFACE Priority Blinker Honduras 10 9841 81 Reqular Blinker Tripol1-Libva N D1amena-Chad 4 Kigali-Rwanda Tegucigalpa 161 42 TRUCKLOAD 75 190 SURFACE Priority Blinker aghdad-Iraq New Guinea 9 Priority Blinker Grytviken-Georgia and the South Sandwich Willemstad-Netherlands Antilles 2 Port Moresby-Papua 1463 146 122 153 SURFACE 5911 97 TRUCKLOAD Bamako-MaliWellington-New 2ealand 1 118 AIR Tiraspol-Transnistria Belgrade- First-Class Blinker 5478 78 48 First-Class Blinker Serbia 8989 65 2 Regular Blinker 4684 173 91 16 Blinker T avn-Faroe Islands Paris-France SURFACE Priority Port Moresby-Papua New Guinea Budapest-Hungary 7866 112 128 37 Express Blinker Paris-France New Delhi-India 2 5694 87 194 57 SURFACE First-class Blinker elgrade-serbia Riyadh-saudi Arabia Express Blinker Belmopan-Belize Jerusalem- 7032 13 1574 TRUCKLOAD alesti First-Class Blinker 9297 47 191 111 AIR Palikir-Federated States of Micronesia Libreville-Gabon 2 9440 167 32 124 Blinker Bratislava-slovakia Express Antananarivo-Madagascar 2071 96 144 13 SURFACE Priority Bli nker Georgetown-Guyana 1784 92 72 Priority Blinker Lima-Peru Marigot-saint Martin 5 6008 42 First-Class Blinker Turkey Express Blinker Miquelo Bern-switzerland l Gibraltar-Gibraltar Istanbul- 4330 126 42 1B8 SURFACE St. Pierre-Saint Pierre and 3712 154 131 18 Blinker Asuncilaraguay laanbaatar- Express Mongolia 6 Express Blinker 1031 114 61 142 AIR San Salvador-El Salvador Pretoria-Soyth Africa (official) 1 SUREACE Priority Blinker Basseterre-Saint Ritts and Nevis Harare-Zimbabwe 3 1799 128 98 174 AIR Priority Blinker Abu Dhabi-United Arab Emirates Sarajevo-Boania and Herzegovina 228177 64 151 AIR 10 6124 193 10 66 AIR 5483 82 3398 138 146 71 AIR Priority Blinker stockholm-Sweden BogotoaDolombia Express Blinker Marigot-saint Martin Tokyo-Japan 2 94 SURFACE Havana-CubaNindhoek-Namibia 7 Blinker First-Class Blinker Ethiopia 8 First-class Blinker Addis Ababa-Ethiopia Port-au 8 Canberra-Australia 8742 182 172 45 934 80 Registered Bonnet Mamoudzou-Mayotte Bridgetown-Barbados Brazzaville- South Sandwich Islands-British Over Dublin- 202 138 57 Expres Bonnet Republic of the Congo 5 Registered Bonnet SURFACEs Territory 5158 19 136 17B AIR Hamilton-Bermuda 8 Bucharest-Romania Ankara-Turkey Ashgabat- 435 32 AIR Priority Bonnet Lebanon Registered Bonnet Turkmenistan Beirut- 9202 B0 130 168 TRUCKLOAD 8952 111 10 110 SURFACE Priority Bonnet Dublin-Ireland Oslo-Norwayl 5136 67 12 196 SURFACE Priority Bonnet Amsterdam-Netherlands (official) st. John's-Antigua and Bar 133 181 TRUCKLOAD 3918 87 Bonnet Istanbul-Turkey Kigal1-Rwanda 8 192 127 12 16 AIR First-Clas5Bonnet OversURFACEs Territory-South Sandwich Ilands Jamestown-Saint Helena British 9676 199 142 179 TRUCKLOAD First-Class Bonnet Manama-Bahrain Helsinki-Finland 7 4940 115 119 79 SURFACE Naypyidaw-Myanma:r First-Class Bonnet Philippines 7 First-Clas5Bonnet Manila- Papeete-French Polynesia 1458 168 70 91 SURFACE Banjul-Gambia Porto-Novo 3 117 59 194 114 SURFACE First-Clas5Bonnet Istanbul-Turkey Yamoussoukro-Cote Nouakchott-Mauritania Skopje- Vatican city-Vatican City 631 18 First-Clas5Bonnet Macedonia5 Priority Bonnet 599 75 153 188 AIR Jakarta-Indonesia SUREACE 7822 129 188 121 First-Clas5Bonnet Grenadines Canberra-Australia Kingstown-Saint Vincent and the 5375 145 10 AIR Priority Bonnet First-Clas5Bonnet Priority Bonnet Algiers-Algeria Mata-Utu 2209 136 106 75 TRUCKLOAD 510 109 62 Cairo-Egypt 10 1594 134 86 138 TRUCKLOAD Bishkek-Kyrgyzstan Yaren-Nauru4 107 SURFACE Road Town-British Virin Islands Paramaribo-Suriname Chisinau- Port of Spain-Trinidad and Tobago Alofi-Niue Dakar-Senegal 2 Riyadh-Saudi Arabia Maudzou Windhoek-Namibia South Tara Podgorica-Montenegro Baghdad-Iraq Monrovia-Liberia Khartoum-Sudan 7 Berlin-Gmany Luka-Zambia First-Class Bonnet MoLdova Priority Bonnet 1707 45 6 56 SURFACE Pristina-Kosovo 5 3407 58 52 77 AIR Priority Bonnet 573B 151 46 70 TRUCKLOAD Priority Bonnet Mayotte First-Clas5Bonnet Kiribati 9 First-Class Bonnet 6103 73 92134 SUREACE 2353 196 19 196 AIR 10 9208 2B 140 27 SURFACE 3215 161 98 9609 59 147 184 AIR Priority Bonnet First-Clas5Bonnet First-Class Bonnet verde 1 San Marino-san Marino Praia-Cape 20 Panama City-Pama Luxmbourg 3231 162 124 103 TRUCKLOAD Tbilisi-Georgia Prague-czech 5647 96 Bornne 132 TRUCKLOAD city-Luxembour First-Clas5Bonnet Republic 48347 55 62 143 AIR Priority Bonnet Kyrenia-cyprus Accra-Ghana 3 9052 131 26 102 AIR First-class Bumper Bissau-Guinea Bissau-Guinea8 545B BT 158 123 TRUCKLOAD Castries-Saint Lucia Yaound 3921 72 43 69TRUCKLOAD Priority Bumper Central African Republic 2 Wellington-New 2ealand Bangui- 2586 27 SUREACE First-class Bumper Edinburgh-scotland Lima-Peru 3105 75 166 64 SURFACE Priority Bumper Falkland Islands B Stanley- Seoul-South Korea 1993 109 72 172 SURFACE Rabat-Morocco Vatican city- 196 AIR Vatican City First-class Bumper 10 2910 189 67 Abuja-Nigeria ReykjavDIceland S 172 AIR Willemstad-Netherlands Antilles 9332 196 80 Priority Bumper Minsk-Belarus 6441 101 7 AIR First-class Bumper Morocco First-class Bumper Malabo-Equatorial Guinea abat- 803 23 147 19 TRUCKLOAD Washington D.C.-United States 5745 149 190 170 AIR Kiev-Ukraine First-class Bumper Oranjestad-Aruba 7 3680 112 152 22 TRUCKLOAD First-class Bumper Kenya 6 First-class Bumper Kabul-Afghanistan Mbabane-Swaziland Tegucigalpa-Honduras Amsterdam- Malaldives Zagreb-Croatia George Town-ca Nairobi- 2636 124 105 124 SUREACE Naypyidaw 8952 89 110 80 SURFACE First-class Bumper Netherlands 1 4174 14 148 153 AIR 10 B110 160 154 13 AIR First-class Bumper yman Islands 6085 12 25 24 Tiraspol-Transnistria 4 AIR valletta-Malta Malaldives 10 3767 51 190 87AIR Priority Bumper Burkina Faso Yerevan-Armenia uagadougou- 163 42 97 3 AIR Yaound ameroon Pyongyang-North 176 154 SUREACE Yaren-NauruQuito-Ecuador Expre55 8891 8 140 111 147 11 AIR First-class Bumper Oranjestad-Aruba Copenhagen-Denmark Niamey-Wiger Dili-East Timor (Timor) Istanbul- Asmara-Eritrea Ottawa-Canada 3 Tirana-Albania Hargeisa- Harare-2imbabwe Singapore- Tokyo-JapanMaseru-Lesotho 3 2140 154 146 18 AIR First-class Bumper Barbados 10 8527 134 199 170 AIR Turkey Priority Bumper 9695 81 179 191 SURFACE 5281 79 129 131 SURFACE Somaliland 10 7957 75 153 179 AIR singapore 10 3036 135 56 147 SURFACE First-class Bumper 3733 39 74 39 AIR Priority Bumper Porto-Novo Port Vila-Vanuatu 1441 120 132 119 AIR Express Engine Aires-Argentina 2 South Tarawa-Kiribati Buenos B594 B3 Skopje-Macedonia San Jos osta Kingston-Jamaica Cockburn Town- 10 20 AIR Priority Engine Rica Express Engine 98B6 181 139 56 AIR Turks and Caicos Islands 1 3B74 120 88 Priority Engine Islands Priority Engine Monaco Priority Engine 3963 82 2063 25 4742 103 101 113 SUREACE Nuuk-Greenland Majuro-Marshall Bratialava-Slovakia Monaco- Monaco-Monaco Roseau-Dominica 1 66 194 SURFACE Firt-Cla53 Engine Bern-Switzerland Suva-Fiji 3 Express Engine Tom ao Tome and Principe 10 4459 103 187 159 Express Engine Express 523 181 198 76 TRUCKLOAD LaDune El Aain)-Western Sahara S TRUCKLOAD Jerusalem-Palestine St. Helier- Rome-Italy Islanabad-Pakistan1 Phnom Penh-Cambodia Bujumbura- Luxembourg city-Luxembourg Gustavia-Saint Barthelemy 8607 77 157 120 AIR Eng 6553 160 127 84 SURFACE First-class Engine Burundi Express Engine 5254 196 187 139 AIR Istanbul-Turkey 10 3154 175 125 AIR First-class Engine Algiers-Algeria 1 1890 44 194 AIR First-class Engine Korea 10 1099 101 First-ciass Engine D..-United States First-class Engine Prague-czech Republic Seoul-South 28 Maputo-Mozambique 75 AIR 5324 47139 86 SUREACE Cardiff-Wales Avarua-Cook 907 64 177 13 AIR First-class Engine Congo Amman-Jordan First-class Engine Islands Kinshasa-Democratic Republic of the 10 487 33 19 43SURFACE Lilongve-Malawi George Town-Cayman 49 Luanda-Angola Banjul-Gambia 6 749 138 190 AIR Eng 9762 117 95 144 AIR Regular Engine Kingdom 3693 125 192 115 AIP Priority Engine Nairobi-Kenya Yamoussoukro-Cote d'Ivoire Tashkent-Uzbekistan AIR 4 9474 125 185 125 First-class Engine Apia-Samoa San Juan-Puerto Rico 1 1248 45 153 121 TRUCKLOAD Regular Engine Port-au aduz-Liechtenstein 1 2138 163 92 105 SURFACE First-class Engine Western Sahara First-class Engine Helsinki-Finland LaDune (El Aain)- 4545 135 160 135 TRUCKLOAD Kampala-Uganda Nuuk-Greenland 4 6194 41 17 193 SURFACE Priority Engine Kathmandu-Nepal Tbilisi-Georgia 1 4308 35 200 119 AIR Port Louis-Mauritius Vienna First-classEngine Austria 2 9664 8 31 110 AIR san Jos osta Rica wait city Doha-Qatar Kyrenia-Cyprus 9 RoSUREACEu-Dominica Istanbul- Suva-Fii Freetown-sierra Leone 4 BrasOa-Brazil Gaborone-Botswana Bangkok-Thailand Kingstown-saint First-classEngine Kuwait Regular 6035 158 119 9 AIR Enqine B080 107 112 86 AIR Engine 3011 146 133 66 AIR First-classEngine 7922 98 107 104 AIR Engine 10 862 37 37 102 AIR First-clas5Engine vincent and the Grenadines 10 1127 198 36 175 First-classEngine First-clas5Engine AIR ucre-Bolivia Tripo1i-Libya 9 3386 73 29 165 AIR Santo Domingo-Dominican Republic Lisbon-Portugal 8 TRUCKLOAD 2121 7 151 24 First-class Engine American Samoa 5 First-classEngine Ashgabat-Turkmenistan Pago Pago- 9174 29 34 132 AIR Dakar-senegal Damascu:s 150 AIR 715 114 42 Bangui-Central African Republic Moscow-Russia ity Engine 6949 128 68 AIR PrioritY Freetown-Sierra Leone Asmara Eritrea First-classEngine Priority Engine Priority Engine 10 4619 105 147 173 AIR Lom ogo Malabo-Equatorial Guinea 153 200 174 155 AIR Tomao Tome and Principe 4521 115 97 B4 SURFACE N'Djamena-Chad St. Pierre-Saint 3 Port Vila-Vanuatu 171 160 TRUCKLOAD Moroni-Comoros Flying Fish Cove- Havana-Cuba 5 Pierre and Miquelon 843 120 BO SURFACE Handle 5084 46 Ngerulmud- Priority Handle Christmas Island 10 9247 55 40198 TRUCKLOAD Registered Handle Regiatered Handle Priority Handle Priority Handle Accra-Ghana Di11-East Timor (Timor) Chisinau-Moldova Hag j a-Guam Pristina-Kosovo Itanbul-Turkey 5 Saipan-Northern Mariana Islands 9678 26 135 19 TRUCKLOAD 6482 22 107 8 5615 67 101 170 SURFACE Kinshasa-Democratic Republic of the Congo 1 SURFACE 7801 56 165 25 AIR Regiatered Handle Saint Barthelemy 6 Registered Handle St. Helier-Jersey 6847 28 Copenhagen-Denmark Gustavia- 124 183 TRUCRLOAD 3965 88 73 AIR First-Class Handle Hargeisa-Somaliland Victoria- Seychel1es g 9073 149 132 152 AIR Handle Damascus-Syria Kingston-Jamaica 10 9271 184 153 40 SURFACE First-Class Handle Sri Jayavardenepura [g]-sri Lanka Moroni-Comoros 6 1166 197 B1 12 AIR singapore-Singapore Monrovia- First-Class Handle Liberia First-class Handle Zagreb-Croatia Conakry-Guinea 1398 43 195 AIR 10 4739 57 9 52 SURFACE First-Class Handle Tuvalu Priority Handle Pyongyang-North Korea Funafuti- 741198 45 190 TRUCKLOAD st. John'3-Antigua and Barbuda Edinburgh-Scotland 1 460 169 95106 AIR Madrid-Spain SanaDemen Kabul-Afghanistan Athens- Caracas-Venezuela Thimphu-Bhutan Athens-Greece 9 Vienna-Austria The Valley- Gaborone-Botswana Ankara-Turkey 9 361 48 32 196 938 71 104 1B3 SURFACE Greece Vilnius-Lithuania 4047 2B SURFACE Priority Handle 691 SURFACE Regular 7428 154 155 172 TRUCKLOAD First-Class Handle Anguilla 3 Regular Handle Nicaragua 10 6463 16 194 192 AIF First-Class Handle Caledonia 8 Priority Handle Suriname 6 First-Class Handle 3299 94 162 170 SURFACE Avarua-Cook Islands NoumNe Istanbul-Turkey Paramaribo- Praia-Cape Verde Warsaw-Poland 3 Brazzaville-Republic of the Congo United Kingdom Akrotiri and 9217 172 111 65 AIR AIR B69 B7 60 137 SURFACE First-Class Handle Charlotte Amalie-United States Virgin Islands 8161 B5 9B 175 SURFACE Regular Dhekelia -Episkopi Cantonment First-Class Handle Priority Handle First-Class Handle First-Class Handle Manama-Bahrain 984 69 144 116 SURFACE 6648 103 119 110 AIR 9791 131 150 172 AIR 5580 195 97 28 AIR Dodoma-Tanzania Nukualofa-Tonga 4 Khartoum-Sudan Bangkok-Thailand 2 Ngerulmud-Palau Vientiane-Laos 1 Djibouti-Djibouti 71 Tallinn-Estonia Mbabane-Swaziland Madrid-Spain 2658 13 9058 162 154 40 AIR Priority Handle Libreville-Gabon Valletta-Malta 3 9307 135 190 178 TRUCKLOAD Priority Handle Penh-Cambodia 1 Phnom St. peter Port-Guernsey 1752 126 116 40 SURFACE ottawa-Canada Ljubljana-slovenia 10 3344 177 169 135 AIR First-Class Handle Istanbul-Turkey Kingston-Norfolk St. George's-Grenada South 3977 16 6 166 AIR 1842 32 152 AIR First-Class Handle Georgia and the South Sandwich Islands South Georgia and the-Grytviken 4 First-Class Handle Albania Priority Handle Madagascar First-Class Handle virgin Islands United Kingdom Northern Ireland-Belfast Adamstown-Pitcairn Islands Tirana- Nukualofa-Tonga Antananarivo- Charlotte Amalie-United States 6025 197 63185 TRUCKLOAD 10 9094 13 193 7 AIR 10 9411 162 48 188 AIR Priority Handle Flying Fish Cove-Christmas Island 3108 26 3 Buenos Aires-Argentina Santo Doha-Qatar 5 12 AIR Handle Expres Domingo-Dominican Republic 1 554 162 156 84 AIR Cairo-Egypt Saipan-Northern Mariana Nassau-Bahamas Mexico city-Mexico Hanoi-Vietnam Itabul-Turkey 7 Ulaanbaatar-Mongolia Podgorica- First-Class Handle Ialands Priority Handle 4570 160 61 154 AIR 10 809 20 200 106 SUREACE Express Handle 3192 118 177 96 AIR First-Clas5Handle Montenegro 6 Express George's-Grenada 5 First-Class Handle Belgium Express Somalia 9127 96 191 157 TRUCKLOAD Handle Pretoria-South Africa St. 9713 174 123 70 TRUCKLOAD Kuala Lumpur-Malaysia Brussels- 9793 50 122 87 SUURFACE Handle 10 814 152 27 139 SUREACE Astana-Kazakhstan Mogadishu