Page 258 - open office
P. 258

3









              The sheet with its  sheet tab disappears, just as if the sheet was deleted but the sheet still  exists  in the
              workbook. To unhide the same sheet:

              Step 1:  Select the ‘Sheet’ option from the ‘Format’ menu and click on the ‘Show’ option.

                      The ‘Show Sheet’ dialog box appears along with a list of hidden sheets.
              Step 2:   Select the sheet to unhide and click on the  OK  button. The hidden sheet(s) will re-appear in the
                      worksheet.

                NAVIGATION

              Navigation is a feature in Calc by which the cursor can be placed anywhere in a sheet directly. To move directly
              to any cell:
              Step 1:  Click on   avigation  from the  Standard Toolbar . Or, select the option   avigator  from the   iew
                      menu.

              Step 2:   A navigation window opens. In the column and row field, specify the column and row number
                      respectively and then press the ‘Enter’ key. The cursor moves to the typed address of the
                      desired cell.


                                                 Lab Assignment ‘n Activity                          Subject Enrichment



                   Complete the following activities and tick on the circle.

                      Begin  Calc  and open the previously saved file  Cricket .
                      Add a new sheet after Sheet1 and rename the sheet as  Scores .
                      Move the newly added sheet to the end position.

                      Copy the entire content of the first sheet to the last sheet.
                      Hide the last sheet and then Unhide it.
                      Using   avigator , move to the different parts of an opened workbook.
                      Add another sheet before Sheet1 and rename as  Players .

                      Copy Player Name, Country into the newly added sheet.
                      Delete the unused sheet from the worksheet.
                      Hide the sheet  Scores .







               25       Touchpad Information Technology-IX
   253   254   255   256   257   258   259   260   261   262   263