п»їExcel Chapter 8 Test
Match every term together with the correct explanation
A sequence of averages calculated from elements of a data series that smoothes fluctuations in data to show a pattern more evidently. В В
Within a moving common, the number of skin cells to include in the regular. В В
Expenses that remain the same each month. В В
A point from which an organization covers it is costs and starts to make a profit. В В
A what-if analysis instrument that can help you find an maximum value for a formula in a single cellвЂ”subject to constraints within the values of other method cells on the worksheet. В В
In Solver, a cell which contains a solution for the results you are trying to determine, usually defined as a minimum, a maximum, or possibly a specified worth. В В
In Solver, skin cells that will change to achieve a preferred result. В В
Expenses that vary depending upon the amount of revenue. В В
Optional commands and features that are not immediately offered and has to be installed or perhaps activated to use. В В
A what-if analysis instrument that examines alternatives. В В
A set of principles that Surpass saves and may substitute quickly in your worksheet. В В
A conjecture of the future, frequently based on past performances. В В
The general process of changing values in cells to see the effect on formulas in other cells. В В
An event that brings values in a specified range that meet up with certain conditions or requirements. В В
A function that may be contained inside another function. В В
If info is listed in rows but you need to work with it in columns, you should use the Insert option: (1 point)
Paste Values (V).
To create a custom amount format to show off the full identity of each month, use: (1 point)
To ascertain a craze from a widely rising and falling set of numbers, you could compute a: (1 point)
A going average calculates an average to get a group of numbers over a specified: (1 point)
A forecast is a conjecture of the future, often based on:
Examples of adjustable expenses in a restaurant are:
general cost to do business.
food and wages.
The cells in which the values changes to achieve the ideal results in Solver are called: (1 point)
objective skin cells.
Constraints that are used in Solver to limit the results are called: (1 point)
Solver is known as a command in Excel's: