$2\mathrm{.}1$ Use the Scenario

Manager to input each of the four decision sets depicted in range B$16$:F$19.$

a$.$ The names of each decision set are given in cells Use the decision set name as the Scenario Name in each of the four scenarios. The grader requires the Scenario Names be spell correctly.

b$.$ You must type the data into Scenario Manager, because Excel does not allow you to use a cell reference to enter data into a scenario.

c$.$ Create the summary of the scenarios on a new worksheet.

d$.$ Do not rename the scenario summary sheet generated by the scenario manager. The grader uses the default sheet name during the grading process. If you need to recreate the scenario summary, delete the original scenario summary sheet before