Page 192 - CA 165 ver 1.0 Class 9
P. 192
Lab Assignment ‘n Activity Subject Enrichment
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
Worksheet is the working area or page on the screen.
A workbook is like a book and the worksheet is like a page of a book.
Data can be classified into numeric, alpha-numeric 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 worksheet.
If a workbook is saved for the first time, it must be assigned with a new file name.
Workbook 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.
190 Touchpad Computer Applications-IX

