​

Average Function
​

The Excel Average function receives a group of cells, and returns the average of all the numbers that appear in that group (Average is the sum of all the cells divided by the number of cells).
How to use Average Function:

1. Click on the Formulas menu.
                                          

2. In the More Functions, Click on Statistical and then in Average.
                                                    

3. Input the group of cells where you keep the numbers that  you want to calculate as Average and then OK.

​

Reflection Activity:

• ​Name the 5 categories of functions that appear into the “More Functions” Book in the Formulas Menu

​

​Max function

The Excel Max function  is used to find the largest or maximum number in a given list of values
                                                                               
1. You can find it in the More Functions, Click on Statistical and then  in MAX
                    

2. If you have a list of numbers and you need to find the largest number among all the numbers, select all the list  to be input in the Number1 Box
                                                 
Min Function​

The Excel Min function  is used to find the smallest or minimum number in a given list of numbers.
                                                            
1. You can find it in the More Functions, Click on Statistical and then  in MIN
                    
2. If you have a list of numbers and you need to find the smallest number among all the numbers, select all the list  to be input in the Number1 Box

 

 

​Reflection Activity

• Mention 2 examples where we may need to calculate the Min Number, and 2 where we may need the Max Number.