Project 4C: Auto LoanIn Applied Spreadsheet, homework help

Lab Work

(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:

1. Download these files to use in your lab.

   project data files

2. Follow all of the instructions for Project 4C: Auto Loan pages 273 – 276 of the textbook to create the resulting spreadsheet.
3. Don’t forget to check out the Project 4C: Auto Loan to see how this assignment will be graded.
4. Save your completed project files as:

   Lastname_Firstname_4C_Auto_Loan.xslx
   Lastname_Firstname_4C_Store_Supplies.xslx (Replace “Lastname_Firstname” with your name.) 

5. Submit the lab to the Dropbox for this assignment.

(3b-c, 5a) Project 5D: Spring SectionsIn this lab, you will reinforce your learning this week of Excel’s advanced sort and custom filter features. You also learned how to subtotal, outline, and group a list of data, which you will see again in this assignment.

To successfully complete this graded lab:

1. Download these files to use in your lab.

   project data files

2. Follow all of the instructions for Project 5D: Spring Sections on pages 338 – 340 of the textbook to create the resulting spreadsheet.
3. Don’t forget to check out the Project 5D: Spring Sections to see how this assignment will be graded.
4. Save your completed project files as: