Excel Chapter 8 Week 11

1234567891011121314151617
Across
  1. 7. in solver cell that will change to achieve the desired results
  2. 8. in solver, a condition or restriction that must be met
  3. 11. expense that varies depending on the amount of sales
  4. 12. specify multiple criteria when computing an average
  5. 15. a prediction of the future
  6. 16. point which a company starts to make a profit
  7. 17. Optional command or feature that is not immediately available
Down
  1. 1. a chart that has one series plotted on a secondary axis
  2. 2. function that counts the cells that meet specific criteria in a range
  3. 3. a whole number
  4. 4. expense that remains the same each month regardless of the amount of activity
  5. 5. a set of values that Excel saves and can substitute automatically in your worksheet
  6. 6. function returns a value of TRUE if ANY of the conditions are met
  7. 9. a function that is contained inside another function
  8. 10. to switch the data in rows and columns
  9. 13. the number of cells to include in a moving average
  10. 14. a sequence of averages computed from parts of a data series