Page 29 - Digicode_AI_class_6
P. 29
The exclamation point separates the worksheet portion of the reference from 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 worksheets within the same workbook. These references are called external references.
For example, to enter a reference 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 equal (=) sign.
Step 3 Switch to Book2 by pressing the Alt+Tab keys on the keyboard. Click to select
cell A2.
Step 4 Press the Enter key.
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 workbook Book2 in square brackets.
2. The worksheet Sheet1 followed by ! sign.
3. The cell having absolute reference.
Hence, referencing cells in the external workbooks is done by selecting the workbook, then the
worksheet, and then the cell you want to link reference 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 tab colour.
3 Type in the name or
select a colour you would
like for your sheet.
1 Right-click
the sheet tab
that you want
to customise.
The name or colour of the sheet will be changed.
You can also use the Insert, Delete, and Move or Copy options to add a new sheet, delete a sheet,
and move or copy a sheet, respectively.
Formulas and Functions in Excel 27

