In an Excel spreadsheet, the contents of cells are as follows:
a) A1 contains the value 2
b) A2 contains the value 3
c) A3 contains the formula: =$A$1+A2
Contents of cell A3 are copied to Cell A4. The value displayed in Cell A4 will be:
1. 3
2. 8
3. 5
4. 7