Computer Science, asked by ornellamoonche, 1 year ago

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

Answers

Answered by nmalavikamohan
16
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 :)
Answered by MVB
6
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 t
he SUM() function is a much more efficient way to add up cells.
The formula for C4 to C14 will be =SUM (C4:C14)
Similar questions