Excel Basic Terminology

1234567891011121314151617181920212223242526
Across
  1. 4. A function that changes the contents of a cell to currency and adds a dollar sign and 2 decimal places.
  2. 5. A function that allows the user to change the value of the cell to a percent by multiplying it by 100.
  3. 7. Tells you the exact location of a specific cell noting the intersection of the column and row that forms it.
  4. 10. Displays the cell reference which is the location of the active cell in the worksheet. Located on the left side of the formula bar.
  5. 11. A spreadsheet application tool that analyzes data in a table format using formulas.
  6. 14. A function that allows the user to increase decimal places of a number typed in a cell.
  7. 16. Entry point of a worksheet; a highlighted cell is indicated by a dark border.
  8. 17. Collection of related worksheets in Excel.
  9. 18. The cell in the spreadsheet where information will be placed; the cell that has been selected.
  10. 20. Horizontal group of cells named with numbers.
  11. 22. The tool bar that shows the text or equation assigned to cells.
  12. 24. Labels located at the bottom of the workbook window indicating the worksheets.
  13. 26. An equation that begins with an equal sign.
Down
  1. 1. The small square located in the lower right hand corner of an active cell.
  2. 2. A function allowing the user to select a number of cells to create one large cell with the information centered within the large cell.
  3. 3. Selected group of cells on a worksheet identified by the cell in the upper left corner and the cell in the lower right corner. (A3:C5)
  4. 6. A function that puts records in a specific order.
  5. 8. Grid of rows and columns containing numbers, text, and formulas for the purpose of solving problems involving numbers.
  6. 9. A function that allows the user to decrease decimal places of a number typed in a cell.
  7. 12. A mathematical formula typed into a cell.
  8. 13. A graphic that organizes data visually.
  9. 15. A method used to copy data by dragging the fill handle.
  10. 19. The place where information is held in a spreadsheet.
  11. 21. Computerized spreadsheet in Excel.
  12. 23. A function that automatically adds selected cells.
  13. 25. Vertical spaces headed with letters.