• Home
  • Blog
  • Project 4C: Auto LoanIn Applied Spreadsheet, homework help

Project 4C: Auto LoanIn Applied Spreadsheet, homework help

0 comments

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:

About the Author

Follow me


{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}