| Array formula | Special formula in a data table that is part of an interrelated group of formulas.
|
 |
|
|
| Break-even | Profit is zero.
|
|
|
|
| Changing cells | The cells defined in a scenario that contain values you want Excel to change.
|
|
|
|
| Contribution margin | The amount remaining from revenue after deducting all variable costs.
|
|
|
|
| Cost-Volume-Profit (CVP) analysis | Examines the relationship between a product's expenses (cost), the number of units of the product produced (volume), revenue, and profit.
|
|
|
|
| Data table | Summarized key input and output cell values of multiple what-if analyses in a single, rectangular cell range.
|
|
|
|
| Fixed cost | A cost that remains constant no matter how many or how few goods or services you manufacture and sell.
|
|
|
|
| Input cell | The key input variable that you want Excel to change in a one- or two-variable data table analysis.
|
|
|
|
| Input values | The set of possible input values substituted into the input cell.
|
|
|
|
| Result cell | Holds the result that is affected by a change in the input cell.
|
|
|
|
| Result values | The computed answer for each input value in a one-variable data table.
|
|
|
|
| Revenue | Money or items of value a company receives during a given period.
|
|
|
|
| Scenario | The combination of values assigned to one or more variable cells in a what-if analysis.
|
|
|
|
| Scenario management | The process of examining individual variables or changing cells and assigning a range of values to them.
|
|
|
|
| Scenario summary | Outlines each scenario by displaying changing cells and result cells in a separate worksheet.
|
|
|
|
| Two-variable data table | Computes the effects of two variables on a single formula.
|
|
|
|
| Variables | Cells in which Excel substitutes different values.
|