click below
click below
Normal Size Small Size show me how
Excel Vocabulary
| Term | Definition |
|---|---|
| Spreadsheet | a piece of paper or computer program used for accounting and recording data using rows and columns into which information can be entered. |
| Workbook | a file in which you enter and store related data. |
| Worksheet | a single spreadsheet that contains cells organized by rows and columns. |
| Workbook Window | the current workbook that is being displayed. |
| Cell | A box formed by the intersection of a row and column in a worksheet or a table, in which you enter information. |
| Sheet Tab | the current worksheet that is being displayed. |
| Active Worksheet | the worksheet you are currently working on. |
| Workspace | a file that saves display information about open workbooks, so that you can later resume work with the same window sizes, print areas, screen magnification, and display settings. |
| Columns | in a worksheet, the vertical spaces with headings A, B, C, and so on. |
| Rows | in a worksheet, the horizontal spaces with the headings 1, 2, 3, and so on. |
| Headings | the identifying letters and numbers for columns and rows. |
| Cell Reference | a string identifying a particular cell in a spreadsheet, possibly relative to the cell containing the reference. |
| Name Box | the box to the left of the formula bar that displays the cell that is currently selected in the spreadsheet. |
| Formula Bar | a command line above the worksheet where text, numbers, and formulas are entered into a worksheet. |
| Formula | a combination of numbers and symbols used to express a calculation |
| Relative Reference | an address or pointer that changes when the target item is moved or the relationship to it has changed |
| Absolute Reference | an address or pointer that does not change |
| Mixed Reference | either an absolute column and relative row or absolute row and relative column. |
| Active Cell | the selected cell in which data is entered when you begin typing. Only one cell is active at a time. The active cell is bounded by a heavy border. |
| Enter Data | entering numbers and dates in Microsoft Excel worksheets. |
| Range | a group or block of cells in a worksheet that have been selected or highlighted. |
| Gridlines | divide each of the cells, rows, and columns in a spreadsheet. |