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