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.

Question # 1

File Upload

Upload your spreadsheet.