bussines

Directions for the 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.

Upload your completed assignment to Moodle.