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

The SUMIFS function adds values in multiple ranges that meet multiple conditions or criteria.

The curves and directions of lines on a line chart make ________ noticeable to the user.

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

________ expenses remain the same each month regardless of the amount of activity and often include rent,utilities,and insurance.

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

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

A new business often operates at a ________ before becoming profitable.

Match the following five terms to their meanings: i.nested function II.AND function III.NOT function IV.AVERAGEIFS function v.OR function

On a line chart that shows estimated income and expenses,the point where the lines cross each other is the projected break-even point.

Match the following four terms to their meanings: i.Scenario Manager II.scenario III.integer IV.interval

To show trends over time,use a ________ chart.

In Solver,________ are cells in which the values will change to achieve the desired results.

When using Solver,which of the following will NOT be identified during the process?

Solver is located in the ________ group on the Data tab.

You can calculate a break-even point for a product,a branch office,a division,or an entire company.

A forecast is a prediction of the future,often based on past performances.

You must use Scenario Manager to create a scenario.

To show the year using four digits,such as 2016,you would enter ________ for the custom code format.

Rent and wages are the two most common variable expenses.

You can use a moving average to calculate a growth rate at different intervals.