One of the most highly useful features of Microsoft Excel is the function.
Excel allows users to utilize a wide range of mathematical and trigonometric
functions in their worksheets. Let’s see how to use functions in a worksheet using this simple Excel tutorial.
Functions are predefined in MS Excel and we can be utilized easily. Some of the basic mathematical functions are SUM, AVERAGE, MAX, MIN, SQRT etc.
Let’s take the SUM function for example. As the name suggests it is used to calculate the sum of values in different cells.
To find the total of the values in cells A1, A2, A3 and A4, you will have to type in =A1+A2+A3+A4 in the formula bar or another cell.
This could become tedious if you are attempting to find the total for many values. The same can be made simple by using the statement: ‘=SUM(A1:A4)’.
The above statement instructs the processor to find the sum of all values from cell A1 to cell A4. This can be extended to any number of values.
Similarly you can use the AVERAGE function to find the average of n values.
SQRT stands for square root and this displays the square root of the value in a cell.
For example let’s consider that the value in A3 is 64, the formula will be ‘=SQRT(A3)’ – so the output returned will be 8.
Similarly, we can use many other mathematical functions and trigonometric functions like sin, cos, tan etc in our worksheet.
This is how we use functions in MS Excel.