Question: Create a Scenario Summary for the two options: a . Name the first scenario as Option 1 . b . Use D 4 :D 9
Create a Scenario Summary for the two options: a Name the first scenario as Option b Use D:D as the changing cells. c Do not change the values in Scenario Values fields. d Click OK e Add another scenario. f Name it Option g Use D:D as the changing cells. h Use the following values for each of the respective fields: i Click OK j Select Option and click the Show Button. k The total hours should be l Select Option and click the Show Button. m The total hours should be Create a Summary worksheet by clicking on the Summary worksheet. Use D:QD for the Results Cells. NOTE, you will need to select D as nonadjacent cell. Use the Ctrl Key for the PC and the Command Key for the MAC to select that field. A worksheet will be created named Scenario Summary.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
