Page 182 - IT 402 v2.0 class 10
P. 182
Step 8: lick on ccept button from Formula ar. otal Sales of encil will be displayed in the cell .
Total Sales of
Pencil
To Refer a Cell in another Workbook
o refer a cell in another workbook follow the steps:
Step 1: Open an existing workbook. ere we have opened a spreadsheet file ell eference.ods .
Create a new workbook.
Set the cursor in the cell
to insert the external
data and enter an equal
sign ( ‘=’ ) to begin a
formula.
180 Touchpad Information Technology-X

