Excel True/False Quiz - Modules 8-9

A two-variable data table lets you view the relationship between two input cells and one result cell.

• True

• False

In the Scenario Manager dialog box, the changing values are the input cells that change in the worksheet to show the effect of the scenario.

• True

• False

One can create a one-variable data table in Excel to test a series of values for a single input cell and see the influence of these values on the result of a related formula.

• True

• False

To create a one-variable data table, you must enter a range of possible input values in a column.

• True

• False

While creating a two-variable data table in Excel, you need to enter two ranges of possible input values, one in a row and another in a column.

• True

• False

To combine the results of four separate scenarios, you create an Answer report.

• True

• False

A scenario is a defined collection of changing cells used to perform a what-if analysis.

• True

• False

If you want to edit the changing values for a scenario, select the cells directly in a spreadsheet.

• True

• False

If you are working with scenarios on one worksheet, you can merge scenarios from other worksheets or workbooks.

• True

• False

When creating a one-variable data table, when you enter the input cell values in the first row of the table, you must enter the formulas referencing result cells in the table's last column of the table.

• True

• False