Complete Learning Activities 7 Complete The Quest

Complete Learning Activities 7 Complete The Quest

Complete Learning Activities 7 Complete The Quest

In this exercise, you’ll work with some decision making tools in Excel that you read about in Chapter 6, Goal-Seek and Scenario Manager. To get use to these two tools, I’d like you to work through some practice exercises from Appendix G, then complete a handful of learning activities from the Appendix, then finish up with some decision making of your own using these tools.

Instructions:

There is a lot of information to these Instructions. Please read everything before beginning the assignment.

  • Download and review the following PDF file: Appendix G – Advanced Excel.
    • Work through the practice exercises on Scenario Manager and Goal-Seek, starting on page 9. You’ll need the following file: Fun-Parks.xlsx (note you can also download this file from the publisher’s resource page).
    • You will NOT submit this practice work!
  • Complete Learning Activities 7 – 10 in Appendix G
    • You will need the following files: Fun4Pups.xlsx and MailCampaign.xlsx.
    • Place each activity on its own worksheet, appropriately labelled, and the multiple worksheets submitted as a single Excel file, or workbook.
    • Here are some YouTube videos that deal with Goal Seek and Scenario Manager:
  • Download the following file and complete the following exercise:
    • Car-Buying.xlsx
    • Use the Car-Buying spreadsheet to determine the monthly payment, total payments, and total paid for three interest rates and three periods (total months of payment). In a text box on the Main sheet, briefly explain how you would use this spreadsheet when shopping for a car.
      • Are there any other variables on this spreadsheet you should consider changing? Why?
      • What would happen if you paid an extra $50 a month?
      • You will need to use the Data Tables feature of Excel for the first part of the assignment. Here is a YouTube video showing how to use this feature:
  • These instructions mean you will submit two files.
  • Be sure to include your name in a prominent place in the file. A standard practice in designing an Excel spreadsheet is to use the first (furthest left) worksheet for documentation, so placing your information on that sheet is a good idea.

Suggestions:

  • When a spreadsheet file is saved, it will open on the sheet and in the cell where you finished your work. I STRONGLY suggest, that as a final touch, you place the selector in cell A1 on each sheet, and make the furthest left sheet active BEFORE the last save.