This is far too broad a question to be answered fully. To see a list of all Excel functions just type the word 'function' into MS Excel Help and you will get a list of all of them.
Basically a function is a device that does calculations Behind the Scenes and shows the result in a particular cell. For example, if you have a series of figures in column D, starting at row 4 and ending at row 24 and you want them all to be added together with the result shown in cell D25, you would enter this formula in that cell:
=SUM(D4:D24) - the function in this case is SUM and this is probably the most commonly used Excel function.
The next most common function is the IF function - if a certain set of circumstances exists do one thing and if it doesn't, do another thing. For example, =IF(B4="","",1) which means, "If cell B4 is blank do nothing, but if it isn't blank enter the number 1 in the current cell.
See related links for a list of Excel functions.
You can create calculations in Excel
eg =b1+b2+b3
or =sum(b1:b3) to add the values in these three cells
Sum is one of hundreds of Excel functions to fulfilparticular calculation types
eg =average(range) mean average value try also MAX MIN COUNT which will give yo the largest, smallest and nmber of entries in a range
A function is a pre-defined formula that comes built into Excel which you can use in your own formulas.
=SUM(A2:A23)/150 This function adds the contents in A2 through A23, and then divides the result by 150.
=MAX(G3:G23) This function displays the highest number found in cells G3 through G23.
Like what it is used for? It is a speadsheet. It is used for a lot of different things. It is also a calculater.
There is no step function in Excel. However, you can use excel to create a Step Function Chart. See related links for a video to explain the process.
Function
In Excel Where are the various function categories stored on the Ribbon?
There is no function of that name in Excel. There is a function called VLOOKUP which stands for Vertical Lookup, and is probably what you mean.
functions of excel
A nested if.
In Excel, the ACos function returns the arccosine (in radians) of a number.The syntax for the ACos function is:ACos( number )number is a number between -1 and 1. It is the cosine of the angle that you wish to find.Applies To:Excel 2007, Excel 2003, Excel XP, Excel 2000
Excel does not have a native BOXPLOT function, but you can replicate the function by following the instructions in the related links.
A function can reference cells or named ranges in the function.
You can use the clipboard in Excel. It is a facility as opposed to a traditional function, like the SUM function or AVERAGE or MAX and other functions that are built in to Excel.
function
There is no function to create a quartile in Excel. A quartile is a 25% division of a statistical collection of data. You can use Excel to create a chart to let you observe the quartiles of the data.