Excel Exercise: The One-Input Data Table

When you execute the Data Table command, Excel then iterates through a process of executing each formula you’ve identified, substituting in each formula each one of the values you’ve identified for the key input variables, and recording how the value changes change the results of the formulas. ................
................