Page 29 - Computer Genius Class 06
P. 29
The e clamation point separates the or sheet portion o the re erence rom the cell portion.
Other Workbook References
You can refer to cells in a worksheet in other workbooks in the same way you refer to cells
in other or sheets ithin the same or oo . These re erences are called external references.
For e ample to enter a re erence to Book2 in Book1, follow the given steps:
Step 1 Create two workbooks named Book1 and Book2.
Step 2 Select cell A1 in Sheet1 of Book1 and type an e ual sign.
Step 3 Switch to Book2 by pressing the Alt+Tab eys on the ey oard. lic to select
cell A2.
Step 4 Press the Enter ey.
After you press the Enter key, your formula in Book1, Cell A1, should be
= [Book2] Sheet1! $A$2.
This reference has 3 parts:
1. The or oo Book2 in s uare rac ets.
2. The or sheet Sheet1 ollo ed y sign.
. The cell ha ing a solute re erence.
ence re erencing cells in the e ternal or oo s is done y selecting the or oo then the
or sheet and then the cell you ant to lin re erence to.
Customise Worksheet Tab
To customise the worksheet tab, follow the given steps:
2 Click on the Rename to
rename the sheet, or Tab
Color to select a ta colour.
3 Type in the name or
select a colour you would
li e or your sheet.
1 ight clic
the sheet tab
that you want
to customise.
The name or colour o the sheet ill e changed.
You can also use the Insert, Delete, and Move or Copy options to add a new sheet, delete a sheet,
and mo e or copy a sheet respecti ely.
Formulas and Functions in Excel 27

