Exam 8: Using Data Tables and Excel Scenarios for What If Analysis

In preparation for executing the command to complete the data table, first select the ____ that will constitute the completed data table.

A scenario can span worksheets.

Before you start creating scenarios, you can name the ____ cells you plan to use in the scenario.

Identify the letter of the choice that best matches the word or phrase with its definition. -Refers to a cell, range of cells, formula, or constant value

Defined names with a global scope can be created for cells and ranges using the Name box in the Formula Bar, and using the ____ command in the Defined Names group on the FORMULAS tab.

Case 8-2 Gabriel created the table above to help him organize financial information on the projected results of increased marketing campaigns for the swimsuit line. A change in marketing expense will change the number of units sold. Please refer to the table above when answering the questions below. -Gabriel wants to edit his scenario. He can change everything below EXCEPT ____.

Income tax expense on income statements for ____ companies and the amount of income tax actually paid are two different numbers.

There is no right answer to the question of whether the effect of income taxes should be considered when performing what-if analysis.

You can use the Scenario ____________________ to perform a what-if analysis with more than two input cells.

Although Excel does not consider case when evaluating cell names, the use of case differences in cell names can make them ____.

You use the Simulation Manager to define and save sets of values as scenarios, and then you view and change them as necessary to produce and compare different results. _________________________

Each ____ in a scenario must be unique within its scope.

The breaking point is the point at which revenue equals expenses. _________________________

A(n) ____________________ data table has two lists of input values and one formula that refers to the two different input cells.

Many companies decide to use the company's ____ tax rate in their what-if analysis.

Case 8-2 Gabriel created the table above to help him organize financial information on the projected results of increased marketing campaigns for the swimsuit line. A change in marketing expense will change the number of units sold. Please refer to the table above when answering the questions below. -Gabriel plans to use the Scenario Manager to add a scenario. He opens the Scenario Manager by clicking the DATA tab on the ribbon, and then clicking the ____.

Use a(n) ____ data table to see how different interest rates affect a loan payment.

You can add a title and borders to make the worksheet more visually appealing and easy to understand.

A data table depends on values and formulas used in a worksheet, and must appear on the same worksheet that contains this data.

Case 8-2 Gabriel created the table above to help him organize financial information on the projected results of increased marketing campaigns for the swimsuit line. A change in marketing expense will change the number of units sold. Please refer to the table above when answering the questions below. -Gabriel considers whether the average salary input item should be a changing cell. Although the average salary will change to $39,100 next year, it will not vary from that number for any of the five scenario options. Why would you recommend NOT making salary a changing cell?