Basic formulas in Microsoft Excel: MIN, MAX, AVERAGE
Today's topic very easy and basic level learning for beginners who did not start learning excel can start learning from our youtube channel Waseem WebWork. This tutorial especially provides you basic concepts of excel formulas. We can find many types of results with the help to excel. Now let see how can we use a different formula in Microsoft Excel.
1: MIN formula:
In this formula, we find the very lowest value from our data. Use of this formula in Microsoft Excel =MIN(Number 1: Number 2 etc.). For example, we have 1 to 10 numbers and if we use this formula the result will be 1 because of its lowest number in the data.2: MAX formula:
With the help of this formula, we can find the maximum or highest value from the available data. Use of this formula like this =MAX(number 1: number2 etc.). For example, we have data 1 to 10 numbers so if we apply this formula the result will be 10 because of the highest number.3: Average formula:
With the help of this formula, we can find the average or mean value from the data.Use of this formula =AVERAGE(number1: number2 etc.). For example, if we have data from 1 to 10 so we can calculate in different ways like one method is that we add all numbers =(1+2+3+4+5+6+7+8+9+10)/10 but the easiest way to find the mean or average look below:
Waseem Web Work |
Visit our facebook page for further information and don't forget like the page.
Also, visit our youtube channel WaseemWebWork and subscribe to our channel.
No comments:
Post a Comment