7 On this second conversion sheet, you will convert a trip budget into the equivalent amounts in several foreign currencies and convert 1000 of the local currency into the equivalent number of dollars.
Name from Analysis Sheet	Zion Goodenough
Trip Budget in dollars	$90,482.00			Legend
Now, from the list below the table below, select four countries that start with the first two letters of your first and last names. If your first or last name is only one letter long, use the letter M as the second letter of each name that is one letter long. If there is no country starting with a particular letter or you have run out of countries to choose from for a particular letter, go to the next letter of the alphabet that you still have available choices for and select a country starting with that letter. (If you are at the letter Z, go back to A.)	If a cell is shaded	You should
Blue	Enter a text response
Green	Enter a number
Yellow	Enter an Excel formula
Any other color	Make no changes
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 following web page:
	https://www.xe.com/currencyconverter
Then, convert your monthly savings above into this currency and 1000 units of the local currency into dollar. These calculations must be Excel 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 your calculation there). Add special formatting as indicated in the last column of the table. Other entries may use general formatting. An example is provided for you. Note that this country is not available for you to choose from the list.
	Example	First letter of your first name	Second letter of your first name	First letter of your last name	Second letter of your last name
The letter	T	Z	I	G	O
Country starting with the letter (or next available letter)	Tajikistan
The date that you looked up the conversion rate (must be within 2 weeks of your assignment due date)	05/23/2020
Full name of the country's currency as listed on the XE website	Tajikistani somoni
Currency code (ISO-4217)	TJS
Exchange rate for the currency to at least 5 significant digits (or exact rate if there are fewer than 5 significant digits)	10.2686312
Your savings in the country's currency	##########
1000 units of the country's currency in dollars	$97.38
Choose your countries from this list
Afghanistan	Cambodia	Guatemala	Lebanon	Pakistan	Switzerland
Albania	Canada	Guernsey(UK)	Liberia	Papua New Guinea	Syria
Algeria	Cayman Islands(UK)	Guinea	Libya	Paraguay	Taiwan
Angola	Chile	Guyana	Macau(China)	Peru	Tanzania
Argentina	China	Haiti	Madagascar	Philippines	Thailand
Armenia	Colombia	Honduras	Malawi	Poland	Tonga
Aruba(Netherlands)	Comoros	Hong Kong(China)	Malaysia	Qatar	Trinidad and Tobago
Australia	Congo, Democratic Republic of the	Hungary	Maldives	Romania	Tunisia
Azerbaijan	Costa Rica	Iceland	Mauritania	Russia	Turkey
Bahamas	Croatia	India	Mauritius	Rwanda	Turkmenistan
Bahrain	Cuba	Indonesia	Mexico	Saint Helena(UK)	Uganda
Bangladesh	Czechia	International Monetary Fund (IMF)	Moldova	Samoa	Ukraine
Barbados	Denmark	Iran	Mongolia	Sao Tome and Principe	United Arab Emirates
Belarus	Djibouti	Iraq	Morocco	Saudi Arabia	United Kingdom
Belize	Dominica	Isle of Man(UK)	Mozambique	Serbia	Uruguay
Bermuda(UK)	Dominican Republic	Israel	Myanmar(formerly Burma)	Seychelles	Uzbekistan
Bhutan	Egypt	Jamaica	Namibia	Sierra Leone	Vanuatu
Bolivia	Eritrea	Japan	Nepal	Singapore	Venezuela
Bosnia and Herzegovina	Ethiopia	Jersey(UK)	New Zealand	Somalia	Vietnam
Botswana	Falkland Islands(UK)	Jordan	Nicaragua	South Africa	Wallis and Futuna(France)
Brazil	Fiji	Kazakhstan	Nigeria	South Korea	Yemen
Brunei	Gambia	Kenya	North Korea	Sri Lanka	Zambia
Bulgaria	Georgia	Kuwait	North Macedonia(formerly Macedonia)	Sudan
Burundi	Ghana	Kyrgyzstan	Norway	Suriname
Cabo Verde	Gibraltar(UK)	Laos	Oman	Sweden