Page 202 - Trackpad 402_Class-X_Final
P. 202

Step 5:   Click on Keep Result button. This will change the values of the cells to get the desired 95%. The worksheet
                after the changes will appear as follows:




























                LINKING DATA AND WORKSHEETS

        Linking the worksheets is done to access data present in the different sheets of the same workbook or in different
        workbooks. This data is needed for calculation and data analysis. OpenOffice Calc gives you the facility of using data
        from multiple worksheets at the same time.

        As you known that a file in OpenOffice Calc is known as a workbook. A workbook by default has 3 worksheets named
        as Sheet1, Sheet2 and Sheet3.

        Setting up Multiple Sheets
        If you want to add a new worksheet, then follow the given steps:

        Step 1:  Select a sheet where you want the sheet to be inserted after it or before it.
        Step 2:  Click on Insert menu and select  Sheet option.
                OR
                Right-click on Sheet tab and select Insert Sheet option.

                OR
                Click on an empty block just after Sheet3.
                The Insert Sheet dialog box appears with following options:
























          202   Trackpad Information Technology-X
   197   198   199   200   201   202   203   204   205   206   207