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.
Cheap Essay essays are NOT intended to be forwarded as finalized work as it is only strictly meant to be used for research and study purposes. Cheap Essay does not endorse or condone any type of plagiarism.