Across
- 1. Tracks Error) error which occurs when the column is not wide enough to display the contents of a cell
- 3. specify the location of a cell in a worksheet by identifying its column letter and row number
- 4. predefined formulas which perform a specific calculation based on the data specified
- 5. tool which can be used to display only data which meets certain criteria
- 7. feature which can be used to recognize a pattern in text and change the format of the text for the series
- 8. error which occurs when the cell reference is not valid
- 9. text or graphics printed at the bottom of each printed page
- 15. selection of cells which are not next to each other
- 16. series of commands and instructions grouped together to accomplish a task automatically
- 19. ability to scroll through multiple spreadsheets at the same time
- 20. table which can be rearranged to analyze data in a variety of ways
- 21. sample files which contain some formatting and can be customized to serve as starting point for a new workbook
- 22. range of cells or a single cell which have been given a descriptive range name to reference it by rather than the cell addresses
- 23. a dot followed by three or four characters at the end of the file name used to show the file type
- 25. point to a specific cell in the worksheet and utilizes dollar signs in the reference name such as $A$1 or $B$2
- 28. tool which applies formatting to cells based upon their content and specified rules
- 29. grids of rows and columns in which text, numbers and the results of calculations can be entered
- 30. are expressions which return values
- 31. contain both relative and absolute cell references such as $A1 or B$2
- 32. chart created based on a PivotTable or data which can be rearranged to illustrate data
Down
- 2. provide the address of a cell based on its relative location in a workbook such as A1 or B2
- 4. format in which a file is stored; typically corresponds to the program used to create the file
- 6. tool which can be used to organize or group data
- 8. error which occurs when a misspelling has occurred in a function name
- 10. feature which finishes an entry based on previous entries made in the column containing the active cell
- 11. feature which fills cells with data which follows a pattern or is based on data in other cells
- 12. files used to store worksheets
- 13. computerized spreadsheets found in Microsoft® Excel
- 14. Tables(Tables) data arranged in columns and formatted with column headers containing commands to sort, filter and perform other functions on the contents
- 17. graphic representations used to compare and contrast worksheet data
- 18. intersection of a column and a row on a worksheet
- 24. key combinations which perform certain commands when pressed
- 26. selection of multiple cells which are next to each other
- 27. text or graphics printed at the top of each printed page