Excel Chapter 8 Test
Excel Chapter 8 Test
1)
Match each term with the correct definition
(15 points)
A sequence of averages computed from parts of a data series that smoothes fluctuations in data to show a trend more clearly.
Moving average
In a moving average, the number of cells to include in the average.
Interval
Expenses that remain the same each month.
Fixed expenses
A point at which an entity covers its costs and starts to make a profit.
Break-even
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.
Solver
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.
Objective cell
In Solver, cells that will change to achieve a desired result.
Decision variables
Expenses that vary depending upon the amount of sales.
Variable expenses
Optional commands and features that are not immediately available and must be installed or activated to use.
Add-ins
A what-if analysis tool that compares alternatives.
Scenario Manager
A set of values that Excel saves and can substitute automatically in your worksheet.
Scenario
A prediction of the future, often based on past performances.
Forecast
The general process of changing values in cells to see the effect on formulas in other cells.
What-if analysis
A function that adds values in a specified range that meet certain conditions or criteria.
SUMIF
A function that is contained inside another function.
Nested function
Score: 15
2)
If data is listed in rows but you need to work with it in columns, you can use the Paste option:
(1 point)
Paste Values (V).
Paste (P).
Transpose (T).
Score:
1)
Match each term with the correct definition
(15 points)
A sequence of averages computed from parts of a data series that smoothes fluctuations in data to show a trend more clearly.
Moving average
In a moving average, the number of cells to include in the average.
Interval
Expenses that remain the same each month.
Fixed expenses
A point at which an entity covers its costs and starts to make a profit.
Break-even
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.
Solver
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.
Objective cell
In Solver, cells that will change to achieve a desired result.
Decision variables
Expenses that vary depending upon the amount of sales.
Variable expenses
Optional commands and features that are not immediately available and must be installed or activated to use.
Add-ins
A what-if analysis tool that compares alternatives.
Scenario Manager
A set of values that Excel saves and can substitute automatically in your worksheet.
Scenario
A prediction of the future, often based on past performances.
Forecast
The general process of changing values in cells to see the effect on formulas in other cells.
What-if analysis
A function that adds values in a specified range that meet certain conditions or criteria.
SUMIF
A function that is contained inside another function.
Nested function
Score: 15
2)
If data is listed in rows but you need to work with it in columns, you can use the Paste option:
(1 point)
Paste Values (V).
Paste (P).
Transpose (T).
Score: