Question

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)

Answer 1

=SUM(C2:C4, C7)

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
`Cn` to
`Cm`

Then under the function formula we write
`Cn:Cm`

And, when we operate a cell
`Cn` with non consecutive cell
`Cl`

Then under the function formula we write
`Cn, Cl`

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

=SUM(C2:C4, C7)