19-01-2013, 04:38 PM
EXCEL FUNCTIONS:
EXCEL FUNCTIONS.docx (Size: 28.93 KB / Downloads: 19)
Listing of the most useful Microsoft Excel functions. Explanations on how to write each function in Excel and examples of its use are provided.
Why not test your knowledge with the Excel functions quiz.
Mathematical Functions
SUM - Adds up all the values in a range
SUMIF - Adds all the values in a range that meet specific critera
SUMIFS (2007 and 2010 only) - Adds values in a range based on multiple criteria
SUMPRODUCT - Sum a range of cells that meet multiple criteria
ROUND - Round a number to a specified number of digits
ROUNDUP - Round a number up to a specified number of digits
ROUNDDOWN - Round a number down to a specified number of digits
CEILING - Round a number up to a multiple of significance
FLOOR - Round a number down to a multiple of significance
Statistical Functions
COUNT - Counts all the values in a range
AVERAGE - Calculates the average number from a range of values
MAX - Finds the maximum value in a range
MIN - Finds the minimum value in a range
COUNTA - Counts all non-empty cells in a range
COUNTBLANK - Counts all blank cells in a range
COUNTIF - Counts all the cells in a range that meet specific critera
COUNTIFS (2007 and 2010 only) - Counts all the cells in a range that meet multiple criteria
AVERAGEIF (2007 and 2010 only) - Calculates the average of a range of values that meet specific criteria
AVERAGEIFS (2007 and 2010 only) - Calculates the average of a range of values that meet multiple criteria
LARGE - Return a value dependent upon its ranking in a range of values in descending order
SMALL - Return a value dependent upon its ranking in a range of values in ascending order
RANK - Returns the rank or position of a number within a range of numbers