When creating a one-variable data table with substitution values in a horizontal row,the formula reference must be on the row below and one column to the left of the first substitution value.

Question

Quizplus · Accepted Answer

This is true. When creating a one-variable data table in Excel, the formula reference should be in the cell directly below and one column to the left of the first substitution value. This allows Excel to use that reference to calculate the results for each substitution value in the table.

When Creating a One-Variable Data Table with Substitution Values in a Horizontal