Term | Definition |
Spreadsheet | An electronic document in which data is arranged in the rows and columns of a grid and can be manipulated and used in calculations. |
Workbook | An Excel file that contains one or more worksheets |
Workbook window | The program window that is currently being worked on. |
Cell | A spreadsheet cell is analogous to a field in database management systems. Individual cells are usually identified by a column letter and a row number. |
Sheet tab | A sheet tab appears at the bottom of your worksheet. It has the name of the worksheet on it, which can be changed and you can also change its colour. |
Active worksheet | The active sheet is the worksheet you are working on. |
Workspace | Group of Workbooks |
Columns | Colums are a fundamental part of any spreadsheet program such as Excel and Google Spreadsheets. Colums run vertically in a worksheet. |
Rows | Rows run horizontally in an Excel worksheet. Each row is identified by a number in the row header. |
Headings | 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 so that Microsoft Office Excel can find the values or data that you want that formula to calculate. |
Name Box | The Name Box normally displays the cell reference of the active cell. If a name has been defined for a cell or range of cells, the Name Box displays that name if the correct range is selected in the worksheet. |
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 | Self-defined instructions for performing calculations. |
Relative Reference | By default, all cell references are relative references. When copied across multiple cells, they change based on the relative position of rows and columns. For example, if you copy the formula =A1+B1 from row 1 to row 2, the formula will become =A2+B2. |
Absolute Reference | Absolute references 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 | 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 | The process of entering data into a spreadsheet |
Range | A group or block of cells in a worksheet that have been selected or highlighted. |
Grid lines | Gridlines are the faint lines that appear around cells in Excel. They are used to distinguish cells on the worksheet. |
Individual cells are usually identified by a column letter and a row number. | True |
The selected cell in which data is entered when you begin typing is a Cell Reference. | False |
Absolute references remain constant, no matter where they are copied. | True |
An Excel file that contains one or more worksheets is a Spreadsheet. | False |
A group or block of cells in a worksheet that have been selected or highlighted are Grid lines. | False |
A cell reference refers to a cell or a range of cells on a worksheet. | True |
Range are the faint lines that appear around cells in Excel. | False |
Formulas are self-defined instructions for performing calculations. | True |
The selected cell in which data is entered when you begin typing is an Active Cell. | True |
By default, all cell references are relative references. | True |