Explanation

A Data Table is a What-If Analysis tool that shows how changing one or two input values affects a formula result.

It is useful when you want to compare many possible outcomes without manually changing the input values one by one.

Types of Data Tables

1. One-Variable Data Table
2. Two-Variable Data Table

Example

Suppose a business wants to know how different selling prices affect profit.

A Data Table can calculate all results automatically.

Location

Data → What-If Analysis → Data Table

Practice

Create a simple Profit model and identify the input cell and result cell.