Exam 8: Excell: Using the Data Analysis, Solver, and Scenario Features, and Building Complex Formulas

You can create a scenario from the Solver dialog box,or you can open the Scenario Manager dialog box and create a scenario.

The break-even point is reached when ________.

________ can help determine values that result in maximum or minimum value for a formula in one cell.

To determine a 10% growth rate over a previous month sales,you would take the previous month's sales and ________.

A function that is contained inside another function,the results of which become the argument for the outer function is called ________.

After creating several scenarios,you can create a Scenario ________,which compares all options side-by-side.

________ are elective commands and features that are NOT immediately available that must be installed within Excel before you can use them.

In a moving average,the number range that is averaged is constantly changing,dropping off the first number and adding on the most ________ number.

A scenario is a set of values that Excel saves and can substitute automatically in your worksheet.

Which of the following would NOT be considered a fixed expense?

Decision variables are also referred to as variable cells.

In the ________ you can choose between a Scenario summary,which displays the data in a table,or a Scenario PivotTable report.

When you use Solver,your worksheet will include ________ cells that contain values that limit or restrict the outcome.

Income for a business generally consists of the ________ of products and services.

A line chart is useful for showing trends over time.

A set of values that Excel saves and can substitute automatically in your worksheet is ________.