Page 183 - CA 165 ver 1.0 Class 9
P. 183

Lab Assignment ‘n Activity                          Subject Enrichment




                    Complete the following activities and tick on the circle.
                    ª  Begin ‘Calc’ and open the existing file ‘Cricket’.

                    ª  Add a new sheet after Sheet1 and rename 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 ‘Navigator’, 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’.




                   EDITING IN WORKSHEET

                 After creating a worksheet, the user may require to edit the contents or data of a cell or the range of
                 cells. Editing refers to:
                 l    Inserting Cells                                l    Deleting Cells

                 l    Inserting Rows and Columns                     l    Deleting Rows and Columns
                 l    Hiding Rows and Columns                        l    Modifying the cell content
                 l    Cutting/Copying the cell content               l    Undo and Redo

                 Modifying  the Cell Content

                 To replace the cell content:

                 l    Select the cell whose contents have to be modified. Type the new content and press the ‘Enter’
                      key. The old data gets replaced by the new one.
                 To delete the cell content:

                 l    Select the Cell or the range of cells and press the ‘Del’ key.
                 Inserting Cells

                 We can insert cells in Calc by following the given steps:

                 Step 1:   Click on the area, where the cell/cells have to be inserted.

                 Step 2:   Select the option ‘Cells’ from the ‘Insert’ menu. ‘Insert Cells’ dialog box opens.
                 Step 3:   Select the desired option.

                 Step 4:   Click on the ‘OK’ button to add new cell in a worksheet.



                                                                                    Working with Spreadsheet     181
   178   179   180   181   182   183   184   185   186   187   188