than six children . Because you are varying only one of your assumptions , you can develop a one-variable data table . A onevariable data table will allow you to see the impact of changing one variable — and see the results on multiple outputs . A . Set up the Data Table to display number of children from 6 through 15 . Add a descriptive title to the Data Table . B . Show the Expenses and Net Income for each change in number of children . C . Populate the Data Table using the Data tab , What-If analysis , Data Table tool . D . Apply Conditional Formatting to Net Income that is above $ 75,000 . Your final Data Table should look something like this . STEP 3 : Analyze the Difference in Net Income When You Vary the Number of Students and the Charge Per Student Adair also wishes to look at the impact on Net Income when she varies the number of students and the charge per student . Use a twovariable data table to analyze . A . Set up the Data Table to display number of children as the row input ( 6 – 15 ) and charge per student ( 35 – 75 in $ 5 increments ) as the column input . NOTE : In a Data Table , the information in the top row of the table is called the row input and the information in the first column of the table is called the column input . We usually think of the top row in Excel as a column header and the labels in the first column as row labels , so this may seem a bit confusing . Just remember , in a Data Table , the top row is row input ; first column is column input . B . Enter Net Income in the result cell , and format this cell to display no data . C . Add a descriptive heading . D . Create the data table and apply conditional formatting to Net Income values over $ 75,000 . Your Data Table will look something like this . STEP 4 : Create Scenarios and a Scenario Summary Adair wants to look at three scenarios . Be sure to save each scenario with a unique name , and place the name of the scenario on the sheet ,