Excel Common Functions Checklist

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])
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)

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)