| A | B |
|---|
| A cell reference that does not change when copied because a dollar sign has been placed in front of both the column letter and row number, such as $A$5 | Absolute Cell Refernce |
| A file which contains one or more spreadsheets. | Workbook |
| Individual locations on a spreadsheet. The intersection of a row and column. | Cell |
| The column letter and row number used to identify a cell, such as B3. | Cell Reference |
| An error that occurs when a formula references the cell it is stored in. | Circular Cell Reference |
| Appear vertically in a worksheet and are identified by letters at the top of the worksheet window. | Column |
| A function that will return the number of cells in a range that contain values. | Count |
| A function that will count cells that contain data regardless of the type. | CountA |
| A function that will count cells that meet a certain condition as set fourth in the formula. | CountIF |
| A function used to calculate a period of time such as the number of days that have elapsed since a value was entered in a specific cell. | Date Function |
| Used to integrate spreadsheet data with other software applications when you do not want the target data to update when the spreadsheet data is edited. | Embedding |
| Used to fill a row or column with consecutive data, such as the days of the week, months, etc. | Fill Series |
| A feature used to add identifying information to the bottom of a spreadsheet. | Footer |
| Instructs the software to perform a calculation. | Formula |
| Allows the user to work in multiple areas of a large spreadsheet and focus the view on specific cell ranges. | Freeze Panes |
| A feature used to add identifying information to the top of a spreadsheet. | Header |
| A function that makes a decision based on a comparison. | If Statement |
| Cell data classification used for cells that contain text or for numbers that will not be used in calculations. | Label |
| Used to integrate spreadsheet data with other software applications when you want the target data to update anytime the spreadsheet data is edited. | Linking |
| A feature used to create more a user-friendly spreadsheet atmosphere. | List |
| 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. | LookUp Function |
| A function that displays the maximum value in a range of cells. | Max |
| Used to combine adjacent cell ranges or cells. The default alignment is center. | Merge and Center |
| A function that displays the smallest value in a range of cells. | Min |
| Allows additional entries other than those provided in the drop-down menu. | Non-Validated List |
| The order in which calculations will be performed by the software. | Order of Operations |
| Used to control the order of operations that will be performed by the software. | Parentheses |
| Indicates the first range of data to be used in the sorting operation. | Primary Sort |
| Used when printing only a portion of a spreadsheet. | Print a Selection |
| Used to validate how data is represented on paper before printing and to make adjustments to margins, gridlines, and page orientation, etc. | Print Preview |
| A cell reference that when copied reflects the row or column it has been copied to. | Relative Cell Reference |
| Appear horizontally in a worksheet and are identified by numbers on the left side of the worksheet window. | Row |
| Indicates the second range of data to be used in the sorting operation. | Secondary Sort |
| A feature used to arrange data in alphabetical or chronological order. | Sort |
| An arrangement of cells in columns and rows used to organize, analyze, calculate, and report information, usually in numerical format. | Spreadsheet |
| A function that adds the values in a range of cells. | Sum |
| Limits data entry to specific choices programmed into the function. | Validated List |
| Cell data classification used for cells that contain data that has potential to be used in calculations. | Value |
| A function that returns a value from a table of values stored in the worksheet. | VLookup |
| A function that adds the values of the cells in a range and divides the result by the number of cells in the range. | Average |
