Write the procedure to calculate the sum of values in a range of cells C4 to C14
Answers
Answered by
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 :)
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
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 the SUM() function is a much more efficient way to add up cells.
The formula for C4 to C14 will be =SUM (C4:C14)
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)
Similar questions