Page 23 - iprime_V2.2_class8
P. 23
Tech Funda
Pressing the F4 key repeatedly while the cursor is over a cell reference in a formula will
toggle between different types of references.
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.
To enter a reference to Book2 in Book1, follow these steps:
Step 1 Create two workbooks named Book1 and Book2.
Step 2 In Book1, select cell A1 in Sheet1 and type an equal (=) sign.
Step 3 Switch to Book2 by pressing Alt+Tab. Click to select cell A2 in Sheet1 of Book2.
Step 4 Press the Enter key.
After pressing Enter, the formula in Book1 cell A1 should appear as:
= [Book2] Sheet1! $A$2
This reference has 3 parts:
1. Workbook: Book2 enclosed in square brackets
2. Worksheet: Sheet1 followed by an exclamation mark (!)
3. Cell: Absolute reference A2
Note that, to link cells between external workbooks, select the workbook, then the worksheet,
and finally the cell you want to reference.
CUSTOMISE WORKSHEET TAB
Follow these steps to customise a worksheet tab:
Step 1 Right-click the sheet tab you want to customise.
Step 2 Choose from the following options:
Rename: Enter a new name for the sheet.
Tab Colour: Select a colour for the tab.
The name or colour of the sheet will be updated
accordingly.
You can also use Insert, Delete, and Move or Copy options
to add a new sheet, delete a sheet, and move or copy a sheet,
respectively.
Customising Worksheet Tab
Spreadsheet—Functions and Charts 21

