You create a formula in A8 that adds up the numbers listed in A1 through A7. You copy the formula and paste it into C8. What happens in C8?
A. The sum of cells A1 through A8 appears.
B. The sum of cells C1 through C8 appears.
C. The sum of cells A1 through B8 appears.
D. The sum of cells A1 through C8 appears.
NEED HELP ASAP PLEASE
If you copy the formula from cell A8 and paste it into cell C8, the formula will adjust to its new position and show the sum of the numbers in cells C1 through C7.
So the correct answer is:
B. The sum of cells C1 through C7 appears in cell C8.
When you copy a formula from one cell to another in Excel, the cell references in the formula adjust automatically to reflect their new location. In this case, if you copy the formula from cell A8 to cell C8, the cell references in the formula will adjust accordingly.
Since the original formula in cell A8 is adding up the numbers in cells A1 through A7, when you copy it to cell C8, the adjusted formula in C8 would add up the numbers in cells C1 through C7.
Therefore, the answer is B. The sum of cells C1 through C7 appears in cell C8.
It adds up the numbers listed in A1 through A7.
I hope this helps you!
:D
Depending on the formula, 3 answers could be correct.
If the formula is sum(A1:A7), copying it to C8 will result in sum(C1:C7).
If the formula is sum($A1:$A7), copying it to C8 will result in sum($A1:$A7).
If the formula is sum($A1:A7), copying it to C8 will result in sum($A1:C7).