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

What power does the principle judicial review bestow on the judicial branch?
Which book is recorded as the tallest in the Library of Congress?
What is a glass rod used for in chemistry and biology laboratory?
Which compound could serve as a reactant in a neutralization reaction?(1) NaCl (3) CH3OH(2) KOH (4) CH3CHO
m=k/s solve for k Answer choices K=m/s K=ms K=s/m K=m+s
Leader of Britain during WW II
Renee has a jewelry business where her clients create their own bracelets from antique buttons. she charges $15 for the entire activity, which includes the stri
that does 3/5 compromise mean
Do Sugar Crystals Grow Faster In Tap Water Or In Distilled Water?
The bond between Br atoms in a Br2 molecule is (1) ionic and is formed by the sharing of two valence electrons (2) ionic and is formed by the transfer of two va