Tag: average function in excel

For using these 4 function in excel and to know the actual purpose of all those function. Please follow the step mentioned below. SUM () function add all the numeric value available in different range. SUM() function only need the reference range For Example:- =SUM(B2:C7)AVERAGE () function add all the numeric value available in different range and divide it by the counting the cell with numeric value available. Suppose there are 4 cell and its total is 100 then Average () function will divide 100 by 4 100/4 = 25 is the average. For Example:- =AVERAGE(B2:C7)MAX() function find the bigger number from the given range or a cell reference. Suppose there are 4 cell and its contain 10, 20, 30, 40, then MAX() function will give you the 40 as a max number. For Example:- =MAX(B2:C7)MIN() functi...