4. The formula for calculating the total sum for the cells C4-C10 is
5. The formula for identifying the minimum value within the cells A6-A15 is
Making Datasheets in MS
Answers
Answered by
4
Answer:
4.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'.
Similar questions