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

Lab Assignment ‘n Activity                          Subject Enrichment




                    Complete the following activities and tick on the circle.
                    ª  Begin ‘Calc’ on the Computer.

                    ª  Explore all the parts of a workbook.
                    ª  Explore and use all the shortcut key combination to move in a worksheet.

                    ª  Make Sheet2 as an active sheet.
                    ª  Enter the following details of the 10 students of your class in a separate column.
                        l    Name of the Student                          l    Date of Birth
                        l    Father’s Name                                l    Address

                        l    Admission No.                                l    Class
                    ª  Save the workbook as “Student Detail” and Close it.

                    ª  In a new workbook, prepare a list of Cricket Players with the following details:
                        l    Player Name                                  l    Country
                        l    Total Match Played                           l    No. of Innings
                        l    100s                                         l    Highest Run

                        l    Average Score                                l    Strike Rate
                        The above Workbook should contain at least 10 records in different rows.

                    ª  Save the workbook as ‘Cricket’.
                    ª  Exit from ‘Calc’.
                    ª  Open ‘Calc’.

                    ª  Open ‘Student Detail’ workbook.




                   WORKING WITH WORKBOOK

                 Let us now learn what all different operations can be performed in a workbook.

                 Adding a Sheet

                 ‘Calc’ workbook opens with three sheets by default. But the user can add more sheets, if required. To
                 add new sheets in the workbook, follow these steps:

                 Step 1:   Right click on ‘Sheet’ tab and select ‘Insert Sheet’ option. ‘Insert Sheet’ dialog box appears.
                 Step 2:   Set the position where the new sheet is to be added in the workbook.

                 Step 3:   Specify the number and the name of sheet to be created.










                                                                                    Working with Spreadsheet     177
   174   175   176   177   178   179   180   181   182   183   184