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

5.  Reviewers and authors can add their .............................  to explain their changes in the cell of Spreadsheet.
                                                                                            [CBSE Sample Paper, 2023]

                 i.  Comments                                      ii.  Hyperlink
                 iii.  Worksheet                                   iv. Macros
               6.  In Calc, Arguments passed to a macro from Calc are always ............................. .    [CBSE Sample Paper, 2023]
                 i.  Cell Reference                                ii.  Value
                 iii. Both a and b                                 iv. Sheet Reference

            B.  State whether these statements are true or false.
                1.  Comments are once added cannot be deleted from the worksheet.
                2.  Comments appear only when mouse pointer is hovered over the Sheet tab.
                 .  Macros are pre-defined steps to make the tasks of the users easy.

                 .   rack  hanges  feature is available in OpenO ce for word processing documents and spreadsheets.
                5.  Macro recorded and saved in one worksheet can be used in other worksheets also.

                                                            Section B
                                                   (Subjective Type Questions)
            A.  Answer the following questions:

                 .   hat is sorting   ow do you sort data in OpenO ce  alc using macro
                2.  What is the purpose of adding comments?
                3.  Write a short note on formatting comments.
                 .   xplain in briefly the steps to start recording a macro.
                5.   hat are the steps to be followed to use a macro defined in an earlier worksheet
                                                                                                    S ub j e ct  E nr ich me nt
            B.  Application based questions:

                he following data is from the final attendance of an organisation.  nswer the following  uestion.
                                                  Employee Attendance Report

                           Emp. ID        Employee Name         In-Time       Out-Time      Attendance
                             201       Sonia                     09:30          06:15      Present
                             202       Atul                      09:43          07:10      Present
                             203       Rajeshwari                08:45          05:45      Present
                             204       Rohit                     10:15          02:20      Absent
                             205       Neha                      09:03          06:43      Present

              a.  Increase the In-Time of Rajeshwari by 15 minutes. Apply the features of recording change to record this change.
              b.  Sort the In-Time column in ascending order.


            Previous Years’ Questions



               1.  Macros are especially useful to ............................. the same way over and over again.    [2023]
                 (a)  repeat a task                            (b)  reject a task
                 (c)   report a task                           (d)  comment a task
             Ans.  (a)




                                                                                 More About Spreadsheet        235
   232   233   234   235   236   237   238   239   240   241   242