Excel Practice

123456789101112131415161718192021
Across
  1. 1. This is used to arrange data in alphabetical or chronological order
  2. 3. Individual locations on a spreadsheet
  3. 5. Classification indicates that the data has the potenetial to be used in calculations
  4. 7. This function finds the lowest number in a range of cells
  5. 11. Refers to a group of adjacent cells (ex: A4:A16)
  6. 12. This function determines the average of the range of cells
  7. 14. An arrangement of cells in columns and rows used to organize, analyze, calculate, and report information, usually in numerical form
  8. 16. This function adds the range of cells
  9. 17. Refers to all of the contents in a horizontal range of cells
  10. 18. Allows the user to work in multiple areas of large spreadsheet and focus the view on specific cell ranges while headings can still be seen
  11. 19. A file which contains one or more spreadsheets
  12. 20. Used to fill a column or row with consecutive data
  13. 21. Refers to all of the contents in a vertical range of cells
Down
  1. 2. Doing this to a spreadsheet adds a descriptive identifier to the spreadsheet tab
  2. 4. Classification used for cells that contain text or for numbers that will not be used in calculations
  3. 6. When this symbol is keyed in a cell, the software knows that the data will be used in calculation
  4. 8. Calculations are performed according to this order
  5. 9. This function finds the highest number in the range of cells
  6. 10. This is used to combine two or more cells
  7. 13. This button is used for long text within a cell so that it all fits in view on multi-lines
  8. 15. Cell value remains static when copied to other locations