Page 182 - IT_V1.0_Class10
P. 182
Step 6: Repeat for March sheet, close the round bracket ) and press Enter key and Total Sales of Pencil will
be displayed in the cell B3.
Total Sales of
Pencil
Referencing Cell in Another Spreadsheet
You can refer a cell in another spreadsheet by using keyboard and mouse.
To refer a cell in another spreadsheet, follow the given steps:
Step 1: Open a new spreadsheet (Untitled 1) and select the cell A1.
1
Step 2: Open an existing spreadsheet. (Here, we have opened a spreadsheet file Cell Referencing.ods).
Step 3: Go back to Untitled 1 spreadsheet and type = in cell A1.
Step 4: Select the cell A2 from January sheet of Cell Referencing spreadsheet.
4
Step 5: A reference of the cell has been created in Untitled 1.
The reference to the cell of another spreadsheet contains:
Full path of referred file (Cell Referencing.ods) in single inverted quotes followed by #.
Name of the sheet referred (January) followed by a dot (.).
180 Information Technology Play (Ver 1.0)-X

