Page 254 - Trackpad 402_Class-X_Final
P. 254

10.  The values written within the circular brackets of the function are called    .
          Ans:  1. Data consolidation and Goal Seek   2. Subtotal    3. Scenarios       4. Goal Seek     5. Tools
               6. Edit           7. Merge Document  8. Macro         9. Tools          10. Arguments

        C.   State whether these statements are true or false:

            1.  Renaming a sheet can also be done using Tools Menu.
            2.  Relative hyperlink contains a full URL.
            3.  Filter feature is used to extract data using some conditions on columns.
            4.  Macros do not simplify the task of a user.
            5.  You cannot merge two or more different versions into one document.
            6.  A Macro helps you save time as the long and time consuming tasks are saved as macros and can be
              executed with a click of a button.
            7.  Sorting means arranging the data in the ascending or descending order.
            8.  Compare Document option is used to merge two worksheets.

            9.  Data found in the edited version but not in the original is marked as inserted.
          10.  The Range option allows to show the changes made in the specified range of cells.
          Ans.  1. False  2. True  3. True  4. False  5. False  6. True  7. True  8. False  9. True  10. True

        D.  Match the following:

            1.  Consolidate                           a.  Edit Menu
            2.  Goal Seek                             b.  Format Menu
            3.  Compare Document                      c.  Tools Menu
            4.  Merge Cells                           d.  Data Menu
            5.  Protect document                      e.  Tools Menu
          Ans.  1. d  2. e  3. a  4. b  5. c


                                          SECTION B (Subjective Type Questions)

        A.  Short answer type questions:
            1.  What is Data Consolidation? Why do we need Data consolidation?
          Ans.  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. This data consolidation is used for data collection so that data analysis can easily be
              done.
            2.  What is the advantage of using cell Reference?
          Ans.  The main advantage of using cell reference is that it can be used in formulas and functions. This helps you update the result
              of a function or a formula automatically if the value in a particular cell used in a formula changes.
            3.  How do you keep a track of the changes made in a spreadsheet?
          Ans.  OpenOffice Calc allows you to keep a track of the changes made in a document using the Record Changes option.
               The advantage of a primary key is that it distinguishes one record from another and maintains unique records in a table.
            4.  How do you view the Changes made using Record Change option?
          Ans.  Click on Edit → Changes → ‘Show…’ option.
            5.  What are function arguments?
          Ans.  The values written within the circular brackets of the function are called arguments. These arguments are created to pass
              as values to the functions.




          254   Trackpad Information Technology-X
   249   250   251   252   253   254   255   256   257   258   259