Page 256 - Trackpad 402_Class-X_Final
P. 256

•   If you want the variable to change then you can set the rule that the variable cannot be either bigger than another
                 value or bigger than the desired value entered in the Solver.
            7.  What are the uses of Hyperlinks?
          Ans.  Hyperlinks helps you to:
               •  move to a specific cell within the current workbook.
               •  move to a specific location in another file. This file can be a spreadsheet, document, or any other file.
               •  access a specific website.
               •  send an email to a specific address.
               •  create a new file.
            8.  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: Click on Tools menu and select Share Document… option.
               Step 3:  A dialog opens where you switch on the sharing option by clicking the checkbox Share this spreadsheet with other
                     users.
               Step 4: Click on OK button.
               Step 5:  Click Yes to continue. This will open the file in the shareable mode with word SHARED displayed on the Title bar of
                     the worksheet.
                                                                                    21 st   #Communication
        C.   Competency-based/Application-based questions:                       Century   #Leadership & Responsibility
                                                                                   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 steps to use it in OpenOffice Calc.
               c.  Also name the feature that will help him find the area wise average sales in one quarter. Give the steps to do so.
          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.   Subtotal: Group-wise calculation of sum, average, max, min, count, etc. can be done by using the Subtotal option of
                 OpenOffice 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 OpenOffice Calc. Also give the
              steps to do so.
          Ans.  Scenarios are what-if analysis tools of OpenOffice 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.
            3.  Rohit has made a project and wants to share with his project partner so that he can continue the work.
               a.  Which feature of the spreadsheet should he use to make it shareable with his project partner.
               b.  Give the steps to use the above feature in the spreadsheet.
               c.  If he wishes to merge all the changes in one file, then what are the steps?
               d.  If he wishes to compare the content added by the partner and by him, then what are the steps to compare the file?
          Ans.  a.   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.


          256   Trackpad Information Technology-X
   251   252   253   254   255   256   257   258   259   260   261