Learning Goal: I’m working on a excel multi-part question and need an explanation and answer to help me learn.
Assessment 3: Use Scenario Manager
1.Open PreCdnTarget.xlsx. 2.Save the workbook with the name 5-PreCdnTarget
3.Create scenarios to save various percentage data sets for the four regions using
the following information: a. A scenario named OriginalTarget that stores the current values in the range K4:K7. b. A scenario named LowSales with the following values: East0.20 West0.32 Ontario0.48 Quebec0.37 c. A scenario named HighSales with the following values: East0.36 West0.58 Ontario0.77 Quebec0.63 4.Show the LowSales scenario and then print the worksheet. 5.Create a scenario summary report that displays cell H 18 as the result cell. 6.Save and then close 5-PreCdnTarget.