Page 182 - IT_V1.0_Class10
P. 182

Step 6:  Repeat for March sheet, close the round bracket ) and press Enter key and Total Sales of Pencil will
                      be displayed in the cell B3.





                                                                                                 Total Sales of
                                                                                                    Pencil







              Referencing Cell in Another Spreadsheet

              You can refer a cell in another spreadsheet by using keyboard and mouse.

              To refer a cell in another spreadsheet, follow the given steps:
              Step 1:  Open a new spreadsheet (Untitled 1) and select the cell A1.














                                  1


              Step 2:  Open an existing spreadsheet. (Here, we have opened a spreadsheet file Cell Referencing.ods).
              Step 3:  Go back to Untitled 1 spreadsheet and type = in cell A1.

              Step 4:  Select the cell A2 from January sheet of Cell Referencing spreadsheet.










                                                                  4












              Step 5:  A reference of the cell has been created in Untitled 1.
                      The reference to the cell of another spreadsheet contains:
                         Full path of referred file (Cell Referencing.ods) in single inverted quotes followed by #.

                         Name of the sheet referred (January) followed by a dot (.).



                180     Information Technology Play (Ver 1.0)-X
   177   178   179   180   181   182   183   184   185   186   187