Page 285 - TP_IT_V1.0_C10_flipbpookl
P. 285

Step 4: Record the Macro: Choose Record Macro from the submenu.
                       Step 5:  Perform Sorting Operation: With the macro recorder active, click on Data and then Sort Ascending to arrange the
                             data in ascending order.
                       Step 6: Stop Recording: After sorting, go back to Tools → Macros → Stop Recording.
                       Step 7: Name and Save the Macro: Provide the name SortAscMacro for the new macro and click Save.
                       Step 8: Add a New Sheet and Enter Data: Create a new sheet and enter 25 numbers in random order in the range A1.
                       Step 9:  Run the Macro: Select Tools → Macros → Run Macro to open the Macro Selector dialog. Choose SortAscMacro
                             and click Run to execute the macro.
                       Step 10: Verify Sorting: Check the data in the new sheet to ensure that it is sorted in ascending order.
                       This macro can be reused to sort any similar data range automatically by running it from the Run Macro option.
                    7.  Why do we need to share a file? Write the steps to share a worksheet?
                  Ans.   A file is sometimes required to be accessed by multiple users at the same time for editing. For this purpose the file can be
                       placed in the network so that it can be shared by several users and can be accessed simultaneously.
                       The steps to make the spreadsheet shareable with the other users are as follows:
                       Step 1: Open the spreadsheet.
                       Step 2: Select on the Tools a Share Document option from the Menu bar.
                              The Share Document dialog box opens.
                       Step 3: Select the Share this spreadsheet with other users check box to enable the sharing feature.
                       Step 4: Click on OK button.
                              The Confirmation message box opens.
                       Step 5: Click on Yes button to continue.
                       The (shared) word is displayed with the file name on the Title bar to indicate that the file is in the shareable mode.
                       If you wish to reverse the shared mode into unshared mode, then make a copy of the same file using File → Save as. This
                       will create a copy of the spreadsheet without shareable mode.
                                                                                            21 st
                 C.   Competency-based/Application-based questions.                       Century   #Critical Thinking
                                                                                           Skills
                    1.  The salesman has saved the quarterly sale of his products in three different sheets of the same workbook. He wants to
                       make an annual sales report by using these three files. Help him do the following:
                       a.  Name the feature to make a consolidated sales report of the year.
                       b.  Give the way to access this feature LibreOffice Calc.
                       c.  Also name the feature that will help him find the area wise average sales in one quarter.

                  Ans.  a.   Data consolidation means to collect data from different sources into a common place by using different built in functions
                          like sum(), max(), min(), average(), etc.
                       b.  Select the Data → Consolidate option from the Menu bar.
                       c.   The Subtotal feature that will help him find the area wise average sales in one quarter. Group-wise calculation of sum,
                          average, max, min, count, etc. can be done by using the Subtotal option of LibreOffice Calc. The step to use it Select the
                          Data → Subtotal option.
                    2.  The librarian wants to check the quantity and price of the five books by saving the multiple values for the same cell so that
                       calculation and what if data analysis can be easily done. Name the what-if analysis tools of LIbreOffice Calc. Also give the
                       steps to do so.
                  Ans.  Scenarios are what-if analysis tools of LIbreOffice Calc used for the above case. It helps you set multiple values for the same
                       cell that can be used for calculations or data analysis. After the scenarios are created they can be edited and formatted
                       independent of each other. You can easily switch between the scenarios using the drop down list or Navigator and can
                       create several scenarios for any given range of cells.
                       The steps to use it:
                       Step 1: Click on the Tools menu.
                       Step 2: Select the Scenarios option.






                                                                      Electronic Spreadsheet (Advanced) using LibreOffice Calc  283
   280   281   282   283   284   285   286   287   288   289   290