| A | B |
|---|
| Add-ins | Optional commands and features that are not immediately available and must be installed or activated |
| Break-even point | The point at which a company starts to make a profit. |
| Constraint cells | Cells that covtain values that limit or restrict the outcome |
| Constraints | In Solver, valued that limit or restrict the outcome |
| Dual-axis chart | A chart that has one series plotted on a secondary axis. Useful when comparing data series that use different scales or different types of measurements. |
| Decision variables | In Solver, cells that will change to achieve a desired result |
| Forecast | A prediction of the future, often based on past performances. |
| Fixed expenses | Expenses that remain the same each month |
| Integer | A whole number used in mathematical computations |
| Interval | In a moving average, the number of cells to include in the average |
| Logical function | A function that tests for specific conditions. |
| Moving average | Asequence of averages computed from parts of a data series; it is used to smooth out fluctuations in data to show a pattern or trend more clearly |
| Objective cell | In Solver, a cell that conains a formula for the results you are trying to determine; usually difined as minimum, maximum, or specified value |
| Scenario | A set of values that Excel saves and can substitute automatically in your worksheet |
| Scenario Manager | A what-if analysis tool that compares alternatives |
| Solver | A what-if analysis tool that can help you find an optimal value for a formula in one cell-subject to constraints on the values of other formula cells on a worksheet |
| Variable cells | In Solver, cells that will change to achieve a desired result |
| Variable expenses | Expenses that vary depending on the amount of sales |
| AND function | A logical function that can be used to develop compound logical tests using up to 255 arguments. The function returns a result of TRUE if ALL of the conditions are met. |
| COUNTIF function | A logical function that counts the cells that meet specific criteria in a specified range. |
| COUNTIFS function | A logical function that counts the cells that meet specific criteria in multiple ranges. |
| Nested function | A function that is contained inside another function. The inner function is evaluated first and the result becomes the argument for the outer function. |
| NOT function | A logical function that takes only one argument and is used to test one condition. If the condition is true, the function returns the logical opposite false. If the condition is false, true is returned. |
| OR function | A logical function that can be used to develop compound logical tests using up to 255 arguments. The function returns a value of TRUE if ANY of the conditions are met. |
| SUMIF function | A logical function that contains one logic test—it will add values in a specified range that meet certain conditions or criteria. |
| SUMIFS function | A logical function that will add values in multiple ranges that meet multiple criteria. |
| Syntax | The arrangement of the arguments in a function. |
| Transpose | To switch the data in rows and columns. |
