Step 4.

Steps to Perform: Step Instructions Pos 1 2 5 3 5 4 Open Excel, and then open the downloaded file yo_e_capstone_grader xlsx. Save the file as Youe sapstone grader. LastFirst using your last and first name. On the Currency Exchange worksheet, format the title International Travel Currency Converter as bold with 14 pt font. Merge and center the range A1:01. 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) Format the range A3 D4 with Yellow till (under Standard Colors) and a thick outside border Format the range A5.De with Green fill (under Standard Colors) and a thick outside borderu Note, when applying he borders use the Borders button Format the Currency Exchange worksheet to print in landscape orientation, with the data centered horizontally Insert a header with the current date(using the 81Datej tag) inserted on the left and the text Excel Student on the right side Display the Personal Loan worksheet Insert a formula in cell CB to calculate the total number of payments for the loan using relative cell references 5 5 6 5 File Home Insert Page Layout Formulas Data Review View Acroba D E A B C 1 Country Currency Exchange Rate for $1.00 US 2 Argentina Peso 3.3500 3 Candada Dollar 1.5603 4 England Pound 0.6200 5 France Euro 0.9525 6 Germany Euro 0.6354 7 Hong Kong Dollar 7.7980 8 India Rupee 47.8401 9 Israel Shekel 4.7783 10 Japan Yen 107.2900 11 Mexico Peso 10.2721 12 Russia Rubles 31.8300 13 South Korea Won 1.185.8000 14 Venezuela Bolivar 1,603.7500 15 16 17 Pe Ru wa Boli 18 19 20 21 Alignment Font D E B Excel Student Country Currency Exchange Rate for $1.00 US Argentina Peso 3.3500 Peso Candada Dollar 1.5603 Dollar England Pound 0.6200 Pound France Euro 0.9525 Euro Germany Euro 0.6354 Euro Hong Kong Dollar 7.7980 Dollar India Rupee 47.8401 Rupee Israel Shekel 4.7783 shekel Japan Yen 107 2900 Yen Mexico Peso 10.2721 Peso Russia Rubles 31.8300 Rubles South Korea Won 1.185.8000 Won Venezuela Bolivar 1,603.7500 Bolivar $ 3.35 s 1.56 f 0.62 E 0.95 0.64 s 7.80 3 47.84 S 4.78 Y 107.29 S 10.27 31.83P W 1,185.80 B.S 1.603.75 .0 11 12 35 22 Currency Toonston Faculty Data O OB 3