How many ways are there to add cells B1 through B10?
A. =SUM(B1:B10)
B. =B1+B2+B3+B4+B5+B6+B7+B8+B9+B10
C. =SUM(B1:B8)+B9+B10
D. =SUM(B1:B5)+SUM(B6:B10)
E. =B1*B10
F. =SUM(B1-B10)

The answers to this question are A, B, C, and D. You can write down the equation so that you can analyze things better. =sum(b1:b10)-2. =b1+b2+b3+b4+b5+b6+b7+b8+b9+b10 will just allow you to get the sum; =sum(b1:b8)+b9+b10-4. =sum(b1:b5)+sum(b6:b10) is just similar to the one above. =sum(b1:b10) =b1+b2+b3+b4+b5+b6+b7+b8+b9+b10 =sum(b1:b8)+b9+b10; =sum(b1:b5)+sum(b6:b10).

All of these formulas will give you the answer that you want. You cannot choose E because you will need to multiply the given numbers and F will not be ideal as well because the sum that you will get will be incorrect.

=sum(b1:b10)-2. =b1+b2+b3+b4+b5+b6+b7+b8+b9+b10-3. =sum(b1:b8)+b9+b10-4. =sum(b1:b5)+sum(b6:b10)-=sum(b1:b10) =b1+b2+b3+b4+b5+b6+b7+b8+b9+b10 =sum(b1:b8)+b9+b10 =sum(b1:b5)+sum(b6:b10) will all give you the same answer. =sum(b1:b10) is the same as writing out =b1+b2+b3+b4+b5+b6+b7+b8+b9+b10 except shorter. =sum(b1:b8)+b9+b10 is simply adding the cells between b1 and b8 and then also adds b9 and b10 =sum(b1:b5)+sum(b6:b10) is adding the cells between b1 and b5, and adds that to the total of the cells b6 through b10. =b1*b10 is incorrect because this will multiply the contents inside b1 and b10 =sum(b1-b10) is incorrect, it will subtract the cells b1 and b10 even though it is inside a sum function. (it will make b10 act as a negative)