Loan / VLookup Assignment

Download the following file Loan VLookup and use the file to complete the following questions.

1. For the Shop Loan sheet, you need to calculate the Payment per month using a function. Your payment amount needs to be a positive number.
2. For the Order Form sheet:

• Fill in your name in cell C4
• Enter today's date as a function in cell C6
• Click on cell A9-A12, use the dropdown list provided and select four different items, one for each cell.
• Create a formula that will provide the description of the item for cells B9:B12 (Be sure to reference the Product Information sheet)
• Add quantities of any amount for each of the items
• Create a formula that returns the Unit Price for each item for cells D9:D12 (Be sure to reference the Product Information sheet)
• Create a formula that calculates the Order Amount for each item for cells E9:E12
• Create a formula that provides a Total for all of the items ordered for cell E13
• Some of your formulas will require that you use an absolute reference. Test your sheet by picking different items in cells A9-A12 to be sure they work if a different item is chosen.