A ______ is a range of cells that shows the results of substituting different values in one or more formulas.

Data Table

The correct answer is Option (2) → Data Table.

A data table is a range of cells that shows the results of substituting different values in one or more formulas.

A data table is a range of cells that shows the results of substituting different values in one or more formulas. There are two types of data table- One-variable and two variable. 

One-variable data table- Formula used in a one-variable data table must refer to an input cell. The input cell is a cell used by Excel in which each input value from a data table is substituted (column-oriented, i.e. input cell down one column or row-oriented, i.e. across one-row).

Two-variable data table use only one formula with two lists of input values. The formula must refer two different input cells