Project: Using Simple Formulas
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.