Introduction -

A data table is a range of cells that shows how changing one or two variables in your formulas will affect the results of those formulas.

Data tables provide a shortcut for calculating multiple results in one operation and a way to view and compare the results of all the different variations together on your worksheet.

Overview -

Data tables are part of a suite of commands that are called what-if analysis tools. When you use data tables, you are doing what-if analysis.