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
   214   215   216   217   218   219   220   221   222   223   224