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

