MICROSOFT EXCEL 2013

TEXT FUNCTION

• LOWER( ) Converts all charecters in supplied test string to lower case.





• UPPER( ) Converts all charecters in supplied test string to Upper case.





• TRIM( ) Removes duplicate spaces and spaces at the start and end of a text string.





• CONCATENATE( ) Joins together two or more strings.





• LEFT( ) Returns a specified number of charecters from the start of a supplied text string.





• RIGHT( ) Returns a specified number of charecters from the end of a supplied text string.





• MID( ) Returns a specified number of charecters from the middle of a supplied text string.





• LEN( ) Returns the number of charecters in some text.

DATE & TIME

• TODAY( ) Returns the current date.





• NOW( ) Returns the current date and time.





• DATE( ) Returns a date, from a user-supplied year, month and day.





• TIME( ) Returns a time, from a user-supplied hour, minute and second.

STATISTICAL

• COUNT( ) Counts all the cells that contain numbers in a range of cells.





• AVERAGE( ) Calculate the average in a range of cells.





• MEDIAN( ) Calculate the median in a range of cells.





• MOD( ) Returns the remainder when a number is divided by a divisor.





• MODE( ) Calculates the mode in a range of cells.





• MAX( ) Returns the largest number in a range of cells.





• MIN( ) Returns the smallest number in a range of cells.