SBS_Lab6_Step2 - C. Select the data table area except the...

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

View Full Document Right Arrow Icon
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) :
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
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: C. Select the data table area except the descriptive labels. From the Data Tab, 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 Janes target goal:...
View Full Document

Page1 / 2

SBS_Lab6_Step2 - C. Select the data table area except the...

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

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