|
 Relative cell | the cell value changes as the formula is copied |
| Row | refers to all of the contents in a horizontal range of cells |
| Secondary sort | indicates the next range in a sort, such as first name |
| Sort | used to arrange data in alphabetical or chronological order |
| Spreadsheet | an arrangement of cells in columns and rows used to organize, analyze, calculate, and report information, usually in numerical form |
| Subtraction | indicated by the - symbol and used in formulas to subtract cell values |
| Sum function | example: =sum(c4:C18) adds the range of cells from C4 through C18 |
| Validated list | limits data entry to specific choices programmed into the function |
| Value | classification that indicates the data has the potential to be used in calculations; by default, cells formatted as values are right justified |
| Vector example | In the forumla =Lookup(F9, G7:G12, H7:H12), the software is instructed to "look up" the value of Cell F9 in the cell range G7:G12 and return the value that is horizonally adjacent to it and located in the cell range H7:H12. |
| VLookUp | used when there are more than two columns in the array (lookup table); VLookUp searches for matches according to column number |
| Workbook | a file which contains one or more spreadsheets |
| Wrap | when data in the cell wraps to the next line to fit the column width; data wrapping adjusts automatically |