Page 247 - TP_IT_V1.0_C10_flipbpookl
P. 247

Sheet: Meerut                                        Sheet: Delhi












                                   Sheet: Lucknow













                 Step 2:  Create a spreadsheet with the name Total Inventory.
                           In Total Inventory spreadsheet, we need to calculate the total inventory of a product of Meerut, Delhi, and
                         Lucknow branches.

                 Step 3:  Click on cell B2 and place an “=” sign in Sheet 1 of the Total Inventory spreadsheet.






















                 Step 4:  Click on the Meerut sheet in the Sheet tab of the Branch Inventory spreadsheet and click on cell B3.

                 Step 5:   Again, click on the Sheet 1 sheet in the Sheet tab of the Total Inventory spreadsheet. You will see the cell
                         reference as shown below.













                 Step 6:  Type the + sign.

                 Step 7:   Similarly, add sheet references of Delhi and Lucknow sheets of the Branch Inventory spreadsheet. Now the
                         cell reference in the formula given in Total Inventory spreadsheet will be:



                                                                      Electronic Spreadsheet (Advanced) using LibreOffice Calc  245
   242   243   244   245   246   247   248   249   250   251   252