Microsoft Office Tutorials and References

In Depth Information

**Creating a data table**

To convert a table back into a range, select any cell within the table; click the Design tab, and then

click Convert to Range in the Tools group. Excel displays a coni rmation dialog box. ClickYes.

7
Choose File > Save, and then choose File > Close.

Creating a data table

A data table is a range of cells used for testing and analyzing outcomes; it can show you how

changing certain values within a formula can af ect the outcome of the formula. Excel has

two types of data tables: A one-variable data table gauges the eff ect of changing one input

cell within the table. A two-variable data table gauges the eff ect of changing two input

cells within the table. You should not confuse a data table with regular Excel tables that you

learned about in the section, “Converting a range to a table.” A data table is a special range

that Excel uses to calculate multiple solutions to one formula.

In this exercise, you’ll type several values for the interest rate and then determine how the

result l uctuates based on which value you apply to the formula.

To open the i le you need for this lesson:

1

Choose File > Open and navigate to the Excel07lessons folder.

2

Click excel0704 and then click Open.

3

Select File > Save As. Excel displays the Save As dialog box.

4

In the Save As text box, type
excel0704_done
and then click Save.

5

Click cell A8, type
2%
, and then press Enter. Excel displays the value as a percentage.

6

Click each cell beginning with A9 and ending with A13 and type the following values:

,
,
,
, and
.

7

Select cells A7 and B7 and drag down to row 13.

Select the formula and the values.