Page 262 - open office
P. 262

Add another column after   uantity  and give the heading as  Price per Piece  and fill

                      the required data in it.
                      Delete the content of  th row.
                      Copy the whole content and paste it in ‘Sheet2’ of the workbook.

                      Delete the 4th row of the given worksheet.
                      Undo the previous work.

                       Redo  the action taken by the  Undo  command.
                      Save the file and exit from ‘Calc’.




                FORMULA

              One of the most important features of spreadsheet package is doing calculations. For calculations, formulae are
              used. Formulae are entered to perform mathematical operations such as addition, subtraction, multiplication,
              division, etc. Formula entry in a cell is a logical entry. It shows the relationship between different cells. In Calc
              or Excel, a formula always starts with an equal (=) sign.

              The formula applied in a particular cell can be viewed in the formula bar when the specific cell is selected.
              Formula in calc includes the following:

              Formula with Cell Address

              Each cell in the worksheet has a unique address that is formed by the intersection of its column and row say;
               A1  . Here,  A  is the column name and  1   is the row number.

              Formulae are applied on cells on the basis of the cell address that displays the output as a result of calculation
              done between data of different cell addresses.

              Suppose, the data entered in cells A1, A2, A3 and A4 are 5,15, 2  and 6  respectively. In cell A5, a formula
              is entered  to  calculate  the  sum of  these  numbers  with  their  cell address; thus  it  will be  displayed  as
                A1 A2 A3 A4 .

              Here, the output will be 1   that will be displayed in the cell A5 as soon as the  Enter  key is pressed.
               ow, in the next cell, i.e. A6, enter a new formula to find the average of cell values as   A5/4 .  ow, the output

              25 will be displayed in the cell (A6).
              (It can be seen here that in A6, formula is applied with respect to the address of the cell, i.e. A5).

              The significant factor of using 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 the cell A5 will change from 1   to
              12  and the value of A6 will change i.e., from 25 to 3 .




               262      Touchpad Information Technology-IX
   257   258   259   260   261   262   263   264   265   266   267