# Complete the question

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.

• Work through the practice exercises on Scenario Manager and Goal-Seek, starting on page 9. You’ll need the following file: (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: and .
• 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:
• 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.

## Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
\$26
The price is based on these factors:
Number of pages
Urgency
Basic features
• Free title page and bibliography
• Unlimited revisions
• Plagiarism-free guarantee
• Money-back guarantee
On-demand options
• Writer’s samples
• Part-by-part delivery
• Overnight delivery
• Copies of used sources
Paper format
• 275 words per page
• 12 pt Arial/Times New Roman
• Double line spacing
• Any citation style (APA, MLA, Chicago/Turabian, Harvard)

# Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

### Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

### Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

### Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.