Practical No.8: Apply Formulas of Ms Excel.

GO TO INDEX

Computer Practicals For Class IX

Activity No.8

PRACTICAL NO. 8:
APPLING FORMULA IN MS EXCEL

USE THE FORMULAS AND FUNCTIONS STEPS

Enter a Formula | Edit a Formula | Operator Precedence | Copy/Paste a Formula | Insert Function

A formula is an expression which calculates the value of a cell. Functions are predefined formulas and are already available in Excel.

For example, ADDITION
=A1+A2+A3

For example, SUM
=SUM(A1:A3)

For example, SUM
=SUM(A1:A3)

Enter a Formula
To enter a formula, execute the following steps.

1. Select a cell.
2. To let Excel know that you want to enter a formula, type an equal sign (=).
3. For example,
   type the formula A1+A2. (Instead of typing A1 and A2, simply select cell A1 and cell A2.
4. Change the value of cell A1 to 3.
   Excel automatically recalculates the value of cell A3. This is one of Excel's most powerful features!

Edit a Formula
When you select a cell, Excel shows the value or formula of the cell in the formula bar.

1. To edit a formula, click in the formula bar and change the formula.
2. Press Enter.

OPERATOR PRECEDENCE
Excel uses a default order in which calculations occur. If a part of the formula is in parentheses, that part will be calculated first. It then performs multiplication or division calculations. Once this is complete, Excel will add and subtract the remainder of your formula.

For example, SUM
=A1*A2*A3
First, Excel performs multiplication (A1 * A2). Next, Excel adds the value of cell A3 to this result.

Another example,
=A1*(A2+A3)
First, Excel calculates the part in parentheses (A2+A3). Next, it multiplies this result by the value of cell A1.

To insert a function, execute the following steps.

1. Select a cell.
2. Click the Insert Function button.
   The 'Insert Function' dialog box appears.
3. Search for a function or select a function from a category. For example, choose COUNTIF from the Statistical category.
4. Click OK. The 'Function Arguments' dialog box appears.
5. Click in the Range box and select the range A1:C2.
6. Click in the Criteria box and type >5.
7. Click OK.

Result. The COUNTIF function counts the number of cells that are greater than 5.
Note: instead of using the Insert Function feature, simply type =COUNTIF (A1:C2,">5"). When you arrive at:
=COUNTIF (instead of typing A1:C2, simply select the range A1:C2.


By Miss Shabana Sheikh And
By Sir Sajjad Akber Chandio