BIS 155 Course Great Wisdom / tutorialrank.com BIS 155 Course Great Wisdom / tutorialrank.com | Page 39

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
two-variable 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.