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

