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 1. b. Use D4:D9 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 2. g. Use D4:D9 as the changing cells. h. Use the following values for each of the respective fields: 282373 i. Click OK j. Select Option 1 and click the Show Button. k. The total hours should be 100.50. l. Select Option 2 and click the Show Button. m. The total hours should be 104.502. Create a Summary worksheet by clicking on the Summary worksheet. 3. Use D11:Q11,D16 for the Results Cells. NOTE, you will need to select D16 as non-adjacent cell. Use the Ctrl Key for the PC and the Command Key for the MAC to select that field. 4. 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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!