$1)$

Match each term in the second column with its correct definition in the first column by writing the letter of the term on the blank line in front of the correct definition.

A sequence of averages computed from parts of a data series that smoothes fluctuations in data to show a trend more clearly.$$Variable expensesAdd$-$insForecastBreak$-$evenMoving averageScenarioNested functionScenario ManagerSolverSUMIFWhat$-$if analysisFixed expensesDecision variablesObjective cellInterval

In a moving average, the number of cells to include in the average.$$Variable expensesAdd$-$insForecastBreak$-$evenMoving averageScenarioNested functionScenario ManagerSolverSUMIFWhat$-$if analysisFixed expensesDecision variablesObjective cellInterval

Expenses that remain the same each month.$$Variable expensesAdd$-$insForecastBreak$-$evenMoving averageScenarioNested functionScenario ManagerSolverSUMIFWhat$-$if analysisFixed expensesDecision variablesObjective cellInterval

A point at which an entity covers its costs and starts to make a profit.$$Variable expensesAdd$-$insForecastBreak$-$evenMoving averageScenarioNested functionScenario ManagerSolverSUMIFWhat$-$if analysisFixed expensesDecision variablesObjective cellInterval

A what$-$if analysis tool that can help you find an optimal value for a formula in one cell$$subject to constraints on the values of other formula cells on a worksheet.$$Variable expensesAdd$-$insForecastBreak$-$evenMoving averageScenarioNested functionScenario ManagerSolverSUMIFWhat$-$if analysisFixed expensesDecision variablesObjective cellInterval

In Solver, a cell that contains a formula for the results you are trying to determine, usually defined as a minimum, a maximum, or a specified value.$$Variable expensesAdd$-$insForecastBreak$-$evenMoving averageScenarioNested functionScenario ManagerSolverSUMIFWhat$-$if analysisFixed expensesDecision variablesObjective cellInterval

In Solver, cells that will change to achieve a desired result.$$Variable expensesAdd$-$insForecastBreak$-$evenMoving averageScenarioNested functionScenario ManagerSolverSUMIFWhat$-$if analysisFixed expensesDecision variablesObjective cellInterval

Expenses that vary depending upon the amount of sales.$$Variable expensesAdd$-$insForecastBreak$-$evenMoving averageScenarioNested functionScenario ManagerSolverSUMIFWhat$-$if analysisFixed expensesDecision variablesObjective cellInterval

Optional commands and features that are not immediately available and must be installed or activated to use.$$Variable expensesAdd$-$insForecastBreak$-$evenMoving averageScenarioNested functionScenario ManagerSolverSUMIFWhat$-$if analysisFixed expensesDecision variablesObjective cellInterval

A what$-$if analysis tool that compares alternatives.$$Variable expensesAdd$-$insForecastBreak$-$evenMoving averageScenarioNested functionScenario ManagerSolverSUMIFWhat$-$if analysisFixed expensesDecision variablesObjective cellInterval

A set of values that Excel saves and can substitute automatically in your worksheet.$$Variable expensesAdd$-$insForecastBreak$-$evenMoving averageScenarioNested functionScenario ManagerSolverSUMIFWhat$-$if analysisFixed expensesDecision variablesObjective cellInterval

A prediction of the future, often based on past performances.$$Variable expensesAdd$-$insForecastBreak$-$evenMoving averageScenarioNested functionScenario ManagerSolverSUMIFWhat$-$if analysisFixed expensesDecision variablesObjective cellInterval

The general process of changing values in cells to see the effect on formulas in other cells.$$Variable expensesAdd$-$insForecastBreak$-$evenMoving averageScenarioNested functionScenario ManagerSolverSUMIFWhat$-$if analysisFixed expensesDecision variablesObjective cellInterval

A function that adds values in a specified range that meet certain conditions or criteria.$$Variable expensesAdd$-$insForecastBreak$-$evenMoving averageScenarioNested functionScenario ManagerSolverSUMIFWhat$-$if analysisFixed expensesDecision variablesObjective cellInterval

A function that is contained inside another function.$$Variable expensesAdd$-$insForecastBreak$-$evenMoving averageScenarioNested functionScenario ManagerSolverSUMIFWhat$-$if analysisFixed expensesDecision variablesObjective cellInterval