Page 212 - CA_165_V2.0_C9_Flipbook
P. 212

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 categorised 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.






                   210   Touchpad Computer Applications (Ver. 2.0)-IX
   207   208   209   210   211   212   213   214   215   216   217