| A | B |
|---|
| Lookup function | A function used to compare a cell value to an array of cells and return a value that matches the location of the value in the array. |
| Max | A function that displays the maximum value in a range of cells. |
| Merge and Center | Used to combine adjacent cell ranges or cells. The default alignment is center. |
| Min | A function that displays the smallest value in a range of cells. |
| Non-validated list | Allows additional entries other than those provided in the drop-down menu. |
| Order of Operations | The order in which calculations will be performed by the software. |
| Parentheses | Used to control the order of operations that will be performed by the software. |
| Primary Sort | Indicates the first range of data to be used in the sorting operation. |
| Print a Selection | Used when printing only a portion of a spreadsheet. |
| Print Preview | Used to validate how data is represented on paper before printing. |
| Relative Cell Reference | A cell reference that when copied reflects the row or column it has been copied to. |
| Row | Appear horizontally in a worksheet and are identified by numbers on the left side of the worksheet window. |
| Secondary Sort | Indicates the second range of data to be used in the sorting operation. |
| Sort | A feature 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 format. |
| Sum | A function that adds the values in a range of cells. |
| Validated List | Limits data entry to specific choices programmed into the function. |
| Value | Cell data classification used for cells that contain data that has potential to be used in calculations. |
| VLookup | A function that returns a value from a table of values stored in the worksheet. |
| Workbook | A file which contains one or more spreadsheets. |
