Page 248 - TP_IT_V1.0_C10_flipbpookl
P. 248

Step 8:  Press the Enter key to see the total inventory, i.e. 32300, as shown below:



























              Step 9:  Similarly, calculate the total inventory of hair oil i.e. 16850, as shown below:




















              Using a Keyboard
              When referencing a cell in another spreadsheet, we enclose the file path in single quotes, followed by ‘#$’, then the
              sheet name, a period, and finally, the cell address.

              For example, ‘file:///C:/Data/Branch Inventory.ods’#$Meerut.B3
              So we see that the cell reference has three parts to it:

              •  Path and file name
              •  Sheet name

              •  Cell reference

              Note that: The file path uses three forward slashes (‘///’) and if the filename contains spaces, it should be enclosed in
              single quotes. Additionally, it’s feasible to import a sheet from a different file using the “From file” option in the Insert
              Sheet dialog box.


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