Page 182 - IT 402 v2.0 class 10
P. 182

Step 8:   lick on   ccept  button from Formula  ar.  otal Sales of  encil will be displayed in the cell   .

















                                                                                                Total Sales of
                                                                                                   Pencil


















        To Refer a Cell in another Workbook
         o refer a cell in another workbook  follow the steps:

        Step 1:  Open an existing workbook.   ere  we have opened a spreadsheet file   ell  eference.ods .





                                                                            Create a new workbook.
                                                                            Set the cursor in the cell
                                                                              to insert the external
                                                                             data and enter an equal
                                                                              sign ( ‘=’ ) to begin a
                                                                                   formula.






























         180       Touchpad Information Technology-X
   177   178   179   180   181   182   183   184   185   186   187