A | B |
Absolute cell reference | Cell refrence that does not adjust to the new cell location when copied or moved. |
AutoFormat | Predefined set of formatting options that have been named and saved. |
Cell | Intersection of a row and column in a worksheet or table. |
Column | Appear vertically in a worksheet and are identified by letters at the top of the worksheet window. |
Filling | Copies data into the cell(s) adjacent to the original. |
Formula bar | Appears directly below the toolbar in the worksheet; displays a formula when the cell of a worksheet contains a calculated value. |
Formulas | Equation that calculates a new value from values currently on a worksheet. |
Freezing | Keeps row or column titles on the screen no matter where you scroll the worksheet. |
Highlight | Entry point of a worksheet; a highlighted cell is indicated by a dark border. |
Name box | Area on the left side of the formula bar that identifies the cell refrence of the active cell. |
Operand | Numbers or cell refrences used in calculations in the formulas of worksheets. |
Operator | Tells Excel what to do with operands in a formula. |
Order of evaluation | The sequence used to calculate the value of a formula |
Range | Selected group of cells on a worksheet identified by the cell in the upper left corner and the cell in the lower right corner, separated by a colon (for example, A3: C5:). |
Relative cell refrence | Cell refrence that adjusts to a new location when copied or moved. |
Rotated text | Displays text at an angle within a cell of a worksheet. |
Row | Appear horizontally in a worksheet and are identified by numbers on the left side of the worksheet window. |
Style | Collection of font, patterns, and alignments that can be applied to a range of data. |
Workbook | Collection of related worksheets in Excel. |
Worksheet | Computerised spreadsheet in Excel; a grid of fows and columns containing numbers, text, and formulas. |
Wrapped text | Begins with a new line within the cell of a worksheet when the data exceeds the width of a column. |
Active Cell | Highlighted cell ready for data entry. |
Indented text | Moves the text several spaces to the right. |
Mixed cell refrence | Cell refrence containing both relative and absolute refrences. |
Point-and-click method | Constructs a cell formula in Excel by clicking on the cell you want to refrence rather than keying the refrence. |
Splitting | Divides the screen into two or for parts so that more than one area of the worksheet may be viewed at the same time. |
Spreadsheet | Grid of rows and columns containing numbers, text, and formulas; the purpose of a spreadsheet is to solve problems that involve numbers. |