Page 48 - TP_Prime_v2.2_Class_6
P. 48

Formula:  A formula  is a  mathematical  expression used to do simple  and complex
                    calculations of the numeric data inserted in a cell or a range of cells. A formula always

                    begins with an equal (=) sign e.g. = A2 + B2.


                     Different Ways to Enter Formulas


                  There are mainly two ways to enter a formula in a worksheet:
           Prime (Ver. 2.2)-VI  the cell after typing an equal sign as shown:
                  •  Typing the formula directly in the cell: In this way, the formula is directly typed in













          46











                                                             Formula in Cell

                     After  entering  the formula in  the cell,
                     press the Enter key. When the Enter key is
                     pressed, the result of the formula appears

                     in the cell.
                                                                                            Output
                  •  Typing the formula in the Formula bar: In this way, we can type the formula in the
                     Formula bar after selecting the cell as shown:

















                                                          Formula in Formula Bar

                  After entering the formula, when we press the Enter key from the keyboard. The result
                  will appear.
   43   44   45   46   47   48   49   50   51   52   53