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

