Microsoft Office Tutorials and References
In Depth Information
Create a Data Table
The Data Table dialog box
6 Specify the formula cell you
want to use as the data table’s
If the input values are in a
column, enter the input cell’s
address in the Column Input
Cell text box.
If you entered the input values
in a row, enter the input cell’s
address in the Row Input Cell
7 Click OK.
A Excel displays the results.
What is what-if analysis?
It is perhaps the most basic method for
analyzing worksheet data. With what-if
analysis, you first calculate a formula D, based
on the input from variables A, B, and C. You
then ask, “What happens if I change the value
of variable A?”, “What happens if I change B
or C?”, and so on.
When I try to delete part of the data table, I
get an error. Why?
The data table results are created as an array
formula , which is a special formula that
Excel treats as a unit. This means that you
cannot move or delete part of the results. If
you need to work with the data table results,
you must first select the entire results range.