Question

Write the procedure to calculate the sum of values in a range of cells C4 to C14

Answer 1

Hello mate, 

One of the most important features of Excel is that it can compute values  by itself once the required formula is given. This helps save a lot of time and is less cumbersome and confusing.There are many ways to find the sum of values. They are as follows:

1. Select a cell, say C15 and enter the formula '=SUM(C1;C14)'. The basic syntax here is '=SUM(address of first cell:address of last cell)'.

2. You can also try the formula in the cell you want to enter the sum in '=C1+C2+C3+C4+C5+C6+C7+C8+C9+C10+C11+C12+C13+C14'.

Hope it helps :)

Answer 2

1. Click on that particular cell where you want the answer.

2. Type = (equals key) in order to start writing your formula.

3. Click on the first cell which is to be added (Here, C4)

4.Type + ( the plus sign) and then click on the second cell to be added (Here, C5)

5.Type + again, and the next cell to be added and so on till C14.

7. Press Enter.

Another option is to use the SUM() function is a much more efficient way to add up cells.
The formula for C4 to C14 will be =SUM (C4:C14)