What are the function in excel?

Answer 1

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.