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

In an Excel spreadsheet, the contents of cells are as follows:a) A1 co

1.	In an Excel spreadsheet, the contents of cells are as follows:a) A1 contains the value 3b) A2 contains the value 5c) A3 contains the formula: = A$1+A2Contents of cell A3 are copied to Cell A4. The value displayed in Cell A4 will be:
A.	11
B.	5
C.	8
D.	13
Answer» B. 5