## Excel 2010 using simple Formulas

Excel 2010 Formulas |

Excel can be used to calculate numerical information. In this lesson you will learn how to

**create simple formulas**in Excel to add, subtract, multiply, and divide values in a workbook. Also, you will learn the various ways you can use**cell references**to make working with formulas easier and more efficient.
A

**formula**is an equation that performs a calculation. Like a calculator, Excel can execute formulas that add, subtract, multiply, and divide.
One of the most useful features of Excel is its ability to calculate
using a cell address to represent the value in a cell. This is called
using a cell reference.

In order to maximize the capabilities of Excel, it is important to understand how to

**create simple formulas and use cell references**.
Excel uses standard operators for equations, such as a

**plus sign**for addition (+), a**minus sign**for subtraction (-), an**asterisk**for multiplication (*), a**forward slash**for division (/), and a**caret**(^) for exponents.
The key thing to remember when writing formulas for Excel is that all formulas must begin with an

**equal sign**(=). This is because the cell contains, or is equal to, the formula and its value.#### To Create a Simple Formula in Excel

- Select the cell where the answer will appear (B4, for example).
Selecting cell B4
- Type the
**equal sign (=)**. - Type in the formula you want Excel to calculate. For example, "75/250".
Entering formula in B4
- Press
**Enter**. The formula will be calculated and the value will be displayed in the cell.Result in B4