Question

Suppose you need to add the values in range of cell from C2 through C8. Which of the following sequences will give you the correct answer?
a. Click on the cell, then type =SUM(C2:C8), and hit Enter.
b. Click on the cell, then type =C2:C8, and hit Enter.
c. Click on the cell, then type =SUM(C2C8), and hit Enter.
d. Click on the cell, then type =SUM(C2,C8), and hit Enter

Answer 1

Answer:

A

Explanation:

Here, we want to select which of the options best gives the needed result when we need to add Values of data between cell C2 and C8

The correct syntax to this is to go to that cell in which we want the result;

Then type =SUM(C2:C8)

Excel automatically sums up all the values we have between these two cells and return the addition of these values in the cell where we input the formula