Page 191 - CA_165_V2.0_C9_Flipbook
P. 191

Lab Assignment ‘n Activity                 Century   #Technology Literacy
                                                                                                21 st
                                                                                               Skills


                    Complete the following activities and tick on the circle:
                    ª  Open OpenOffice on the Computer.

                    ª  Explore all the parts of a spreadsheet.
                    ª  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 spreadsheet as “Student Detail” and Close it.

                    ª  In a new spreadsheet, 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 Spreadsheet should contain at least 10 records in different rows.

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

                    ª  Open ‘Student Detail’ spreadsheet.




                   WORKING WITH SPREADSHEET

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

                 Adding a Sheet

                 Calc spreadsheet opens with three sheets by default. But the user can add more sheets, if required. To
                 add new sheets in the spreadsheet, 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 spreadsheet.

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










                                                                                    Working with Spreadsheet     189
   186   187   188   189   190   191   192   193   194   195   196