Excel 2010 Formulas

Excel 2010 using simple Formulas

Image of Excel 2010 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

  1. Select the cell where the answer will appear (B4, for example).
    Selecting cell B4  
    Selecting cell B4
     
  2. Type the equal sign (=).
  3. Type in the formula you want Excel to calculate. For example, "75/250".
    Entering formula in B4  
    Entering formula in B4
     
  4. Press Enter. The formula will be calculated and the value will be displayed in the cell.
    Result in B4  
    Result in B4
Share this article :
 
 
Support : Website Designed | LMSO Group | Organized By
Copyright © 2013. Learning MS Office - All Rights Reserved
Tutorials Developed by LMSO Experts Published by LMSO Group
Proudly powered by LMSO Group