Page 219 - IT_Play_V1.0 Class9
P. 219
Other Shortcut Keys
Purpose Action Required
To open a new spreadsheet Press Ctrl + N
To save an existing spreadsheet Press Ctrl + S
To save a new spreadsheet Press Ctrl + Shift +S
To close a spreadsheet Press Ctrl + W
To exit from spreadsheet Press Ctrl + Q
To open an existing spreadsheet Press Ctrl + O
To print a sheet Press Ctrl + P
21 st
Lab Assignment ‘n Activity Century #Technology Literacy
Skills
Complete the following activities and tick the circle.
Open LibreOffice Calc on your computer screen and create a new spreadsheet file.
Explore the interface of the LibreOffice Calc spreadsheet.
Create a new spreadsheet and enter the following data in the sheet:
With the help of the keyboard & mouse, move across the cells and save the file
WORKING WITH SPREADSHEET
While working with a spreadsheet, you often need to adjust the structure of your worksheet to suit your
needs. In LibreOffice Calc, the operations of adding, deleting, hiding, and unhiding are key tasks that help
to manage and organise your spreadsheet data efficiently.
Adding Sheet
By default, the LibreOffice Calc spreadsheet opens with one sheet. But, a user can add more sheets if required.
To add new sheets in the spreadsheet, follow the given steps:
Step 1: Right-click on the Sheet tab.
Step 2: Select the Insert Sheet option from the drop-down menu. OR Click on Sheet menu from Menu bar
and select Insert Sheet option. The Insert Sheet dialog box appears on the screen.
Step 3: Select the Position where the new sheet is to be added in the spreadsheet. In our case, we have
selected the option After current sheet.
Step 4: Enter the No. of sheets.
Create a Spreadsheet 217

