Computer Science, asked by soccar2007, 9 months ago

d. If you copy the content of cell A5 containing the formula =sum($A$1:$A$4) to cell
B5, what will be shown in B5.​

Answers

Answered by kinmaykumar2006
6

Answer:

addition

Explanation:

here is yr answer

this formula is also get introduced in that cell you copy.

Answered by SteffiPaul
7
  • If you copy the content of cell A5 containing the formula =sum($A$1:$A$4) to cell B5, the formula shown in B5 will be the same as in A5 i.e. =sum($A$1:$A$4).
  • The sign '$' is used in MS-Excel for the constant value.
  • After the application of '$', the cell address becomes the absolute cell address that does not change when copied to other cells.

Hence, f you copy the content of cell A5 containing the formula =sum($A$1:$A$4) to cell B5, the formula shown in B5 will be the same as in A5 i.e. =sum($A$1:$A$4).

Similar questions