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:
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 H 18 as the result cell.
6. Save and then close 5-PreCdnTarget.
Order an Essay Now & Get These Features For Free:
Turnitin Report
Formatting
Title Page
Citation
Outline
