How many ways are there to add cells B1 through B10? - ProProfs Discuss Topics More Products More   + Ask Question

# 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)

This question is part of

Quiz 2: Calculations in Excel
Asked by Colton, Last updated: May 26, 2020

### Request 0Follow Share     Answer AnonymouslyAnswer Later Copy Link   #### C. Perez

Just getting better day by day

C. Perez, Writer, Writer, Cleveland

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

John Smith =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)   1 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   