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.