click below
click below
Normal Size Small Size show me how
Excel Vocabulary
| Term | Definition |
|---|---|
| Spreadsheet | An application used to store and analyze data. |
| Workbook | An excel file. |
| Worksheet | Sheets in an excel workbook. |
| Workbook Window | The active workbook that is open. |
| Cell | The intersection of a row and column. |
| Sheet Tab | Used to display a worksheet. |
| Active Worksheet | In a spreadsheet program such as Excel or Google Spreadsheets, the active sheet is the worksheet you are working on. |
| Workspace | A file that memorizes the current layout of all open windows and workbooks. |
| Columns | Vertical part of the worksheet grid identified by the letters A to Z and AA to XFD. |
| Rows | Horizontal part of the worksheet grid identified by the numbers 1 to 1,048,576 |
| Headings | Row numbers and column letters. |
| Cell Reference | The column letter and row number that identify a cell such a B3. |
| Name Box | Displays the cell reference of the active cell. Located at the top of the worksheet. |
| Formula Bar | Displays the active cell’s contents. Located above the cells. |
| Formula | Mathematical statement used to calculate a value. A formula must always begin with an equals sign. |
| Relative Reference | A cell reference that reflects the row or column it has been copied to. |
| Absolute Reference | A cell reference the remains constant no matter where they are copied. |
| Mixed Reference | A cell reference that is either an absolute column and relative row or absolute row and relative row. |
| Active Cell | The cell displayed with a bold border. Also called the selected cell. |
| Enter Data | Entering data into excel, you can add by selecting a cell and begin typing. |
| Range | Entering data into excel, you can add by selecting a cell and begin typing. |
| Gridlines | Solid lines that mark off the rows and columns in a worksheet. |