Question: Two - Variable Data Table a ) Next, create a data table with the result in cells F 2 4 :I 3 1 that shows

Two-Variable Data Table
a) Next, create a data table with the result in cells F24:I31 that shows Boston Four-Year Total revenues when the overall growth rate and Bostons adjusted growth factor are varied.
b) Use Conditional Formatting to highlight the row, Column and intersection for Overall Growth Rate, the Boston Adjustment Factor AND the corresponding Revenue Forecast on your two-variable data table, dependent on what is entered into cells H4 and H6. For instance, if you enter 2.25% in cell H4 and 1.75 in H6, Row 29 and Column H in your data table should be highlighted.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!