Author: admin
Microsoft Excel is a product of Microsoft Office suite. MS Excel is used for manage official spread sheets. I am explaining few most common used Microsoft Excel’s functions.
Sum Function
This function is used to get sum of numbers.
Usage: =Sum(A1:A10) or =Sum(12,4,6,7,3.4) = 32.4
Average Function
This function returns average of multiple numbers.
Usage: =Average(A1:A10) or =Average(4,6,7,5,344,3) = 61.5
Count Function
This function counts the number of cells in a range that contain numbers.
Usage: =Count(A1:A10) or =Count(12,”a”,”n”,”b”,3.3) = 2
Max Function
This function returns the largest number or value from given list.
Usage: =Max(A1:A10) or =Max(12.4,54,33,544,23,22.3) = 544
Min Function
This function returns the smallest number or value from given list.
Usage: =Min(A1:A10) or =Min(12.4,54,33,544,23,22.3) = 12.4
Abs Function
This function return absolute number from given number or number without sign.
Usage: =Abs(A1) or =Abs(-44.3) = 44.3
Bin2Dec Function
This function converts binary value into decimal number.
Usage: =Bin2Dec(A1) or =Bin2Dec(11111110) = 254
Bin2Hex Function
This function converts binary value into hexa number.
Usage: =Bin2Hex(A1,6) or =Bin2Hex(11111110, 6) = 0000FE
Bin2Oct Function
This function converts binary value into octal number.
Usage: =Bin2Oct(A1) or =Bin2Oct(11111110) = 376
Char Function
This function returns character from Ascii code.
Usage: =Chat(A1) or =Chat(65) = A
Code Function
This function returns ascii code of a character.
Usage: =Code(A1) or =Code(“A1″) = 65
CountBlank Function
This function counts blank cells from a range.
Usage: =CountBlank(A1:A10)
Product Function
This function multiplies all given numbers.
Usage: =Product(A1:A10) or =Product(1,3,4,5) = 60