Question: Help solve this please. Use the VLOOKUP function, the data on the Currency Table worksheet, and appropriate relative and absolute cell references to display the


Use the VLOOKUP function, the data on the Currency Table worksheet, and appropriate relative and absolute cell references to display the country's currency name in its respective cell in row 5. Use the VLOOKUP function and the Currency Table to calculate the amount due based on each country's exchange rate in each country's respective cell in row 6. Be sure to use absolute cell references where necessary. Change the monetary symbol accordingly for each conversion (using the Euro 123 format for Germany). 1 International Travel Currency Converter 2 3 Country Traveling To Germany Maico Japan 4 U.S. Dollars to Exchange $ 1,000.00 $ 100.00 $ 500.00 5 Country Currency 6 Amount Due Customer 7 8 9 20 21 12 13 24 15 16 27 18 23 20 22 20 Currency Table Personal Loan Facult E2 JX A B 1 Country Currency Exchange Rate for $1.00 US 2 Argentina Peso 3.3500 3 Candada Dollar 1.5603 England Pound 0.6200 s France Euro 0.9525 Germany Euro 0.6354 Hong Kong Dollar 7.7980 India Rupee 47.8401 9 Israel Shekel 4.7783 10 Japan Yen 107.2900 21 Mexico Peso 10.2721 12 Russia Rubles 31.8300 2 South Korea Won 1,185.8000 24 Venezuela Bolivar 1,603.7500 16 Currency Table Personal Loan
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
