How many ways are there to add cells B1 through B10? - ProProfs

How many ways are there to add cells B1 through B10?

1. =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)
Asked by Colton on Sep 09, 2016

This question is part of

Quiz 2: Calculations in Excel

Request Answer   Share    ... Answer AnonymouslyAnswer Later Copy Link C. Perez

Just getting better day by day

C. Perez
Writer, Writer, Cleveland

Answered on Feb 25, 2019

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.   Reply John Smith

John Smith  Answered on Sep 09, 2016

=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. =b1b10 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)   Reply Thank you so much   Reply Search for Google images Select a recommended image
Upload from your computer Cancel  Search for Google images Select a recommended image
Upload from your computer Cancel  Search for Google images Select a recommended image
Upload from your computer Cancel   