How do you  make scenarios in excel?
 Click the Summary button to open a new window.Check the report option you want and then enter the cell references you want the report to include live your first scenario a name and click the grid button under Changing Cells to define the cell or range of cells for which you want to create scenarios, or different possible values. Click OK.. Input the values you want each cell to have in the scenario. 