10 on this second conversion sheet, you will convert your monthly savings into the equivalent amounts in several foreign currencies and convert a given amount of the local currency into the equivalent number of US dollars. Start by transferring your monthly savings from the Savings and Loan Analysis sheet, using an Excel formula that references the appropriate cell directly: Your monthly savings in dollars Legend If a cell is shaded You should 1 1 Now, from the list below the table below, select four countries that start with the first two Enter a text Blue letters of your first and last names. If your first or last name is only one letter long, use the letter response 10 M as the second letter of each name that is one letter long. If there is no country starting with a Green Enter a number particular letter or you have run out of countries to choose from for a particular letter, go to the Gold Enter an Excel next letter of the alphabet that you still have available choices for and select a country starting formula 12 with that letter. (If you are at the letter Z, go back to A.) Any other color Make no changes 13 14 For each country, identify the name of the country's currency, the currency code (based on the ISO-4217 standard), and the exchange rate for $1, using the 15 following web page: https://www.xe.com/currencyconverter 16 (Currency Converter) 19 Then, convert your monthly savings above into this currency and a given number of units of the local currency into dollars. These calculations must be Excel 20 formulas that use a cell reference for the exchange rate; you may not use the currency converter link for this calculation (although you're welcome to check 21 your calculation there). 22 23 Add special formatting as indicated in the last column of the table. Other entries may use general formatting. 24 An example is provided for you. Note that this country is not available for you to choose from the list. 25 26 Example First letter of your Second letter of First letter of your Second letter of Format this 27 first name your first name last name your last name entry as 28 The letter Country starting with the letter 29 (or next available letter) Tajikistan The date that you looked up the conversion rate (must be within 2 weeks of you 5/23/20 8/19/21 8/19/21 8/19/21 8/19/21 Date 30 assignment due date) Full name of the country's currency as listed on the XE Tajikistani somoni 31 website 32 Currency code (ISO-4217) TJS Exchange rate for the currency to at least 5 significant digit 10.26863117 (or exact rate if there are 33 fewer than 5 significant digits) Your savings in the country's currency. Note that you must Currency with enter a formula here and then format the cell to display the #VALUE! the country's currency code currency code; do not enter as a symbol 34 text in this cell. 1020 units in the country's currency (note that the $97.38 Currency with 35 Example uses 1000 units) the $ symbol 36 Choose your countries from this list 37 38 Afghanistan Cambodia Guatemala Lebanon Pakistan Switzerland 39 Albania Canada Guernsey (UK) Liberia Papua New Guinea Syria 40 Algeria Cayman Islands (UK) Guinea Libya Paraguay Taiwan Angola Chile Guyana Macau (China) Peru Tanzania 42 Argentina China Haiti Madagascar Philippines Thailand 43 Armenia Colombia Honduras Malaw Poland Tonga Aruba (Netherlands) Comoros Hong Kong (China) Malaysia Qatar Trinidad and Tobago Australia Congo, Democratic Republic of the Hungary Maldives Tunisia 45 Romania 46 Azerbaijan Costa Rica Iceland Mauritania russia Turkey 47 Bahama Croatia India Mauritius Rwanda Turkmenistan 48 Bahrain Cuba Indonesia Mexico Saint Helena (UK) Uganda Bangladesh zechia Internationa Monetary Fund (IMF) Moldova amoa 49 Ukraine Barbados Sao Tome and United Arab 50 Denmark Iran Mongolia Principe Emirates 51 Belarus Djibouti Iraq Morocco Saudi Arabia United Kingdom 52 Belize Dominica Isle of Man (UK) Mozambique Serbia Uruguay Bermuda (UK) Dominican Republic Israel Myanmar (formerl y Burma) Seychelles Uzbekistan 54 Bhutan Egypt Jamaica Namibia sierra Leone Vanuatu 55 Bolivia Eritrea Japan Nepal Singapore Venezuela 56 Bosnia and Herzegovina Ethiopia Jersey (UK) New Zealand Somalia Vietnam Botswana Falkland Islands (UK) Jordan Nicaragua South Africa Wallis and 57 Futuna (France) 58 Brazil Fiji Kazakhstan Nigeria South Korea Yemer 59 Brunei Gambia Kenya North Korea Sri Lanka Zambia North Bulgaria Georgia Kuwait Macedonia (former | Sudan 60 ly Macedonia) 61 Burundi Ghana Kyrgyzstan Norway Suriname 62 Cabo Verde Gibraltar (UK) Laos Oman sweden 63 64 65 66 67