Page 198 - CA 165 ver 1.0 Class 9
P. 198

In a worksheet, a formula is written in a particular cell that displays result after calculation. The formula
                  is applied on a range of multiple cells. In ‘Calc’, a formula works only if it is written with ‘=’ as a  prefix
                  sign. The formula typed in a cell can be seen in the formula bar.
                  In ‘Calc’, formula can be categorized as:



                                                               FORMULA





                         Formula with Cell                    Formula with                        Formula with
                            addresses                          Cell names                       in-built functions



                  Formula With Cell Addresses
                  Each cell in the worksheet has a unique address that is formed by the intersection of its Column and
                  Row, for example, ‘A10’. Here, ‘A’ is the Column name and ‘10’ is the Row number.

                  Calculations are performed on cells on the basis of Cell Addresses mentioned, while writing the
                  formula. The formula thus applied displays the result of the calculations done on the data stored in the
                  mentioned cell addresses.

                  Suppose, the data entered in cells A1, A2, A3 and A4 are 5, 15, 20 and 60 respectively. In cell A5, a
                  formula is entered to calculate the sum of these numbers as follows:  ‘=A1+A2+A3+A4’.
                  Here, the output will be 100 and would be displayed in the cell A5, as soon as the ‘Enter’ key is pressed.

                  Now in the next cell, i.e. A6, enter a new formula to find the average of cell values as ‘=A5/4’. Now the
                  output, 25 will be displayed in the cell (A6).
                  The significant factor of using a formula in spreadsheet with cell addresses is that if a value or entry of
                  one cell is changed, then the values of all subsequent cells where the particular cell address has been
                  applied with formula is also recalculated.

                  In the above example, if the entry in cell A1 is changed from 5 to 25, then cell A5 will change from 100
                  to 120 and the value of A6 will change, i.e., from 25 to 30.

                            Notes


                            In Worksheet, a range of cells, is represented using a colon between the address of first cell and the
                            last cell, i.e., say for denoting a range of cell from A1 to A5 we will write ’A1 : A5’.



                  Formula With Cell Names

                  In ‘Calc’, Formula can be applied in reference to cell names. For doing so, first define the name of the
                  cell or the range of cells.
                  For naming a cell, click on the cell and type the name for that cell in the name box, and press Enter.
                  Name can be used directly in a formula.





                   196    Touchpad Computer Applications-IX
   193   194   195   196   197   198   199   200   201   202   203