Question: Can I create and save different groups of values on a worksheet and then switch between these values to view the different results?
Answer: Yes, with the SCENARIO MANAGER
Process (Excel 2003, 2007 and 2010):
A scenario is a set of values that Microsoft Office Excel saves and can substitute automatically on your worksheet. You can create and save different groups of values as scenarios on a worksheet and then switch between these scenarios to view the different results.
1. Create the spreadsheet given below
2. Select cell C7 and type =sum(C3:C6) and press enter
3. Select data ,what If analysis ,scenario manager
4. Click on the ADD button
5. Enter the heading, original Budget and highlight from C3:C6 under changing cells.
6. Click ok and enter the following figures in the given order of 30000, 35000, 33000 and 34000.
7. Select OK
8. Click on the ADD button
9. Enter the heading, Forecast Budget and highlight from C3:C6 under changing cells.
10. Click ok and enter the following figures in the given order of 40000, 45000, 46000 and 47000.
11. Click ok
12. To view the Original Budget select original budget and click the show button.
13. To view the Forecast Budget select Forecast budget and click the show button.
