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

Correct option is D

The formula =$A2+$B2 would be the best option for cell C2. This formula uses absolute referencing for column A and column B while allowing the row number to change as the formula is copied down. This ensures that the Lunch Cost (column A) and Dinner Cost (column B) values are added correctly for each row when copied to C3 and C4.
Important Key Points:
1. Absolute referencing ensures that column A and column B are referenced correctly, but the row numbers change when the formula is copied.
2. The formula can be easily copied down to other cells without needing manual adjustments.