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

The picture shows rays passing through an unknown lens. Which ray would appear on a ray diagram for both a concave lens and a convex lens? A B C D
4(3+10y) need asap please let me know
Regina purchased 1.75 pounds of turkey breast from her local deli for 5.99$ per pound to the nearest cent how much did she spend in all
Plz I need help with this
i will give you 40 points for your help
A 500 kilogram roller coaster starts from rest at the top of an 80 meter hill.What was its speed at the bottom at the hill?
Which cell type stores the majority of the body's glycogen?
resolving conflicts, expressing emotions, managing time, and making decisions are?
1/3•6= And 2/(-3)•12= And (-3/7)•7= And 3/4•8= And 5/3•(-12)= And (-1/6)•(-18) Pls help me Thx
How does the amount of light a plant receives affect its growth rate?