Microsoft Office Tutorials and References
In Depth Information
Analyzing data by using data tables
TIP You can’t edit the formulas Excel creates when you define a data table. You can only
change them successfully by creating another data table that includes the same cells.
In this exercise, you’ll create one-variable and two-variable data tables.
SET UP You need the RateProjections workbook located in the Chapter08 practice file
folder to complete this exercise. Open the workbook, and then follow the steps.
1
If necessary, click the RateIncreases sheet tab to display that worksheet.
2
Select cells C2:D5 .
3
On the Data tab, in the Data Tools group, click the What-If Analysis button and
then, in the list, click Data Table .
4
In the Column input cell box, enter B3 .
5
Click OK to close the Data Table dialog box and ill the what-if values into cells
D3:D5 .
6
Click the RateAndVolume sheet tab to display that worksheet.
7
Select cells C2:E5 .
8
On the Data tab, in the Data Tools group, click the What-If Analysis button and
then, in the list, click Data Table .
8
9
In the Row input cell box, enter B4 .
10
In the Column input cell box, enter B3 .
11
Click OK to close the Data Table dialog box and update your worksheet.
CLEAN UP Close the RateProjections workbook, saving your changes if you want to.
Search JabSto ::




Custom Search