Excel Practice

1. This is used to arrange data in alphabetical or chronological order
3. Individual locations on a spreadsheet
5. Classification indicates that the data has the potenetial to be used in calculations
7. This function finds the lowest number in a range of cells
11. Refers to a group of adjacent cells (ex: A4:A16)
12. This function determines the average of the range of cells
14. An arrangement of cells in columns and rows used to organize, analyze, calculate, and report information, usually in numerical form
16. This function adds the range of cells
17. Refers to all of the contents in a horizontal range of cells
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
19. A file which contains one or more spreadsheets
20. Used to fill a column or row with consecutive data
21. Refers to all of the contents in a vertical range of cells

2. Doing this to a spreadsheet adds a descriptive identifier to the spreadsheet tab
4. Classification used for cells that contain text or for numbers that will not be used in calculations
6. When this symbol is keyed in a cell, the software knows that the data will be used in calculation
8. Calculations are performed according to this order
9. This function finds the highest number in the range of cells
10. This is used to combine two or more cells
13. This button is used for long text within a cell so that it all fits in view on multi-lines
15. Cell value remains static when copied to other locations