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
6
Answer:
addition
Explanation:
here is yr answer
this formula is also get introduced in that cell you copy.
Answered by
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
Chemistry,
4 months ago
Social Sciences,
4 months ago
English,
9 months ago
Math,
9 months ago
History,
1 year ago