need done in 8 hrs

Creating a One-Variable Data Table Lab 6, Step 2 A. Set up your One-Variable Data Table Create headings that describe the data table. Your columns will be labeled Initial Values and then 6 through 15 (number of children) and your rows will be labeled Expenses and Net Income:

Add a heading that explains the data table and shading to match the shading of the original Income Statement:

B. Reference the cells that hold the Result Values you wish to use. These references

will be added to the Initial Values area. Reference the cell that contains Total Expenses (=B32) and the cell that contains Net Income (=B33) :

C. Select the data table area except the descriptive labels. From the Data tab, under

What-If Analysis Tools, select Data Table:

The Data Table dialog box will appear. Select the cell that holds the variable you wish to change. Since the variable is in the first row, enter this in the Row Input Cell area:

Click OK. The data table will be populated with values:

Format the results as currency with no decimals:

D. Apply conditional formatting to show all options that are above Jane’s target goal: