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

Solved Exercise



                                                            Section A
                                                   (Objective Type Questions)
            A.  Multiple choice questions:
               1.  Which feature of Calc helps to see the changes made in the shared worksheet?
                 i.  Record Changes                                ii.  Solver
                 iii. Subtotal                                     iv. None of these
               2.  We can add a comment regarding any changes made in shared worksheet by:
                 i.  Edit > Changes > Comments                     ii.  File > Changes > Comments
                 iii. View > Changes > Comments                    iv. None of these
               3.  Worksheets can be merged from ............................. menu.
                 i.  Edit                                          ii.  File
                 iii. View                                         iv. Tools
               4.  Which types of tasks can be easily performed using Macros?
                 i.  Rare                                          ii.  Repetitive
                 iii. Decision making                              iv. All of these
               5.  Raj has created a worksheet where he has added all the information of his employees. He wants every employee
                 to go through the worksheet and update their address and phone number, if required. He also would like to
                 know the changes done by his employees. Which feature of spreadsheet he should enable to see the changes
                 made by his employees?                                                     [CBSE Sample Paper, 2022]
                 i.   Macro                                        ii.  Link Workbook
                 iii.  Change Worksheet                            iv. Track Changes

              Ans.  1. i      2. i      3. i     4. ii    5. iv

            B.  Fill in the blanks.
                1.  ............................. feature is used to track every edited call by highlighting with coloured border.
                2.  ............................. option helps to display the comment permanently.

                 .   he comments of different author appear in different ............................. .
                4.  Calc automatically adds a ............................. to any record changes.
              Ans.  1. Record changes            2. Show comment            3. colors               4. comment.


                                                            Section B
                                                   (Subjective Type Questions)

            A.  Answer the following questions:
                1.  What do you mean by ‘Record Changes’? List the steps to start recording changes.
             Ans.  The Record Changes feature is used to track the editing process of any cell by highlighting it with a coloured
                 border. On selecting the edited cell  the details of the changes made by different authors will appear.  he steps to
                 start Record Changes are:
                     Open the document to be edited.
                     Click the Edit menu and Select Changes.
                     Select Record option.
                     Now start making the changes in the document. Changes get highlighted by a border around the cells.


                                                                                 More About Spreadsheet        231
   228   229   230   231   232   233   234   235   236   237   238