need done in 8 hrs

Creating a Two-Variable Data Table Lab 6, Step 3 A. Set up your Two-Variable Data Table Create headings that describe the data table. Your columns (row input cells) will be labeled 6 through 15 (number of children):

You can copy and paste the row headings from your one-variable data table. Create row labels (column input cells) that range from 35 – 75 in $5 increments:

B. Create your Results cell in the upper left corner of the data table. This cell will

reference your Net Income (B33).

Change the Format of this cell to read Fees. Right-click on the Result Cell, select Format Cells. In the Format Cells dialog box, click the Number tab, select Custom, and then type in “Fees” with quotes into the Type textbox. Click OK.

C. Add a heading that explains the data table and shading to match the shading of the

original Income Statement:

D. Select all of the cells that hold the data table area (without the descriptive heading).

Create your data table using the Data tab, What-If Analysis, Data Table option. Reference the cell that contains the number of children as the Row Input (B6) and Fee as the Column Input (B13):

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

Format the results as currency with no decimals. Apply conditional formatting to show all options that are above Jane’s target goal. Your data table should now look something like this:

Select the area that includes all of the variable labels