| 2. | A:A - Column A | |
| 4. | 2:2 - Row 2 | |
| 8. | A1:C20 - Range of cells | |
| 6. | $A1 - Absolute Column - copy doesn't change column but row adjusts | |
| 9. | Named Range - Assign a name to a cell, range of cells, row or column = Ctrl+F3 | |
| 1. | A1 - Row/Column relative - copy and cell changes | |
| 3. | A:D - Column A thru D | |
| 5. | $A$1 - Absolute reference - copy doesn't change | |
| 7. | A$1 - Absolute row - copy doesn't change row but column adjusts |