Microsoft Office Tutorials and References
In Depth Information
ASSIGNMENT 1: CREATING A SPREADSHEET FOR DECISION SUPPORT
Each Changing Cell must be an integer greater than or equal to zero
you cannot buy half
Your total spending on advertising cannot exceed the limit specified in the Constants
worksheet to use with Solver. When Solver finds a
solution, it will replace the historical advertising media selections with the new optimized selections. To
create a copy of the spreadsheet in the same workbook, right-click the tab at the bottom of the worksheet.
In Figure 8-6, note that the worksheet is named Kuhlmans
Next, you should make a copy of your
Historical. Select Move or Copy from the menu.
Selecting the Move or Copy command
When the Move or Copy dialog box appears (see Figure 8-7), click Create a copy, click the (move to end)
option, and then click OK.
Move or Copy worksheet dialog box
s name followed by a (2). Right-click
the name tab to rename the worksheet (see Figure 8-8). In this example, the worksheet was renamed
The new copy of the worksheet will appear with the old worksheet
Renaming the copied worksheet