make a excel form according to the requirement
724254675
itp101_lab2_cellreferences.xlsxcell ref
| Data1 | Data2 | relative | relative | absolute | absolute | abs col, rel row | abs col, rel row | rel col, abs row | rel col, abs row |
| 1 | 10 | 1 | 1 | 1 | 1 | ||||
| 2 | 20 | ||||||||
| 3 | 30 | ||||||||
| 4 | 40 | ||||||||
| 5 | 50 | ||||||||
| 6 | 60 | ||||||||
| 7 | 70 | ||||||||
| 8 | 80 | ||||||||
| 9 | 90 | ||||||||
| 10 | 100 | ||||||||
| Start at one of the thick boxes (C2, E2, G2, I2) | |||||||||
| Auto complete down the column (C, E, G, I) | |||||||||
| Auto complete to the right of the column (D, F, H, J) |
