gatorlover3853 gatorlover3853
  • 03-07-2019
  • Mathematics
contestada

Which of the following is equivalent to the formula =C2+C3+C4+C7?

=SUM(C2:C7)

=SUM(C2,C4:C7)

=SUM(C2, C3, C4:C7)

=SUM(C2:C4, C7)

Respuesta :

slicergiza slicergiza
  • 09-07-2019

Answer:

=SUM(C2:C4, C7)

Step-by-step explanation:

In excel 'C' represent the cell ( intersection of row and column ),

Also, '=sum( )' represents the function of addition in the excel,

Also, when we operate all consecutive cells from [tex]Cn[/tex] to [tex]Cm[/tex]

Then under the function formula we write [tex]Cn:Cm[/tex]

And, when we operate a cell [tex]Cn[/tex] with non consecutive cell [tex]Cl[/tex]

Then under the function formula we write [tex]Cn, Cl[/tex]

Hence, C2+C3+C4+C7 can be written as,

=SUM(C2:C4, C7)

Answer Link

Otras preguntas

paraphrase locke's definition of liberty
which of the following is not an example of good static flexibility
how did conserving food on the home front help the war effort ??
HELP ASAP IDK WHAT TO DO PICTURE
Josh will take 10 test in 5 weeks. How many tests will he have taken after 7 weeks?
The statement below was made by Thomas Jefferson in a 1786 letter to John Jay ...our liberty, which cannot be guarded by the freedom of the press... © 2013 FLVS
Write matrix to represent system 2a-3b=6,a=b=2
Chopin wrote the famous ballets The Nutcracker and The Sleeping Beauty. true or false?
there are 9 red M&M's, 11 green M&M's, and 6 yellow M&M's left in the bag. What is the ratio of green M&M's to the total number of M&M's?
Rachel and Abby are trying to solve a science homework question. They need to find how much a rock that weighs 6pds on Earth would weigh on the moon. What are p