PITS Part 2

1234567891011121314151617181920212223242526272829
Across
  1. 3. Appears when a formula is incorrect
  2. 8. Cell reference that changes when copied
  3. 10. Removes both data and formatting
  4. 16. Cell reference that stays constant with dollar signs
  5. 18. Tool used to change specific text or numbers
  6. 20. Adds up a range of values
  7. 21. Symbol used to begin every formula in Excel
  8. 23. Removes an entire column from the worksheet
  9. 28. Arranges data in ascending or descending order
  10. 29. Counts the number of cells containing numbers
Down
  1. 1. Automatically fills cells with a series or pattern
  2. 2. Typing numbers or text into cells
  3. 4. Automatically adjusts column width or row height
  4. 5. Keeps selected rows or columns visible while scrolling
  5. 6. Returns the smallest number in a range
  6. 7. Adds a new column to the left of the selected one
  7. 9. Displays only rows that meet certain criteria
  8. 11. Removes an entire row from the worksheet
  9. 12. Group of built-in formulas organized by category
  10. 13. A group of selected cells
  11. 14. Calculates the mean of selected values
  12. 15. Removes data but keeps cell formatting
  13. 17. Highlighting one or more cells for action
  14. 19. Tool used to locate specific text or numbers
  15. 22. Adds a new row above the selected one
  16. 24. Removes selected data and places it in clipboard
  17. 25. Returns the largest number in a range
  18. 26. A mathematical expression used for calculations
  19. 27. Inserts copied data into selected cells
  20. 29. Duplicates selected data to clipboard