A function in Excel is a preset formula, that helps perform mathematical, statistical and logical operations.

Once you are familiar with the function you want to use, all
Functions
you have to do is enter an equal sign (=) in the cell, followed by the name of the function and the cell range it applies to.
in excel

S. No. Name of function Descriptions of function Syntax Remarks

RANDBETWEEN(bottom, top)
Returns a random integer number between the numbers you The RANDBETWEEN function syntax has the following arguments:
1 RANDBETWEEN NONE
specify. A new random integer number is returned every 1. Bottom Required. The smallest integer RANDBETWEEN will return.
time the worksheet is calculated. 2. Top Required. The largest integer RANDBETWEEN will return.
Returns an evenly distributed random real number greater
RAND()
than or equal to 0 and less than 1 (or 10, 20 depends on the
2 RAND The above syntax will generate real numbers between 0 and 1. To NONE
syntax). A new random real number is returned every time
generate real no. between 0 and 100, the syntax is RAND()*100.
the worksheet is calculated.
1. If number_times is 0 (zero), REPT returns
REPT(text, number_times) "" (empty text).
The REPT function syntax has the following arguments: 2. If number_times is not an integer, it is
Repeats text a given number of times. Use REPT to fill a cell
3 REPT 1. Text Required. The text you want to repeat. truncated.
with a number of instances of a text string.
2. Number_times Required. A positive number specifying the number of 3. The result of the REPT function cannot be
times to repeat text. longer than 32,767 characters, or REPT
returns #VALUE!.
COUNTIF(Where do you want to look?, What do you want to
COUNTIF count the number of cells that meet a criterion Try to keep text in " " if getting error
4 look for?)
COUNT(value1, [value2], ...)
The COUNT function syntax has the following arguments:
counts the number of cells that contain numbers, and 1. value1 Required. The first item, cell reference, or range within which
COUNT NONE
counts numbers within the list of arguments. you want to count numbers.
2. value2, ... Optional. Up to 255 additional items, cell references, or
5 ranges within which you want to count numbers.
MIN(number1, [number2], ...)
The MIN function syntax has the following arguments:
MIN Returns the smallest number in a set of values. 1. Number1, number2, ... Number1 is optional, subsequent numbers are NONE
optional. 1 to 255 numbers for which you want to find the minimum
6 value.
MAX(number1, [number2], ...)
The MAX function syntax has the following arguments:
MAX Returns the largest value in a set of values. 1. Number1, number2, ... Number1 is required, subsequent numbers are NONE
optional. 1 to 255 numbers for which you want to find the maximum
7 value.
 A function in Excel is a preset formula, that helps perform mathematical, statistical and logical operations. Once you are familiar with the function you want to use, all
Functions
you have to do is enter an equal sign (=) in the cell, followed by the name of the function and the cell range it applies to.
in excel

S. No. Name of function Descriptions of function Syntax Remarks

FREQUENCY(data_array, bins_array)
The FREQUENCY function syntax has the following arguments:
The FREQUENCY function calculates how often values occur 1. data_array Required. An array of or reference to a set of values for
FREQUENCY within a range of values, and then returns a vertical array of which you want to count frequencies. If data_array contains no values, NONE
numbers. For example, use FREQUENCY to count the FREQUENCY returns an array of zeros.
number of test scores that fall within ranges of scores. 2. bins_array Required. An array of or reference to intervals into which
Because FREQUENCY returns an array, it must be entered you want to group the values in data_array. If bins_array contains no
8 as an array formula. values, FREQUENCY returns the number of elements in data_array.
PERCENTILE(array,k)
Returns the k-th percentile of values in a range. You can use The PERCENTILE function syntax has the following arguments:
PERCENTILE this function to establish a threshold of acceptance. For (1) array Required. The array or range of data that defines relative NONE
example, you can decide to examine candidates who score standing.
9 above the 90th percentile. (2) k Required. The percentile value in the range 0..1, inclusive.
10 SUM The SUM function adds values. SUM(number1,[number2],...) NONE
AVERAGE(number1, [number2], ...)
The AVERAGE function syntax has the following arguments:
(1) Number1 Required. The first number, cell reference, or range for
AVERAGE NONE
which you want the average.
(2) Number2, ... Optional. Additional numbers, cell references or ranges
11 Returns the average (arithmetic mean) of the arguments. for which you want the average, up to a maximum of 255.
(1) If there is an even number of numbers in
the set, then MEDIAN calculates the
average of the two numbers in the middle.
(2) Arguments can either be numbers or
names, arrays, or references that contain
numbers.
(3) Logical values and text representations
of numbers that you type directly into the
MEDIAN
list of arguments are counted.
(4) If an array or reference argument
contains text, logical values, or empty cells,
those values are ignored; however, cells
MEDIAN(number1, [number2], ...) with the value zero are included.
The MEDIAN function syntax has the following arguments: (5) Arguments that are error values or text
Returns the median of the given numbers. The median is the (1) Number1, number2, ... Number1 is required, subsequent numbers that cannot be translated into numbers
12 number in the middle of a set of numbers. are optional. cause errors.
 A function in Excel is a preset formula, that helps perform mathematical, statistical and logical operations. Once you are familiar with the function you want to use, all
Functions
you have to do is enter an equal sign (=) in the cell, followed by the name of the function and the cell range it applies to.
in excel

S. No. Name of function Descriptions of function Syntax Remarks

MODE(number1,[number2],...)
The MODE function syntax has the following arguments:
(1) Number1 Required. The first number argument for which you want
MODE to calculate the mode. NONE
(2) Number2,... Optional. Number arguments 2 to 255 for which you
MODE returns the most frequently occurring, or repetitive, want to calculate the mode. You can also use a single array or a reference
13 value in an array or range of data. to an array instead of arguments separated by commas.
STDEV.S(number1,[number2],...)
The STDEV.S function syntax has the following arguments:
(1) Number1 Required. The first number argument corresponding to a
sample of a population. You can also use a single array or a reference to
STDEV.S NONE
Estimates standard deviation based on a sample (ignores an array instead of arguments separated by commas.
logical values and text in the sample). The standard (2) Number2, ... Optional. Number arguments 2 to 254 corresponding to
deviation is a measure of how widely values are dispersed a sample of a population. You can also use a single array or a reference to
14 from the average value (the mean). an array instead of arguments separated by commas.
VAR.S(number1,[number2],...)
The VAR.S function syntax has the following arguments:
VAR.S (1)Number1 Required. The first number argument corresponding to a NONE
Estimates variance based on a sample (ignores logical sample of a population.
15 values and text in the sample). (2) Number2, ... Optional. Number arguments.

Returns the skewness of a distribution. Skewness

characterizes the degree of asymmetry of a distribution SKEW(number1, [number2], ...) T
SKEW around its mean. Positive skewness indicates a distribution he SKEW function syntax has the following arguments: NONE
with an asymmetric tail extending toward more positive (1) Number1, number2, ... Number1 is required, subsequent numbers
values. Negative skewness indicates a distribution with an are optional. You can also use a single array or a reference to an array
16 asymmetric tail extending toward more negative values. instead of arguments separated by commas.
Use the median to divide the ordered data set into two halves.
(1) If there are an odd number of data points in the original ordered data
set, do not include the median in either half.
Quartile.INC (2) If there are an even number of data points in the original ordered data NONE
set, split the data set exactly in half.
Use withInclusive median The median is included in the (3) The lower quartile value is the median of the lower half of the data.
17 calculation if N (the number of values in the data) is odd. (4) The upper quartile value is the median of the upper half of the data.
 A function in Excel is a preset formula, that helps perform mathematical, statistical and logical operations. Once you are familiar with the function you want to use, all
Functions
you have to do is enter an equal sign (=) in the cell, followed by the name of the function and the cell range it applies to.
in excel

S. No. Name of function Descriptions of function Syntax Remarks

Use the median to divide the ordered data set into two halves.
(1) If there are an odd number of data points in the original ordered data
set, include the median in both halves.
Quartile.EXCC (2) If there are an even number of data points in the original ordered data NONE
set, split this data set exactly in half.
Use with Exclusive median The median is excluded from (3) The lower quartile value is the median of the lower half of the data.
18 the calculation if N (the number of values in the data) is odd. (4) The upper quartile value is the median of the upper half of the data.
TRIMMEAN(array, percent)
The TRIMMEAN function syntax has the following arguments:
Returns the mean of the interior of a data set. TRIMMEAN (1) Array Required. The array or range of values to trim and average.
TRIMMEAN calculates the mean taken by excluding a percentage of (2) Percent Required. The fractional number of data points to exclude NONE
data points from the top and bottom tails of a data set. You from the calculation. For example, if percent = 0.2, 4 points are trimmed
can use this function when you wish to exclude outlying from a data set of 20 points (20 x 0.2): 2 from the top and 2 from the
19 data from your analysis. bottom of the set.