A) SUM (B1:B5)
B) SUM (A6: B6)
C) SUM (B1:B5)
D) SUM (A1:B1)
E) SUM (B1:B6)
Correct Answer: A
Solution :
[a] If you want to copy a formula and have the cell reference change depending on where you paste the formula, use a relative cell reference. When you copy a formula containing a relative cell reference, Excel automatically adjusts the cell reference to refer to the corresponding location. So, if you copy, =SUM (A1-A5) from cell A6 to cell B6, Excel stores the following formula in cell B6:=SUM (B1:B5)You need to login to perform this action.
You will be redirected in
3 sec