Across
- 4. used to limit the solution to a set of possible values from the solver
- 6. performs several what-if analyses by specifying one input cell and several result cells
- 7. displays the scenario changing and result values in a PivotTable
- 8. cells that contain values that are used in formulas of a what-if analysis
- 12. values in a data table that come from formulas applied to one or more input values
- 13. input cells that contain values that will be changed to reach an optimal solution
- 14. point where total revenue equals total expenses
- 16. collection of input values used to perform a what-if analysis
Down
- 1. performs several what-if analyses by specifying two input cells and one result cell
- 2. values in a data table that are based on input cells in the worksheet
- 3. enables you to create as many scenarios as you want and switch amoung them to display the results of several what-if analyses within the worksheet
- 5. lists the values for the changing cells and rsule cells under each scenario
- 9. Excel add-in that searches for the optimal solution to a problem involving several variables
- 10. cells that contain the outcome of formulas involving input cells
- 11. combination of different products offered by a company for sale to the consumer
- 15. cell result cell that contains a value to maximize, minimize or set to a specific value