SBS_Lab6_Step3 - Click OK. C. Add a heading that explains...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
elect the area that includes all of the variable labels 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 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 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, select Number. Select Custom and then type in “Fees”.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 4
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 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 Janes target goal. Your data table should now look something like this:...
View Full Document

This note was uploaded on 08/27/2011 for the course BUSSINESS BIS155 taught by Professor Foster during the Winter '11 term at DeVry Federal Way.

Page1 / 4

SBS_Lab6_Step3 - Click OK. C. Add a heading that explains...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online