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