MICROSOFT EXCEL 2016 BASICS

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