Formulae

Functions in Excel:

• A function is a predefined formula that performs calculations.
• Excel includes functions that can quickly find the sum, average, count, max and min values etc..... for a range of cells.
• Syntax of function is =function name(arguments). Ex: =sum(A1:A9).

How to insert a function into cell?

1. Select the cell that will contain the function.
2. Press Shift + F3 , an Insert Function dialog box will appear.
3. Type in the Search for a function box and click on Go or choose from Select a function list and click on it.
4. Press Enter or click on OK. A function Arguments dialog box will appear.
5. Check the arguments. We can also insert arguments (range of cells).
6. Click OK.

Sum():

This function adds all of the values of the cells in the argument.

Count():

This function counts the number of cells with numerical data in argument.

Average():

This function determines the average of the values included in the argument.

Max():

This function determines the highest cell value included in the argument.

Min():

This function determines the lowest cell value included in the argument.