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

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

+ AnswerRequest Answer
...

2 Answers

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

John Adney

John Adney

Thank you so much

Search for Google images
Select a recommended image
Upload from your computer
Search for Google images
Select a recommended image
Upload from your computer
Search for Google images
Select a recommended image
Upload from your computer

Email Sent
We have sent an email to your address "" with instructions to reset your password.