Microsoft Office Tutorials and References
In Depth Information
Summarizing Loan Options Using a Data Table
4. Choose Data
Excel displays the Data Table dialog box, as shown in Figure 13-7.
Figure 13-7: The Data Table dialog box.
For the Column Input Cell field, specify the formula cell that corresponds to the input 6. 5.
In this example, the Column Input Cell is B2.
6. Leave the Row Input Cell field empty, and click OK.
Excel inserts an array formula that uses the TABLE function with a single argument.
If you like, you can format the data table. For example, you may want to apply shading
to the row and column headers.
Note that the array formula is not entered into the entire range that you selected in Step 4. The
first column and first row of your selection are not changed.
Creating a two-way data table
A two-way data table shows the results of a single calculation for different values of two input
cells. Figure 13-8 shows the general layout of a two-way data table.
Figure 13-8: The structure for a two-way data table.