Page 23 - iPlus_Ver_2.0_class_8
P. 23
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.
i + CUSTOMISE WORKSHEET TAB
To customise the worksheet tab, follow the given steps:
2 Click on
the Rename
to rename
the sheet,
Tab Color
to select a
tab colour,
or Delete to
delete the
sheet.
1 Right-click 3 Type in the name or
the sheet tab select a colour you would
that you want like for your sheet.
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.
i + FUNCTIONS
Functions are predefined formulas in Excel to perform both simple and complex calculations.
They accept arguments and return values. Arguments are input given to the functions. These
arguments can be numbers or text. The values should be given in between the opening and
closing ( ) parenthesis.
21
Spreadsheet—Functions and Charts

