Page 209 - Trackpad 402_Class-X_Final
P. 209
Tick ( ) if you know this.
A file in OpenOffice Calc is known as a workbook.
The default name of the sheet can be changed by renaming a worksheet with a new name.
The main advantage of using cell reference is that it can be used in formulas and functions.
A cell reference is the method used to refer to a cell or a range of cells in a worksheet.
WORKING WITH HYPERLINKS IN A SHEET
Hyperlink means a content when clicked will open another linked file. It helps you move to different locations from
within a sheet. This linked file can be a document, spreadsheet, image file, web page, etc.
Hyperlinks helps you to:
• Move to a specific cell within the current workbook.
• Move to a specific location in another file. This file can be a spreadsheet, document, or any other file.
• Accessing a specific website.
• Sending an email to a specific address.
• Creating a new file.
Hyperlink in a spreadsheet is of two types which are as follows:
• Relative Hyperlink
• Absolute Hyperlink
Let us study about these.
Relative Hyperlink
It refers to reaching the linked document with respect to the current location. It will include the partial cell address in
hyperlink. If the start and target locations change relative to each other, then relative hyperlink will not work.
To make it work, follow the given steps:
Step 1: Click on Tools menu and select Options. The Options dialog box will open.
Step 2: Click on Load/Save node.
Step 3: Now select General option and choose if you want URLs saved relatively when referencing the File System, or
the Internet, or both.
Absolute Hyperlink
It refers to reaching to the linked file by writing the complete address starting from the root directory. If the target
location only changes then the absolute hyperlink will stop working.
To make it work, follow the given steps:
Step 1: Click on Tools menu and select Options…
Electronic Spreadsheet (Advanced) 209

