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.