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.
Search JabSto ::




Custom Search