Page 246 - TP_IT_V1.0_C10_flipbpookl
P. 246

Step 3:  Press the Enter key to see the total quarterly sales of Monitor i.e. 23, as shown below:















              Step 4:  Similarly, calculate the total quarterly sales of Scanner i.e. 23, as shown below:
















              Note that if the sheet name is made up of two or more words then single quotes are used to enclose sheet name in cell
              reference . For example if sheet name is Jan 2024 then cell reference will change to $'JAN 2024'.B4




                             Subject: To create reference to an individual cell or a Range of Cells
                             1.  To create reference to an individual cell
                                Syntax:

                                $Sheet_name.Cell_address
                                Example:
                                To refer to cell A1 in Sheet2, type '$Sheet2.A1'
                             2.  To create reference to a Range of Cells
                                Syntax:
                                $Sheet_name.First_cell:Last_cell
                                Example:
                                To refer to cells A1:A10 in Sheet2, type ‘$Sheet2.A1:A10’




              Adding a Cell Reference Outside the Document

              Referencing a sheet outside of the document allows you to consolidate and analyse data from different sources without
              manually copying it.  In this references, linked data may not update automatically if the source spreadsheet is closed or
              if there are changes in the file paths. You might need to manually update links or refresh data.

              Using a Mouse

              You can add cell reference between sheets outside the document using mouse by performing the following steps:
              Step 1:   Create a spreadsheet with the name Branch Inventory with the three sheets named as — Meerut, Delhi, and
                      Lucknow having the following details:


                244   Trackpad Information Technology (Ver. 1.0)-X
   241   242   243   244   245   246   247   248   249   250   251