A What-If Analysis Data Table is a tool in Microsoft Excel that allows users to experiment with different values to observe the corresponding variation in results. It is part of a suite of commands known as What-If analysis tools. With a Data Table, users can easily vary one or two inputs and perform What-If analysis. There are two types of Data Tables: one-variable and two-variable.

• One-variable Data Tables: These tables allow users to vary one input value and observe the corresponding changes in the output. For example, a user can calculate the future value of an investment with different interest rates.

• Two-variable Data Tables: These tables allow users to vary two input values and observe the corresponding changes in the output. For example, a user can vary different loan amounts and interest rates to calculate the affordable amount on a home mortgage loan.

To create a Data Table, users need to select the cells containing the formula, values, and expected outputs. Then, they need to go to the Data tab, click the What-If Analysis drop-down arrow, and pick "Data Table". In the Data Table box that opens, users need to enter the cell reference for the changing variable and per their setup.

It is important to note that a Data Table cannot accommodate more than two variables. If users want to analyze more than two variables, they should instead use scenarios.