171k views
1 vote
Which formula would appear if you copied and pasted the cell containing the formula =SUM(A1:A4) from cell A5 to cell C6?

A. =SUM(C1:C4)
B. =SUM(C2:C4)
C. =SUM(C2:C5)
D. =SUM(C1:C5)

User ThomasV
by
7.2k points

2 Answers

4 votes

Answer:

C.SUM(C2:C5)

Step-by-step explanation:

User Akshay Bheda
by
6.9k points
4 votes
it looks like it sums the tihings alll before it
so in row A, collumn n, so An, it would be SUM(A1:A(n-1))

so

C6 is SUM(C1:C5)
D



User Derek Gogol
by
7.2k points