|Sum Function||This function used to sum or add values in selected cells.||=SUM(A2:A10)
|IF Function||IF Function is one of the best math function in excel, this will be used to make logical comparisons among the two different options.
IF Statement is logical statement, true of false statement, if first condition is true, then first result will be shown otherwise second statement will shown.
|Count Function||Count function is used to count the number of cell, to the selected range of cells.||=COUNT(A17:A85)|
|SUMIF Function||SUMIF function is used to sum the values in a selected range, but sum the value if meet the specific criteria which you used within the logical part of the Function.
For example, you want to sum those values within the selected range which are greater that a specific value.
|COUNTIF||COUNTIF is one of the most powerful statistical function that will be used to count the number of the cells that meet a specific logical arguments which you are mentioned within the logical part of the function.
For Example you want to count those cells which contains the specific text.
|MAX Function||Max Function is used in excel to find the maximum value within the selected range of cells.||=MAX(A1:A50)|
|MIN Function||MIN Function is used to find the minimum value within the selected range of cells.||=MIN(A1:A50)|
|UPPER Function||UPPER Function used to convert the text within the selected cell to upper case.||=UPPER(A1)|
|LOWER Function||LOWER Function used to convert the text to lower case within the selected cell.||=LOWER(A1)|
|PROPER Function||PROPER Function is used to convert the text into proper format.||=PROPER(A1)|