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.
Bookmarks