Page 195 - CA_165_V2.0_C9_Flipbook
P. 195
21 st
Lab Assignment ‘n Activity Century #Technology Literacy
Skills
Complete the following activities and tick on the circle:
ª Open OpenOffice Calc and open the existing file ‘Cricket’.
ª Add a new sheet after Sheet1 and rename sheet as ‘Scores’.
ª Move the newly added sheet to the end position.
ª Copy the entire content of the first sheet to the last sheet.
ª Hide the last sheet and then Unhide it.
ª Using ‘Navigator’, move to the different parts of an opened Spreadsheet.
ª Add another sheet before Sheet1 and rename as ‘Players’.
ª Copy Player Name, Country into the newly added sheet.
ª Delete the unused sheet from the sheet.
ª Hide the sheet ‘Scores’.
EDITING IN A SHEET
After creating a sheet, the user may require to edit the contents or data of a cell or the range of cells.
Editing refers to:
l Inserting Cells l Deleting Cells
l Inserting Rows and Columns l Deleting Rows and Columns
l Hiding Rows and Columns l Modifying the cell content
l Cutting/Copying the cell content l Undo and Redo
Modifying the Cell Content
To replace the cell content:
l Select the cell whose contents have to be modified. Type the new content and press the Enter key.
The old data gets replaced by the new one.
To delete the cell content:
l Select the Cell or the range of cells and press the Del key.
Inserting Cells
We can insert cells in Calc by following the given steps:
Step 1: Click on the area, where the cell/cells have to be inserted.
Step 2: Select the option Cells from the Insert menu. Insert Cells dialog box opens.
Step 3: Select the desired option.
Step 4: Click on the OK button to add new cell in a sheet.
Working with Spreadsheet 193

