Download the following file Loan VLookup and use the file to complete the following questions.
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.
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.
What Students Are Saying About Us
.......... Customer ID: 12*** | Rating: ⭐⭐⭐⭐⭐"Honestly, I was afraid to send my paper to you, but you proved you are a trustworthy service. My essay was done in less than a day, and I received a brilliant piece. I didn’t even believe it was my essay at first 🙂 Great job, thank you!"
.......... Customer ID: 11***| Rating: ⭐⭐⭐⭐⭐
"This company is the best there is. They saved me so many times, I cannot even keep count. Now I recommend it to all my friends, and none of them have complained about it. The writers here are excellent."
"Order a custom Paper on Similar Assignment at essayfount.com! No Plagiarism! Enjoy 20% Discount!"
