Page 20 - Code & Click - 8

3. Click the Add button.
The Edit Scenario dialog box opens.
4. Type “Increment 5%” in the Scenario name box.

5. Specify the cell range to be calculated in the Changing
cells box.
6. Click the OK button. 7
The Scenario Values dialog box opens.
7. Type the formulas in each box as shown in the image. 8

8. Click the Add button.
9. Repeat Steps 4 to 7 to add another scenario with an 10
increment value of 10%.

10. Once all scenarios are added, click the OK button.
A dialog box appears.

11. Click the OK button.
The Scenario Manager dialog box appears.
12. Select a scenario from the Scenarios list and click the Show button.

The worksheet is displayed with values as per the selected
scenario.

12 13

13. Click the Close button to close the Scenario Manager dialog box.

P
Post-Processingost-Processing
 A database is an organised collection of structured information, or data, typically stored
electronically in a computer system.
 You can automatically calculate subtotals and grand totals in a list of data for a column by
using the Subtotal command.
 Data Validation is a feature in Excel which is used to restrict the type of values that can be
entered in a cell and can provide the user with instructions for entering information in a cell.

 Goal Seek is a feature in Excel that determines what value you should enter in an input cell
to get the desired result in a formula cell.
 A Scenario is a set of values that Excel saves and can substitute automatically on your
worksheet.

18