Data Tables (What-If) in Excel - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is a Data Table in Excel's What-If Analysis?

A Data Table lets you see how changing one or two input values affects the result of a formula. It helps you explore different scenarios quickly.

beginner

How many input variables can a one-variable Data Table analyze?

A one-variable Data Table analyzes how changing one input value affects the formula result.

intermediate

What is the difference between a one-variable and a two-variable Data Table?

A one-variable Data Table changes one input to see its effect. A two-variable Data Table changes two inputs at the same time to see how both affect the result.

beginner

Where do you place the formula when creating a Data Table?

You place the formula in the top-left cell of the Data Table range, just above or beside the input values.

beginner

Why should you use Data Tables instead of manually changing inputs one by one?

Data Tables automatically calculate and show many results at once, saving time and reducing errors compared to changing inputs manually.

What does a one-variable Data Table in Excel analyze?

A Effect of changing one input on a formula

B Effect of changing two inputs on a formula

C Effect of changing all inputs on a formula

D Effect of changing no inputs

A one-variable Data Table changes one input value to see how it affects the formula result.

Where should the formula be placed when creating a Data Table?

A In the bottom-right cell of the Data Table range

B Anywhere in the worksheet

C In the top-left cell of the Data Table range

D Outside the Data Table range

The formula must be in the top-left cell of the Data Table range to link inputs and outputs correctly.

Which Excel feature do you use to create a Data Table for What-If Analysis?

A Pivot Table

B Data Validation

C Conditional Formatting

D What-If Analysis > Data Table

Data Tables are created using the What-If Analysis menu under Data > What-If Analysis > Data Table.

What is the main benefit of using a two-variable Data Table?

A It shows how two inputs affect a formula result together

B It changes one input value

C It formats data automatically

D It creates charts

A two-variable Data Table shows how changing two inputs at the same time affects the formula result.

If you want to see how different interest rates affect loan payments, which tool should you use?

A Sort

B Data Table

C Filter

D Goal Seek

Data Tables let you quickly see how changing interest rates affects loan payments by showing many results at once.

Explain how to set up a one-variable Data Table in Excel step-by-step.

Think about where the formula and inputs go and how Excel knows which input to change.

Describe the difference between one-variable and two-variable Data Tables and when to use each.

Consider how many inputs you want to test at once.