Page 204 - CA_165_V2.0_C9_Flipbook
P. 204

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

                     Complete the following activities and tick on the circle:

                     ª  Open ‘Calc’ on the computer and make Sheet2 as an active sheet.
                     ª   Rename the sheet as ‘Attendance’ and prepare a list of employee with the following
                         headings:
                              DOJ                  Name of the Employee                      Designation



                     ª  Enter details of at-least 10 employees and set the font size as ‘Arial’.
                     ª  Make all the contents of the cell as ‘Bold’ and set the size of the text as ‘18’.
                     ª  Insert a column after designation and give the name as ‘Salary’.

                              DOJ            Name of the Employee               Designation          Salary



                     ª  Set the type face of ‘Salary’ as Bold and Italic.
                     ª  Enter the salary of each employee.
                     ª  Insert a column before DOJ and name it as S.No.
                     ª  Fill the serial number starting from ‘1’ in the ‘S.No.’ column using AutoFill feature.

                     ª  Insert a new worksheet after the worksheet ‘Attendance’.
                     ª  Copy the content to the newly inserted worksheet.
                     ª  Delete the worksheet ‘Attendance’.
                     ª  Rename the newly inserted worksheet and name it as ‘Employee’.
                     ª  Insert a new worksheet and name it as ‘Attendance’.



                      Recap Zone

                       A Sheet is the working area or page on the screen.
                       A spreadsheet is like a book and the sheet is like a page of a book.
                       Data can be classified into numeric, alphanumeric or text, date/time and formula.
                       Commands or data have to be entered with the help of input devices like mouse and keyboard in
                        different cells of the sheet.
                       If a spreadsheet is saved for the first time, it must be assigned with a new file name.
                       Spreadsheet opens with three sheets by default. But the user can add, delete, rename, move and
                        hide/unhide the sheets.
                       We can move in OpenOffice from a cell to another cell or from one sheet to the other using the
                        navigation feature.
                       Editing  could  be  modifying,  deleting,  copying,  moving,  inserting,  cancelling  or  repeating  the
                        recent actions.
                       Formatting a cell includes changing the contents of cell with respect to appearance.
                       Calc also provides a feature to create a custom list where some series of names or text that can be
                        predefined and then it can be displayed when the initial data is entered and AutoFill is applied.




                   202   Touchpad Computer Applications (Ver. 2.0)-IX
   199   200   201   202   203   204   205   206   207   208   209