| A | B |
| absolute reference | a reference to a cell address based on its column and row numbers (uses the "$") |
| average | a built-in formula that adds the values in a cell range and divides the sum by the number of values (count) in the range |
| cell | a single location on a spreadsheet |
| cell address | the location of a cell, shown by its row and column |
| edit | to arrange, change, or correct existing text |
| entry bar | area on a spreadsheet where the text, number, or formula in the active cell is displayed |
| fill | a spreadsheet feature used to copy cell contents to a selected range (vertically or horizontally) of cells |
| font | the shape of the characters belonging to a particular family of type |
| footer | common text printed at the bottom of every page of the document |
| format | the appearance of your document using tools such as bold, italic, font, and other tools |
| formula | any mathematical process that you perform automatically in a spreadsheet |
| grid lines | the dotted or solid lines that appear around cells in a printed spreadsheet |
| handles | small boxes that appear around an object to tell you that it is selected |
| header | common text printed at the top of every page in a document |
| highlight | to identify an area on screen that you will copy, cut, delete, change, or modify in some way |
| justify | to shift text to the left, right, or center of the margins |
| mathematical operators | a mathematical function or symbol such as addition (+), subtraction (-), multiplication (*), and division (/) |
| range | a group of cells in a spreadsheet |
| relative reference | a reference to a cell address based on its location relative to the cell containing a formula |
| sort | software feature that allows information to be arranged in a specified order |
| spreadsheet | a document that makes automatic calculations with the data entered |
| text attribute | the characteristic of the text, such as font, font size, font style, or text color |
| undo | to restore the last editing operation that has taken place |
| value | numbers entered in a spreadsheet cell |
| view | a software feature used to look at a document in different ways on the screen |
| word-wrap | text will automatically wrap to the next line without striking the return key |