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. |