Question
1. Open PreCdn Target. 2. Save the workbook with the name 5-PreCdn Target. 3. Create scenarios to save various percentage data sets for the
1. Open PreCdn Target. 2. Save the workbook with the name 5-PreCdn Target. 3. Create scenarios to save various percentage data sets for the four regions using the following information: a. A scenario named Original Target that stores the current values in the range K4:K7. b. A scenario named LowSales with the following values: East 0.20 West 0.32 Ontario 0.48 Quebec 0.37 c. A scenario named HighSales with the following values: East 0.36 West 0.58 Ontario 0.77 Quebec 0.63 4. Show the LowSales scenario and then print the worksheet. 5. Create a scenario summary report that displays cell H18 as the result cell. 6. Print the Scenario Summary sheet. 7. Save and then close 5-PreCdnTarget.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started