Lets understand how to write a complete formula in Excel. Let’s start with one of the basic formula of adding numbers in Excel by using simple Sum function. Formula writing is a simple 3 step process as explained below-

**Selecting Cell and function to be used in Formula**

As explained above, whenever we type an equal to (=) sign Excel understands this as a formula.

In picture 1, as one types equal(=) sign in cell F2 and then type name SUM, Excel understands that we want to use SUM function in formula and shows the list of related functions with name “SUM”. By default, function SUM is selected as shown.

__Picture 1__

**Understanding Parameters required**

Press tab key in picture 1 to select this function. Once we press tab key, SUM function is selected with opening parentheses(brackets) and showing list of parameters**(number 1, number 2…) **which have to be added. See picture 2 below.

__Picture 2__

* 3. Selecting Parameters required in formula(See picture 3 below) - 2 Ways to add parameters – One by Arrow keys on keyboard & Two by Click of a Mouse*

*By Arrow Keys on Keyboard*

List of parameters which have to be added can be selected by first highlighting the first cell(B2) in range and then press SHIFT key and by using arrow key select last cell in range(E2) and finally inputing closing parentheses “)”& pressing ENTER key to display formula results in E2.

*By Click of a Mouse*

Parameter selection can also be done by a mouse click, select first cell in range(B2) and drag the mouse till last cell(E2) in range and finally inputing closing parentheses “)”& pressing ENTER key to display formula results in E2.

__Picture 3__

Section: