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

