EXCEL WORK HELP

Assignment 6 – VLOOKUP

Create a workbook with the first two worksheets called “Television Ads” and “Conversion Rates”. They have to be identical to the worksheets shown below when the workbook is first opened. Additional worksheets are allowed.

Television Ads worksheet

You are thinking of buying television ads for your new Excel consulting firm. The price of the ads drops depending on the number purchased. Initially, when the workbook is opened the user will see:

Say the user enters 8 in the “Ads” box:

After hitting the Enter key:

Do not display a cost until a value is entered in D14. You can assume that the number of ads entered will be ≥ 1.

Conversion Rates worksheet

The Bank of Montreal heard you were taking Comp 2853 and hired you at a very high salary to build a foreign exchange calculator. Initially, when the workbook is opened the user will see:

The user enters the amount of the foreign currency to purchase in G8. For example, the user could enter 100:

The user then chooses a foreign currency in cell I8. Cell I8 contains a drop down list with the following options: US Dollar, and Euro. See p. 595 of the text for instructions on how to create a drop-down list. Assume the user chooses “Euro”.

The cost to purchase 100 Euros is then displayed in G10:

Do not display anything in G10 until the user has entered both the quantity and currency. Use current Bank of Montreal exchange rates from the Web.

1