| A | B |
|---|
| active cell | the selected cell displayed wit ha bold outline. Data can only be entered into an active cell |
| adjacent cells | cells that are next to each other |
| boundary | the bar separating the column letters at the top of the worksheet |
| circular reference | an error that occurs when a formula references the cell it is stored in |
| enter key | enters data and then selects the next cell in the column |
| template | a master spreadsheet that includes the basic elements for a particular type of spreadsheet |
| relative cell reference | a cell reference that reflects the row or column it has been copied to |
| gridlines | solid lines that mark off the rows and columns in a worksheet |
| spreadsheet | data displayed in rows and columns |
| column letter | letter at the top of the worksheet used to identify individual columns |
| cell reference | the column letter and row number used to identify a cell such as B3 |
| data | information stored in a spreadsheet; categorized as a label, value or date/time |
| fill handle | the solid square in the lower-right orner of a selected cell trhat is useed t o copy the contents of a cell to adjacent cells |
| formula | mathematical statement used to calculate a value must always begin with an = sign |
| formua bar | area near the top of the worksheet window that displays the contents of the active cell |
| duplicate data | to make a copy of data and then place that copu at a different location in the worksheet |
| order of operations | the rules Excel uses to evaluate a mathematical expression |
| pointing | clicking a cell to place its reference in a formula |
| conditional formatting | formatting that is applied to a cell when a specified condition is met |
| row number | the number down the left side of the worksheet used to identify individual rows |
| value | numeric data that is stored in a cell that can be used in calculations |
| label | text stored in a cell that cannot be used in calculations |
| Ctrl + ` | to display the formulas displayed in cells |
| gridlines and row/column headings | Click File, Page Setup, Sheet tab |
| number signs (####) | the cell is not wide enough to display the formatted number |
| sheet tabs | display the worksheets in a workbook |
| Esc key | cancels data entry and restores the original contents of the cell |
| width of column not wide enough number is... | are displayed in scientific notation |
| new workbook | three worksheets |
| Undo button | can be used to restore the contents of a cell that has been cleared |
