Microsoft Office Tutorials and References
In Depth Information
Answers
A one-way vertical data table with the column headers Revenue Per Month,
Expenses, and Profit. The column input cell should be the Manufacturing
Cost per Unit.
n
A two-way data table evaluating the Profit. The column input cell should be
the Manufacturing Cost per Unit and the row input cell should be the Sales
Price per Unit.
n
ANSWERS
1. Type the headers Price/Unit, Revenue, Expenses, and Income in the
rst row of
the table E18:H18. Follow by typing the values 20.00 and 20.50 in cell E20 and
E21. Select these two values and using the AutoFill feature drag the values down
to 24.50.
In cell F19 type
¼
and click on cell C5. It will result in the value
$1,000,000
the revenue. In cell G19 type
¼
and click on cell C19. It will result
¼
in the value $1,140,000
the total expenses. In cell H19 type
and select cell
C20. It will result in the value-$140,000
the operating income.
Select the entire table E19:H29. From the Data ribbon, click on the drop-
down menu of the What-If Analysis and choose Data Table. See
gure below. (In
Excel 2003 choose Data
.
Data Table.) In the Data Table menu, select C4 in
the Column Input cell.
 
Search JabSto ::




Custom Search