Spreadsheet Essentials

12345678910111213141516171819202122
Across
  1. 1. located records based upon specific criteria
  2. 2. lines around cells
  3. 7. used to show a trend in data over time
  4. 10. used to identify relationships between categories
  5. 11. function used to add a range of cells
  6. 13. used horizontal bars; shows comparisons among categories
  7. 15. found along the top of Excel; contains commands
  8. 16. allows you to change the backgrounds of cells
  9. 17. combining two or more cells together to form one larger cell
  10. 18. identifies which data series each color represents in a chart
  11. 19. allows you to apply format elements to other cells
  12. 21. series of points that are plotted on a chart or graph
  13. 22. cell reference remains constant regardless of where the formula appears; uses $ to indicate which cell reference should remain constant
Down
  1. 1. must begin with = sign in Excel; tells what calculations are needed
  2. 3. labeled with numbers; run horizontally
  3. 4. intersection of a row and column
  4. 5. used to compare a single category of values as parts of a whole
  5. 6. reorders your records by a field or category
  6. 8. cell reference that changes based on its location
  7. 9. square in the bottom right corner of a cell
  8. 12. labeled with letters; run vertically
  9. 14. uses vertical bars; shows comparisons among categories
  10. 20. grid of data used for a chart