Excel Function

Functions are special commands used in formulas to perform mathematical processes.

To enter functions directly into the worksheet cell

· Select the cell into which the formula will be entered.

· Insert an equal (=) sign to begin the formula. The formula toolbar buttons will appear.

· Enter the name of the function [e.g. SUM], followed by an opening parenthesis [(], any arguments required for the function [e.g. E2:E5], and closing parenthesis[)].

· Press Enter. If there are no errors in the formula, the result of the function will be entered in the cell. If you activate the cell again, the function will be displayed in the formula bar.

To use the AutoSum function

· The functions can be accessed through the AutoSum icon on the Standard toolbar.

· The functions included in the AutoSum drop-down menu will insert the function and predict the arguments.

· For example, if the active cell is positioned at the bottom of the list of values, AutoSum will display a sum function with the list of the arguments.

· Sum -- add the contents of the list of arguments.

· Average -- determine the average value of the list of arguments.

· Count -- count the number of values in the list of arguments.

· Max -- return the maximum number in the list of arguments.

· Min -- return the minimum number in the list of arguments


Example: Using the Average function

· Enter the values as shown below from B1 to B5 and select the cell B6 which the formula will be entered.

· Click the down arrow beside the AutoSum icon on the Standard toolbar and choose Average from the drop-down menu.

· If the predicted range is correct, press the Enter key. If it is incorrect, select (click and drag) the range you want with the mouse and press the Enter key.

· The result will show in cell B6. You can use the same method to do other functions such as SUM, Max, etc.

Note: Excel formula and function is one of the most powerful feature in Microsoft Excel. It is important for you to master it.