University of California Proposed Sales Target for Canadian Distributor Excel Task

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.