Excel Common Functions Checklist
| FUNCTION NAME | FUNCTION SYNTAX | FUNCTION DESCRIPTION |
| AVERAGE | =AVERAGE(C1:C4) | Find the average (mean) of a list of numbers. |
| CONCATENATE | =CONCATENATE(B1,B2) | Joins contents of cells together |
| CONVERT | =CONVERT(68, “F”, “C”) | Converts 68 degrees Fahrenheit to Celsius (20) |
| COUNT | =COUNT(B4:B12) | Counts the number of cells which have a number in them |
| COUNTBLANK | =COUNTBLANK(B7:B13) | Counts the number of empty cells |
| COUNTIF | =COUNTIF(B2:B6,12) | Counts the number of cells which have a 12 in them |
| DEC2BIN | =DEC2BIN(“19”) | Converts a decimal number 19 to binary |
| HEX2OCT | =HEX2OCT(“3B4E”) | Converts hexadecimal 3B4E to octal |
| IF | =IF(logical_test, [value_if_true], [value_if_false]) e.g. =IF(A2<=50,”PROMOTED”,”CHOPPED”) | Records PROMOTED if the number in cell A2 is less than or equal to 50 Otherwise, the function displays CHOPPED |
| INT | =INT(B1) | Records the whole number part of a number e.g 3.15 becomes Integer 3 |
| LARGE | =LARGE(B3:B13,2) | Gives the 2nd largest number |
| LOG | =LOG(8, 2) | Returns the Logarithm of 8 with base 2 |
| LOWER | =LOWER(A2) | Converts text string to Lower case |
| MAX | =MAX(A2:A6) | Largest of the numbers in the range A2:A6 |
| MEDIAN | =MEDIAN(A2:A6) | Median of all the numbers in the range A2:A6 |
| MIN | =MIN(A2:A6) | Smallest of the numbers in the range A2:A6 |
| MODE | =MODE(A2:A6) | Returns the commonest or most frequently occurring number in the range A2:A6 |
| NOW | = NOW() | Returns the serial number of the current date and time |
| OCT2BIN | =OCT2BIN(67) | Converts an octal number 67 to binary |
| POWER | =POWER(2,4) | Returns 2 raised to the power of 4 i.e 2x2x2x2=16 |
| PRODUCT | =PRODUCT(A2:A4) | Multiplies the numbers in cells A2 through A4. |
| PROPER | =PROPER(A2) | Proper case of first string (this is a TITLE =This Is A Title) |
| RANK | =RANK(NUMBER,REF,[ORDER]) e.g. =RANK(A3,A2:A6,1) | Gives the Rank (Position) of A3 out of the values in the range A2:A6, in ascending order |
| ROMAN | =ROMAN(B2) | Converts the value in cell B2 to roman numerals |
| ROUND | =ROUND(B3,2) | Rounds value in B3 to 2 decimal places |
| ROUND | =ROUND(2.15, 1) | Rounds 2.15 to one decimal place |
| SMALL | =SMALL(B3:B13,2) | Gives the 2nd smallest number |
| SQRT | =SQRT(16) | Square root of 16 |
| SUM | =SUM(C1:C4) | Adds a list of numbers |
| TODAY | =TODAY() | Returns the current date. |
| UPPER | =UPPER(A2) | Converts text to Upper Case (CAPITAL LETTERS) |