Page 238 - IT 402 v2.0 class 10
P. 238

2.  Why do we need to merge worksheets?                                                         [2023]

         Ans.  Sometimes, multiple reviewers return edited versions of a worksheet at the same time. In this case, it may be
              quicker to review all of these changes at once, rather than one review at a time. For this purpose, Calc provides
              the feature of merging worksheets.
            3.  ............................. feature of Calc helps to track what data was changed, when the change was made, who made the
              change and in which cell the change has occurred.                                            [2023]
              (a)  Record Changes                          (b)  Edit Record
              (c)   Change Record                          (d)  Macro
         Ans.  (a)
            4.  Arguments passed to a macro from Calc are always ............................. .           [2022]
              (a)  Strings                                 (b)  References
              (c)  Numbers                                 (d)  Values

         Ans.  (d)
            5.  List any two conditions/formats/items that can be used for conditional formatting in a Spreadsheet.   [2020]
         Ans.  Fill Color, Fill Pattern.
            6.  What could you do to add an absolute reference?                                            [2016]
              (a)  Add dollar signs around the cell        (b)  Click F4
              (c)  Both (a) and (b)                        (d)  None of these
         Ans.  (c)
             .   hat is conditional formatting   xplain “sort” and “filter” features available in spreadsheet.

         Ans.  Calc gives the user an advance formatting feature known as Conditional Formatting. This feature enables the user
              to apply formatting to only those cells in the worksheet which satisfy a particular condition. The formatting is not
              applied to the cells which do not satisfy the condition.
              Sorting means grouping some data by class or type or size. Calc has a built-in feature to sort lists. Calc can sort
              a list both in ascending or increasing order and descending or decreasing order. In case of both ascending or
              descending order   alc first sorts numbers  then alphabets followed by blanks cells.
              Filter is an object that removes something from whatever passes through it. The Filter feature of Calc gives the
              user the required information without making any change in the order of the list.


































         236       Touchpad Information Technology-X
   233   234   235   236   237   238   239   240   241   242   243