Microsoft Office Tutorials and References
In Depth Information
2. Create the table shown in the
gure above. Type or copy and paste the Units
Sold from 10,000 to 100,000 with increments of 10,000. Type or copy and paste
the Unit Price along the top row of the table. In the intersection cell K3, type
140,000, the net operation income.
3. Select the table K3:U13. From the Data Ribbon click on the drop-down menu of
the What-If Analysis and choose Data Table. See
and click on cell C20. It will result in
gure below. (In Excel 2003
Data Table.) In the Data Table menu, select C4 in the Row
Input cell and C3 in the Column Input cell. See
gure below. The result is shown
gure of the question.