| A | B |
| Relative Reference | When a formula in a spreadsheet is changed relative to its position, during copying. |
| Cell Protection | Locking the contents of a cell, to prevent them from being changed. |
| Complex formulas | Complicated formulas used in spreadsheets . |
| Charting | Drawing a graph from a set of numerical data, usally from a spreadsheet. |
| Sum function | Finds the total of a range. |
| Average function | Finds the average of a range. |
| Maximum function | Finds the maximum value in a spreadsheet. |
| Insert row | To add a new row to the spreadsheet. |
| Minimum function | Finda the minimum value in a spreadsheet. |
| Alignment | Aligns the data to left,right or centre. |
| Value | Numeric data used in a spreadsheet cell. |
| Text | Characters displayed in a cell in a spreadsheet. |
| Absolute referencing | When a formula in a spreadsheet does not change during copying. |