Page 258 - Trackpad 402_Class-X_Final
P. 258

B.  Fill in the blanks.

            1.               is the default extension of OpenOffice calc.
            2.  At the bottom of each worksheet window is a small tab that indicates the    of the worksheets in the
              workbook.                                                                           [CBSE Handbook]
            3.  The default number of sheets present are      .
            4.  Formulas in a Spreadsheet must begin with a       sign.
            5.               option creates a hyperlink to connect to a web address.
            6.               refers to reaching to the linked file by writing the complete address starting from the root directory.
            7.  A              refers to a cell or a range of cells on a worksheet and can be used to find the values or data that you
              want formula to calculate.                                                          [CBSE Handbook]
            8.  Data found in the original file but not in the edited version is marked as   .

        C.  State whether these statements are true or false:

            1.  The Hyperlink icon is present in the Drawing toolbar.
            2.  Using Data → sort only ascending order can be done.
            3.  Linking a section of the same worksheet cannot be done.
            4.  Comments once created can easily be edited.
            5.  Changes made in a shared document can easily be accepted and rejected.
            6.  Data which is changed is marked as changed.
            7.  Spreadsheet software allows the user to share the workbook and place it in the network location
              where several users can access.
            8.  We can rename a worksheet by double-clicking on it and selecting the Rename Sheet option.

        D.  Match the following:

            1.  Sorting                               a.  Multiple Variables
            2.  Solver                                b.  When clicked will open another linked file
            3.  Goal Seek                             c.  Merged Document
            4.  Hyperlink                             d.  One Variable
            5.  Accept or Reject changes              e.  Ascending


                                          SECTION B (Subjective Type Questions)

        A.  Short answer type questions:
            1.  Give the steps to rename a sheet.
            2.  Differentiate between Relative and Absolute Hyperlink.

            3.  What is the purpose of adding comments?                                           [CBSE Handbook]
            4.  What is the use of the Document option in the Hyperlink dialog box.
            5.  What is the need of sharing a worksheet?
            6.  Give the steps to compare two worksheets?
            7.  How can we record a Macro?                                                        [CBSE Handbook]









          258   Trackpad Information Technology-X
   253   254   255   256   257   258   259   260   261   262   263