In the following spreadsheet, which of the formulae below would be best for cell C2? Note that the formula must be able to be copied down from C2 to both C3 and C4.
| A | B | C | |
| 1 | Lunch Cost (Rs.) | Dinner Cost (Rs.) | Total Cost (Rs.) |
| 2 | 15 | 27 | 42 |
| 3 | 23 | 35 | 58 |
| 4 | 10 | 35 | 45 |
1
=A$2 + $B2
2
=$A$2 + B2
3
=$A$2 + $B$2
4
=$A2 + $B2