Functions in Excel are the in-built method of calculation, which can be invoked anytime the user wants to make use of it. e.g SUM for addition, MAX for maximum and IF – for conditional statement known as logical function.
STATISTICAL FUNCTIONS
SUM FUNCTIONS: This is used to sum the values in a list e.g to calculate the total for first Row of the above table follow these steps:
v Place the cursor at cell E3
v Type = Sum(B3:D3) and press Enter Key
AVERAGE FUNCTION: This is used to find the average of the values in a list. To calculate Average for Cell B3…D3 follow the following steps:
v Place the cursor at cell F3
v Type = AVERAGE(B3:D3) and press Enter Key
POSITION FUNCTION: This is used to get the rank of the values in a list. To calculate the POSITION for Cell B3…D3. Follow the steps:
v Place the Cursor at E3
v Type = RANK(B3, $E$3:E7) and Enter
COUNT FUNCTION:This is used to count the number of items in a list e.g. =COUNT(B3:D3)
MAXIMUM FUNCTION: This is used to get the largest value in a list e.g =MAX(B3)
MINIMUM FUNCTION: This is used to get the smallest value in a list e.g =MIN(B3:D3)
PRODUCT FUNCTION: This is used to get the product of two or more numbers e.g =Product(B3:D3)
MATHEMATICAL FUNCTIONS
SQUARE ROOT: This is used to get the square root of one or more numbers e.g =SQRT(B3:D3)
ROUND FUNCTION: This is used to round or approximate figures e.g =ROUND(62.2533,1) and press enter key we will get 62.3 that is been rounded to 1 decimal place.
