Where are substitute values for the one-variable data table entered?

Where are substitute values for the one-variable data table entered?

• A. Cells E4:E8
• B. Cells E3:E7
• C. Cells E5:E9
• D. Cells F4:F8

Answer: (A)

In a one-variable data table, you’re testing how a single input value affects the result. The values you test—the substitute values—are placed in a single row or a single column next to the table, depending on whether the table is set up horizontally or vertically. For a vertical layout like this, the substitute values form one column adjacent to the table. That arrangement lets Excel substitute each value into the formula’s input and show the corresponding result in the table. If the values were arranged differently, the table wouldn’t align with the formula’s input and the results wouldn’t compute correctly.

In a one-variable data table, you’re testing how a single input value affects the result. The values you test—the substitute values—are placed in a single row or a single column next to the table, depending on whether the table is set up horizontally or vertically. For a vertical layout like this, the substitute values form one column adjacent to the table. That arrangement lets Excel substitute each value into the formula’s input and show the corresponding result in the table. If the values were arranged differently, the table wouldn’t align with the formula’s input and the results wouldn’t compute correctly.