Suppose you work for a technology company and you are taking a business trip to Japan to purchase some parts. The Japanese use yen for their currency. When you arrive in Japan, the
manufacturers have listed the prices in yen. To figure out how much you are spending, you will
need to convert the prices in yen to U. S. dollars. You know that one U. S. dollar equals 105.06 yen
at the time of your trip, so you use your spreadsheet to make this conversion. You enter a price
in one cell and in another cell, you enter a formula that multiplies the price by 105.06. In this
way, you can quickly see how much an item costs in U. S. dollars.
Objectives
Create a spreadsheet to convert foreign currency to U. S. dollars.
Directions
Part 1: Select ten foreign currencies and find the current exchange rate. Since currency
exchange rates change often, you will need to look up the exchange rates. You can call a bank or
look for foreign currency exchange rates on the Internet or in a newspaper.
Part 2: Create a spreadsheet that lists the ten currencies you chose. For each currency, enter an
amount and create a formula to convert it to U. S. dollars. Make sure to include dollar signs in
the appropriate cells