Data Tables (What-If) in Excel - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to create a one-variable data table that uses the input values in column A.

Excel

Select the output cell and enter the formula =[1] before creating the data table.

Drag options to blanks, or click blank then click option'

AB2*C2

BSUM(A2:A10)

CAVERAGE(B2:B10)

DIF(A2>10, 1, 0)

Attempts:

3 left

💡 Hint

Common Mistakes

Using aggregate functions like SUM or AVERAGE instead of the calculation formula.

Entering a formula that does not depend on the input cell.

The formula =B2*C2 calculates the output based on input values, which is necessary before creating a one-variable data table.

2fill in blank

medium

Complete the step to set up a two-variable data table with row input cell in B1 and column input cell in A2.

Excel

After selecting the data table range, open the Data Table dialog and enter [1] as the Row input cell.

Drag options to blanks, or click blank then click option'

AA1

BB2

CA2

DB1

Attempts:

3 left

💡 Hint

Common Mistakes

Confusing the row input cell with the column input cell.

Selecting a cell outside the input range.

The row input cell should be B1 as it corresponds to the values in the row of the data table.

3fill in blank

hard

Fix the error in the data table setup by choosing the correct column input cell.

Excel

In the Data Table dialog, the Column input cell should be [1] to correctly link the column values.

Drag options to blanks, or click blank then click option'

AB1

BA2

CB2

DA1

Attempts:

3 left

💡 Hint

Common Mistakes

Using the row input cell as the column input cell.

Selecting a cell that does not contain input values.

The column input cell is A2 because it corresponds to the values in the first column of the data table.

4fill in blank

hard

Fill the blank to create a one-variable data table using input values in column A and output formula in B2.

Excel

Select the range including output and input values, then use Data Table with Column input cell [1] (leave Row input cell blank).

Drag options to blanks, or click blank then click option'

AB1

BA2

CA1

DB2

Attempts:

3 left

💡 Hint

Common Mistakes

Filling both input cells when only one is needed.

Using the wrong cell references for input or output.

For a one-variable data table with input values in column A, leave the Row input cell blank, and set the Column input cell to A1 where the original input value is located (the cell referenced by the formula).

5fill in blank

hard

Fill all three blanks to create a two-variable data table with formula in C3, row input cell in B1, and column input cell in A2.

Excel

Select the range including formula and input values, enter formula =[1] in C3, then set Row input cell [2] and Column input cell [3] in Data Table dialog.

Drag options to blanks, or click blank then click option'

AB2*C2

BB1

CA2

DA1

Attempts:

3 left

💡 Hint

Common Mistakes

Mixing up row and column input cells.

Entering the formula in the wrong cell.

The formula =B2*C2 is entered in C3. The row input cell is B1 and the column input cell is A2 to correctly link the data table inputs.