Term | Definition |
Spreadsheet | ~Document in which data is arranged in rows and columns of a grid.
~Can be manipulated and used in calculations. |
Workbook | ~Workbook is the MS Excel file in which you enter and store related data. |
Worksheet | ~Worksheet (also known as a spreadsheet) is a collection of cells on a single "sheet".
~where you actually keep and manipulate the data. |
Workbook window | ~Window where it displays the spreadsheet/worksheet in a workbook |
Cell | ~Individual cells are usually identified by a column letter and a row
~A spreadsheet cell is analogous to a field in database management systems. |
Sheet tab | ~The sheet tabs at the bottom of the window show |
Active Worksheet | ~An active worksheet is the worksheet that is currently open. |
workspace | ~A workspace in Excel is a file that memorizes the current layout of all open windows and workbooks. |
Columns | ~A column is a vertical series of cells in a chart, table, or spreadsheet. |
Rows | ~A row is the range of cells that go across (horizontal) the spreadsheet/worksheet. |
Headings | ~In Excel and other spreadsheet applications, the column header is the colored row of letters used to identify each column within the sheet, or workbook. |
Cell Reference | ~A cell reference refers to a cell or a range of cells on a worksheet and can be used in a formula
~Cell reference to refer to: Data from one cell on the worksheet. |
Name Box | ~ Name Box is the box to the left of the formula bar that displays the cell that is currently selected in the spreadsheet. |
Formula Bar | ~A toolbar at the top of the Microsoft Excel spreadsheet window that you can use to enter or copy an existing formula in to cells or charts. |
Formula | ~Allow you to quickly make calculations and get totals of multiple cells, rows, or columns in a spreadsheet. |
Relative Reference | Relative references change when a formula is copied to another cell |
Absolute Reference | ~Absolute references, on the other hand, remain constant, no matter where they are copied. |
Mixed Reference | A mixed cell reference is either an absolute column and relative row or absolute row and relative column. |
Active Cell | ~An active cell is the selected cell in which data is entered when you begin typing.
It is the cell surrounded by a black border |
Enetr Data | ~Data that is typed into a cell |
Ranger | ~Place or arrange in a row or rows or in a specified order or manner. |
Gridlines | ~Alternatively referred to as a column separator or row separator.
~Gridlines are the light gray lines that divide each of the cells, rows, and columns in a spreadsheet. |