How To Use Basic Excel 2007 Formulas. By using excel formulas, you don't need to be a math expert. Just follow these simple steps to work with Microsoft Excel 2007!
The formula will add the numbers 3 + 2. The final formula will look like this:
= E1 + E2
Entering the data.
1.Type a 3 in cell E1 and press the ENTER key on the keyboard.
2.Type a 2 in cell E2 and press the ENTER key on the keyboard.
You always start by typing the equal sign when creating formulas in Microsoft Excel. You type it in the cell where you want the answer to appear.
1.Click on cell E3 (outlined in black in the image) with your mouse pointer.
2.Type the equal sign ( = ) in cell E3.
Following the equal sign, we add in the cell references of the cells containing our data.
The formula will automatically update the answer if the data in cells E1 and E2 changes by using the cell references of our data in the formula.
Excel has adding cell references features which named Pointing. Pointing allows you to click with your mouse on the cell containing your data to add its cell reference to the formula.
After the equal sign added in above steps
1.Click on cell E1 with the mouse pointer to enter the cell reference into the formula.
2.Type a plus ( + ) sign.
3.Click on cell E2 with the mouse pointer to enter the cell reference into the formula.
4.Press the ENTER key on the keyboard.
5.The answer 5 should appear in cell E3.
6.Click on cell E3. The formula = E1 + E2 is shown in the formula bar above the worksheet.
We hope this article can help you in terms Excel Formulas.
0komentar:
Posting Komentar