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. Currently one U.S. dollar equals 105.06 Yen. You use your spreadsheet to make this conversion. You enter a price in a cell and in another cell you enter a formula that multiplies the price by 105.06. Quickly you know how much it 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