Join Curt Frye for an in-depth discussion in this video Defining a one-variable data table, part of Learning Excel What-If Analysis.
…Some worksheet calculations depend on changing one variable such…as a tax rate to determine a final value.…If you're not sure which tax rate will be in effect for a given period, but you…want to see the range of possible values you will have to pay for a set of rates.…You can create a one variable data table in a worksheet to display those values.…For this movie, I will use the tax rate increase sample workbook,…which you can find in the chapter one folder of your exercise…files archive.…This worksheet calculates the tax that will be due for a…taxable income of $14 million with a base tax rate of 3%.…
Note also in cell E3, I have a value for change.…And that is the amount the tax rate could go up.…And you see the range of possible values here, from F3 to F5.…So for this instance, I'm assuming that the tax rate will go…up by 1, 2, or 3%. The formula in cell G2 finds the tax…amount due by multiplying the taxable income in cell E4 by the…tax rate in cell E5, plus the change which is displayed in cell E3.…
And cell E3 is the one that we're going to change when we create our data table.…
- Explain how to create a scenario in Excel.
- Identify the two input values that should be used to create a two variable data table.
- Recall what the Excel feature Goal Seek is used for.
- Recognize the three things that must be separated from one another to make reading a worksheet with multiple units easier.
- Describe the tools that Excel provides to manipulate data.
- Break down the steps required to recalculate a worksheet's formulas.