Question

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.​

Answer 1

Answer:

addition

Explanation:

here is yr answer

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

Answer 2

• 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).