Page 300 - TP_IT_V1.0_C9_flipbpookl
P. 300

The currently active sheet is highlighted and has an active cell.





              Status Bar
              It gives the status of the sheet in terms of insert or overwrite mode, sheet sequence number, page style and many
              more.





                                      Answer the following questions:
                       uiz Bee        1. Which bar is used to navigate a sheet?

                                      2. What are the actions that can be performed in a sheet?







                                How can you remove duplicate values in a range of cells in LibreOffice Calc?





                       CREATING A SPREADSHEET
              To work in ‘Calc’, the user needs to know how to work with Spreadsheet. ‘Calc’ opens with a new spreadsheet named
              ‘Untitled1’ as the default spreadsheet where the user can begin to work or create a new spreadsheet. To do so:
              Step 1:  Click on the File menu and select the New option.

                      A sub-menu appears.
              Step 2:  Click on the Spreadsheet option.
                      Or
                      Click on the New button from the Standard toolbar.

              A new spreadsheet named Untitled 1 appears on the screen. A new spreadsheet displaying the active sheet Sheet1
              appears on the screen with cell A1 as the active cell.







                                                                                         To create a new
                                                                                         Spreadsheet:
                                                                                     Short key  Ctrl  +  N














              It will be saved with the given name. The extension of a file in Calc is .ods.


                298   Trackpad Information Technology (Ver. 1.0)-IX
   295   296   297   298   299   300   301   302   303   304   305