Excel Chapter 10

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