Term

Definition

Array arguments

Set of values on which Array formulas act

Array formula

A formula that perform multiple calculation on one or more sets of values and then return either a single value or multiple values

Break-even analysis

Another name for CVP analysis

Break-even point

The point where revenue equals expenses

Column input cell

The cell on which values placed in the first column of the data table are based

Cost-Volume-profit (CVP) analysis

A process that expresses the relationship between a company’s expenses, its volume of business, and the resulting profit

Data table

A way of organizing and displaying the results of multiple what-if analyses

Fixed expenses

Expenses that must be paid regardless of the number of customers

Input cells

The cells containing values you want to modify in a what-if analysis

Input values

The values that will serve as input in the data table

Mixed expenses

Expenses that are part variable and part fixed.

One-variable data table

A table where you can specify one input cell and any number of result cells

Profit

When the income is greater than the expenses

Result cells

The cells containing the values that you want to examine

Result values

The values that indicate the results in the data table

Row input cell

The cell on which you base values placed in the first row of the data table

Scenario

A set of values entered into a worksheet that describes different situations

Scenario Summary Report

A useful tool for those making business decisions based on scenario results

Two-variable data table

A table where you can specify two input cells and only the value of a single result cell is displayed.

Variable expenses

Expenses that change in proportion to the amount of business a company does

What-if analysis

The ability  to investigate different possibilities