Creating Formulas to Calculate Values

After creating data in a worksheet and define ranges to simplify data references, you can create formulas:

1. Lets say that you have a worksheet that displays numbers an you need to add a formula to get the total amount first go to the cell where you want the result to be.
2. Next type an equals sign and that is the first step to create a formula.
3. Lets say that you need to get an average of a certain range of the worksheet so after the equal signs just type average and then type a parenthesis.
4. After the parenthesis write the cells that you want the function to calculate.
5. When you are done typing the cells you want to make sure that you close the Parenthesis.
6. Press Enter and you are done.

For Example:
=AVERAGE(A1:B4)