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

