161k views
0 votes
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)

User BLKKKBVSIK
by
7.4k points

1 Answer

2 votes

Answer:

=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)

User Mettin Parzinski
by
8.0k points