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
   204   205   206   207   208   209   210   211   212   213   214