Assignment 9
input variables and see the results. 4. Create the Data Table For a One-Variable Table : Select the range of cells, including the sales, product and the cell with the formula. Go to the Data tab. Under the What-If Analysis group, click on Data Table . In the Data Table dialog box: For Row Input Cell , leave it blank (since we are changing the values in the column). For Column Input Cell , select the cell that contains the sales. 5. View Results After you click OK , Excel will calculate the results and fill in the data table. You can now see how the 3 month sales change for each combination of product and cost.