3b-c, 5a) Project 4C: Auto LoanIn this lab, you will use Excel financial functions, Goal Seek, create a data table, and use defined names in a formula to create a cost worksheet for a company that is looking to purchase vehicles for its sales representatives.
To successfully complete this graded lab:
- Download these files to use in your lab.
- Follow all of the instructions for Project 4C: Auto Loan pages 273 – 276 of the textbook to create the resulting spreadsheet.
- Don’t forget to check out the Project 4C: Auto Loan to see how this assignment will be graded.
- Save your completed project files as: