Page 171 - Computer - 10(A&B)

You can link the workbook by inserting formula in one workbook which refers to a cell or cell range in
another workbook.

Step 2: In the first Cost cell, type = B2*. Now to enter reference with this formula, click on Window menu to
get list of active workbooks.

Step 3: Select the workbook Price. Click on the first price cell to link up the two Calc files. You will notice the
formula looks like a link as:

=B2*’file:///E:/ Digitrack 9/IT 402 Class X/CH 2/price.ods’#$Price.B2
Step 4: Press the Enter key. Calc will calculate the final cost by multiplying the quantity in the first workbook.

Creating the Reference between two Workbooks with the Keyboard

To link two Calc workbook, you have to enter a formula in the destination workbook.
In such case, the logical approach to refer to a cell address is:

[Path] [Workbook file name]#$Sheet name. Cell Address
For Example:

[C:\Data] [Price.ods]#$Sheet1.B2

Working with Hyperlinks

A hyperlink is coloured and underlined text or a coloured and underlined graphic that you click to open a file,
a location in a file, a web page on the Web, etc.
There are two types of hyperlinks: Absolute hyperlink and Relative hyperlink

53