based on the magnitude of values, these function will return the rank of one specific value in a data range

based on the magnitude of values, these function will return the rank of one specific value in a data range

These functions will find the biggest (smallest) numbers in a range of data set. you can find 1st, 2st and .. number in your range

Standard deviation is a number that measures the variation among data. And its mean that how much data are far from their mean

These functions calculates the average of numbers in a range of data

These functions count the number of cells in a range that contains numerical values, or any values or if its equal to a some criteria

These functions will convert a decimal number into an integer or another decimal number with desired decimal point

These two functions will return the a random number in Excel, RAND function will return a decimal random number between 0 to 1 and RANDBETWEEN will return an integer random number between two defined values

Here we talk about all different type of sum functions in Excel

WEEKDAY, WEEKNUM in Excel These functions will return the week number from the start of year and the day name of the week at specific date

These functions will return the number of days between two dates