Enter a cell using relative cell reference excel 2016

Change the monetary symbol accordingly for each conversion (using the Euro в‚¬ 123 format for Germany).ДЇormat the range A3:D4 with Yellow fill (under Standard Colors) and a thick outside border. Be sure to use absolute cell references where necessary. 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. For example, the country currency for Germany should be Euro. 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. On the Currency Exchange worksheet, format the title International Travel Currency Converter as bold with 14 pt font.

Open Excel, and then open the downloaded file final_exam.xlsx. Of course, you are working on these tasks in your spare time at work as an administrative assistant for the CIS Department, where you are working on several worksheets to evaluate faculty data. Once you return, you will be purchasing a new boat, so you are also working on an amortization table in order to adjust your budget. You have designed a currency converter so you can determine how much money you need to take into each country. You are planning on taking a vacation abroad later this year.

Enter a cell using relative cell reference excel 2016