|
 Absolute Cell | the cell value remains static (doesn't change) when copied to other locations |
| Addition | indicated by the + symbol and used in formulas to add cell values |
| Apostrophe | can be used before cell data that begins with numbers to indicate that the data should be treated as a label for example: '456897890 |
| Array | a lookup table |
| Array Example | In the formula =Lookup(F9, G7:I12); the software will return the value that is in the last column (Column I) that matches the lookup value |
| Average Function | example: =Average(C4:C18) determines the average of the range of cells from C4 through C18 |
| Cell A4 | refers to one specific location on a spreadsheet |
| Cell Reference | indicates a cell's location and provides instructions for how cell data is copied or used in calculations |
| Cells | individual locations on a spreadsheet |
| Center Formatting | usually applied to titles and column heading |