Page 241 - TP_IT_V1.0_C10_flipbpookl
P. 241

The SortAscMacro macro will be executed and the sorts the numbers in the ascending order.


































                         LINKING DATA AND SHEET


                 Linking the sheets is done to access data present in the different sheets of the same spreadsheet or in different
                 spreadsheets. This data is needed for calculation and data analysis. LibreOffice Calc gives you the facility of using data
                 from multiple sheets at the same time.

                 Setting up Multiple Sheets

                 When you open a new spreadsheet, it has a single sheet named as Sheet1, by default.  LibreOffice Calc allows you to
                 add and remove sheet in the spreadsheet according to the requirement. These sheets are managed in the Sheet tab
                 located at the bottom of the spreadsheet.







                 Inserting a New Sheet

                 There are several ways by which you can add a new sheet in the spreadsheet. To insert a sheet, perform the following steps:
                 Step 1:  Select a sheet where you want the sheet to be inserted after it or before it.
                 Step 2:  Click on Sheet Menu and select Insert Sheet option from the Menu bar.
                         OR
                         Right-click on the empty area in the Sheet tab and select Insert Sheet option from the context menu.

                         OR
                         Click the Add new sheet button in the Sheet tab.



                                       When you add a new sheet by clicking the Add new sheet button in the Sheet tab, then
                                       the new sheet will be inserted at the end of the existing sheets in the Sheet tab.




                                                                      Electronic Spreadsheet (Advanced) using LibreOffice Calc  239
   236   237   238   239   240   241   242   243   244   245   246