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

Solver is one of Excel's ________ tools.

When calculating a ________,the number range that is averaged is constantly changing-dropping off the first number in the range and adding on the most recent number.

A logical function that adds the values in cells that meet specific criteria in multiple ranges.

________ functions,for example AND and NOT,test for specific conditions.

In a chart,a moving average events out the ________ in data,thus showing a pattern or trend more clearly.

A moving average is a ________ of averages computed from parts of a data series.

When using Solver,the ________ cell is the cell that contains a formula for the results you are trying to achieve.

Solver enables you to add a maximum of three constraints using the Solver Parameters dialog box.

The ________ function returns a value of TRUE if ANY of the tested conditions are met.

Like the COUNTIF function,the ________ function counts cells that meet specific criteria in specified ranges.

Use Excel's ________ Manager tool to compare several possible solutions to a problem.

A ________ function occurs when one function is contained inside another function.

Expenses are typically classified as fixed expenses and variable expenses.

The point on a line chart at which the lines showing sales and expenses cross is called the ________ point.

The formula that calculates the gross profit or loss for a month uses ________.

________ expenses fluctuate depending on the amount of sales and wages.

When you choose to add a Scenario summary,Excel inserts a new ________ in your workbook.

Scenario Manager is one of the tools under ________ in the Forecast group on the Data tab.

Match the following five terms to their meanings: i.constraint II.decision variable III.objective cell IV.constraint cell v.variable cell

One of the basic tools to help project future results based on past performance is ________.