| A | B |
|---|
| Absolute Cell Reference | 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. |
| Average | A function that adds the values of the cells in a range and divides the result by the number of cells in the range. |
| Cell | Individual locations on a spreadsheet. The intersection of a row and column. |
| Cell Reference | The column letter and row number used to identify a cell, such as B3. |
| Circular Cell Reference | An error that occurs when a formula references the cell it is stored in. |
| Column | Appear vertically in a worksheet and are identified by letters at the top of the worksheet window. |
| Count | A function that will return the number of cells in a range that contain values. |
| CountA | A function that will return the number of cells in a range that contain data regardless of the type. |
| CountIF | A function that will count cells that meet a certain condition as set forth in the formula. |
| Date Function | 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. |
| Embedding | 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. |
| Fill Series | Used to fill a row or column with consecutive date, such as the days of the week, months, etc. |
| Footer | A feature used to add identifying information to the top of a spreadsheet. |
| Formula | Instructs the software to perform a calculation. |
| Freeze Panes | Allows the user to work in multiple areas of a large spreadsheet and focus the view on specific cell ranges. |
| Header | A feature used to add identifying information to the foot of a spreadsheet. |
| If Statement | A function that makes a decision based on a comparison. |
| Label | Cell data classification used for cells that contain text or for numbers that will not be used in calculations. |
| Linking | Used to integrate spreadsheet data with other software applications when you want the target data to update anytime the spreadsheet data is edited. |
| List | A feature used to create a more user-friendly spreadsheet atmosphere. |
