1. One-Variable Data Table

A.) You would like to evaluate growth rates between 1.00% and 3.00%. Interpolate the data to fill in the cells A26:A32. These percentages represent possible overall growth rates to replace the current value in cell H4. Your goal is to explore various growth rates using a constant amount of increase from 1% to 3%, rather than a constant percentage increase.

B.) Set up your one-variable data table by creating a reference to the four-year revenue forecast in cell B24. Make the number bold.

C.) Create a data table that shows revenues if the overall growth rate is set to the percentages shown in cells A25:A33. Format the results to improve readability.

D.) Use Conditional Formatting to highlight the Overall Growth Rate AND the corresponding Revenue Forecast on your one-variable data table, dependent on what is entered into cell H4. For instance, if you enter 3.00% in cell H4, cells A33 and B33 should be highlighted.