|
Home » Microsoft Office
» Microsoft Excel Common Used Functions
Microsoft Excel Common Used Functions
Microsoft Excel Most Common Used Functions and Formulas
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
If you need any topic contents please Contact Us and suggest us. Our team is dedicated to add new articles and best quality contents on this site. Your suggestions and feed back can improve us.
|