Chapter 9
Working with Data Analysis Tools
Create a Data Table
If you want to study the effect that different input values have on a formula, one solution is to set up the worksheet model and then manually change the formula’s input cells. For example, if you are calculating a loan payment, you can enter different interest rate values to see how this affects the payment.
The problem with this method is that you see only a single result at one time. A better solution is to set up a data table, which is a range that consists of the formula you are using and multiple input values for that formula. Excel automatically creates a solution to the formula for each different input value.
Create a Data Table
Type the input values:
To enter the values ...
