# 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

575 views
in General
closed

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

by (46.1k points)
selected

Correct Answer - Option 4 : 7

• If the cell value of A1 is 2.
• If the dell value of A2 is 3.
• And if  A3 contains the formula: =$A$1+A2
• that is the value of A3 will be 5.
• But if contents of cell A3 are copied to cell A4 =$A$1+A3
• So the values at A4 cell will be 2+5 i.e. 7