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

Before printing a scenario report, you indicate which ____ cells are of interest to you.

If a business problem involved three break-even analyses, you could create ____ data table(s) by varying the unit price and sales projection values, but that would involve generating and printing each data table to compare the analyses.

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

Identify the letter of the choice that best matches the word or phrase with its definition. -Contain formulas that involve the input cells in their calculations

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

To open the Data Table dialog box, click the DATA tab on the ribbon, click the ____ Analysis button in the Data Tools group, and then click the Data Table command.

The Scenario Manager refers to output cells as ____________________ cells.

All defined names have a(n) ____________________, which specifies the location in which the name is valid.

Data tables can be used to give you ____.

To set up a scenario, you create or use a worksheet that contains sets of input cells and no output cells.

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?

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

At its most basic level, what-now analysis involves asking a question about a worksheet, such as: "What if the revenue of the swimwear product line increased by $10,000 per month?" _________________________

To create a two-variable data table, you must first set up a data source file.

____ results are those that are based on realistic but not actual data.

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

You use a(n) one-variable data table to determine how two values affect a single result. _________________________

____________________ results are those that are based on realistic but not actual data.

You are faced with 100 rows of simulated profit data. You know that when using data tables for a simulation, it is helpful to calculate statistics about the data. Do you base your decisions about the data on the profit data or the statistics? What type of statistics would you run?

The Scenario Manager refers to input cells as ____________________ cells.