Excel Terminology

12345678910111213141516171819
Across
  1. 3. Heading/ Letter that identifies each column (column A, B, C, etc.)
  2. 4. Function Box/located immediately to the left of the Formula Bar, it allows you to insert common functions (sum, product, average, etc.)
  3. 6. Excel opens a new workbook with three ___________. ____________ are called Sheet 1, Sheet 2, and Sheet3
  4. 8. The horizontal and vertical lines on the worksheet that make it easier to see and identify each cell in the worksheet.
  5. 9. Box/ Located above Column A, it contains the cell reference of the active cell
  6. 11. Excel includes pre-written formulas called functions to help you quickly include calculations in your spreadsheet. Examples: SUM, PMT, PRODUCT
  7. 12. Heading/ Number that identifies each row (row 6, 7, 8, etc.)
  8. 14. Tab/ Contains the name of the worksheet - it is located at the bottom of the workbook.
  9. 16. Bar/ As you type in a cell, Excel displays the entry in the __________ You can use the ________ to edit data or text in a cell.
  10. 17. Contains buttons and menus that allow you to perform tasks quickly.
  11. 18. Two or more cells on a sheet. The cells in a _______ can be adjacent or nonadjacent.
  12. 19. A line bordering the chart plot area used as a frame of reference for measurement.
Down
  1. 1. Cell/ The selected cell in which data is entered when you begin typing.
  2. 2. Function/ Calculates the payment for a loan based on the number of payments and the interest rate.
  3. 5. A document that helps you organize data in rows and columns of cells.
  4. 7. Reference/ Each cell has a unique address that identifies it, the coordinates of the intersection of a column and a row.
  5. 10. When Excel starts, it creates a new blank __________, called Book1. The ________ is similar to a notebook with pages. Each excel _______has pages called worksheets.
  6. 11. Does calculations with the numbers in cells.
  7. 13. A box in which you can enter text, a number, or a formula. Individual _______ are defined by a column letter and a row number. For example, C4 identifies the _________ in column C and row 4.
  8. 14. Tip/ When you move the mouse pointer over a button, Excel displays the name of the button below it in a _______
  9. 15. pane/ Window that provides commonly used commands. Its location and small size lets you use these commands while still working on your file.