In Excel, if you want to calculate the sum of cells ranging from C1 to C12, then which of the following formula you will use?

=SUM(C1 + C12)

=SUM(C1:C12)

=TOTAL(C1:C12)

None of these

=SUM(C1:C12) is the correct Excel formula to sum all values from cell C1 to C12.

The colon : denotes a continuous range of cells.