A ______ is a range of cells that shows the results of substituting different values in one or more formulas.
Answer & explanation
Correct answer: option 2
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