Sensitivity table in Excel

A sensitivity table recalculates a model's output across a grid of input values, so one cell holds the result for every combination in the grid.

A data table can be built with What-If Analysis, Data Table, and it recalculates whenever the model does, which is why a large one slows a workbook down.

The review question is whether the table still covers the range the model now uses, since an input added later often falls outside the grid.

More definitions

Twenty-five terms a reviewer needs, each in one sentence followed by the context that matters.