Question

Suppose you need to add the values in the range of cells from C₂ through C8. Which of the following sequences will give you the correct answer?

1) C₂+C₃+C₄+C5+C6+C7+C8
2) SUM(C₂:C8)
3) C₂*C₃*C₄*C5*C6*C7*C8
4) AVERAGE(C₂:C8)

Answer 1

The correct sequence to add the values in the range of cells from C2 through C8 is to use the SUM function with the range C2:C8.

Step-by-step explanation:

The correct sequence to add the values in the range of cells from C2 through C8 is to use the SUM function with the range C2:C8. Option 2) SUM(C2:C8) will give you the correct answer. This function adds all the values in the specified range.