Microsoft Office Tutorials and References
In Depth Information
Create a Data Table
Create a
Data Table
If you are interested in studying the effect a range
of values has on the formula, you can set up a data
table . This is a table 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.
Do not confuse data tables with the Excel tables that
you learned about in Chapter 10. A data table is a
special range that Excel uses to calculate multiple
solutions to a formula.
Create a Data Table
1 Type the input values:
To enter the values in a column,
start the column one cell down
and one cell to the left of the
cell containing the formula, as
shown here.
To enter the values in a row,
start the row one cell up and
one cell to the right of the cell
containing the formula.
2 Select the range that includes
the input values and the
formula.
3 Click the Data tab.
4 Click What-If Analysis (
).
5 Click Data Table .
Search JabSto ::




Custom Search