lironmeduel.org

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

Related

Fame and glory Composition

28.08.2019 Ancient civilizations valued fame and wonder as features that would make it through people after their fatalities. In the story of Beowulf, such an example was exhibited when..

Essay Upon Health Mindset

28.08.2019 п»їHealth Psychiatrist by Exito Schmidt 3 rd pd. Overall health psychology is actually a specialty region that concentrates on biological, sociable and mental factors influence health and disease.…..