Excel Chapter eight Test
п»їExcel Chapter 8 Test
1)
Match every term together with the correct explanation
(15 points)
A sequence of averages calculated from elements of a data series that smoothes fluctuations in data to show a pattern more evidently. В В
Going average
Within a moving common, the number of skin cells to include in the regular. В В
Span
Expenses that remain the same each month. В В
Fixed expenditures
A point from which an organization covers it is costs and starts to make a profit. В В
Break-even
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. В В
Solver
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. В В
Aim cell
In Solver, skin cells that will change to achieve a preferred result. В В
Decision variables
Expenses that vary depending upon the amount of revenue. В В
Varying expenses
Optional commands and features that are not immediately offered and has to be installed or perhaps activated to use. В В
Add-ins
A what-if analysis instrument that examines alternatives. В В
Scenario Administrator
A set of principles that Surpass saves and may substitute quickly in your worksheet. В В
Scenario
A conjecture of the future, frequently 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
An event that brings values in a specified range that meet up with certain conditions or requirements. В В
SUMIF
A function that may be contained inside another function. В В
Nested function
Score:
15
2)
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).
Paste (P).
Transpose (T).
Score:
you
3)
To create a custom amount format to show off the full identity of each month, use: (1 point)
mmm.
mm.
mmmm.
Score:
one particular
4)
To ascertain a craze from a widely rising and falling set of numbers, you could compute a: (1 point)
break-even point.
shifting average.
moving target.
Score:
1
5)
A going average calculates an average to get a group of numbers over a specified: (1 point)
target.
time period.
variable.
Score:
1
6)
A forecast is a conjecture of the future, often based on:
(1 point)
future performances.
current performances.
previous performances.
Rating:
1
7)
Examples of adjustable expenses in a restaurant are:
(1 point)
general cost to do business.
food and wages.
hire.
Score:
you
8)
The cells in which the values changes to achieve the ideal results in Solver are called: (1 point)
constraints.
objective skin cells.
variable cells.
Score:
one particular
9)
Constraints that are used in Solver to limit the results are called: (1 point)
variables.
filtration systems.
constraints.
Rating:
1
10)
Solver is known as a command in Excel's:
(1 point)
Formulas group.
Analysis group.
Auditing group.
...
28.08.2019
