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

    When you point to the highlighted cell with the mouse pointer, it can be observed that a reference to the type
                of change, name of the author, date, and time, is displayed.
            2.  What is a comment? List the steps to add a comment.
         Ans.  Comment refers to the text that gets displayed when we click the highlighted cell after activating Record Changes.
              For example, information such as the cell with the previous value and changed value, name of the user who made
              the change, and date and time of change, is displayed. Steps to add a comment are:
                  Select the cell in which a ‘Comment’ is to be inserted.
                  Right click and select the ‘Insert Comment’ option. Comment box will appear on the screen.
                  Type the desired comment.
                  Click outside the box to close it. The box in which the comment has been added appears with a coloured dot in
                the upper right-hand corner.
                  To view a comment, hover the mouse pointer over the cell that has a comment. The comment of that cell gets
                displayed.
            3.  Write the steps to review changes.
         Ans.  The steps to review changes are:
                  Open the edited worksheet.
                  Click the Edit menu and Select the Changes option.
                  Click the ‘Accept or Reject’ option from the sub-menu that appears. ‘Accept or Reject’ dialog box appears on the screen.
                  According to the suggested review, you have to make a decision to accept it or reject it.
            4.  What is a Macro?
         Ans.  Macro refers to a set of instructions/functions that can be used to automate processes that require repetition,
              either fre uently or within a specified time interval  in the same manner.  hey are saved se uences of commands
              or keystrokes that are stored for later use.
            5.  What do you mean by Passing Argument to a Macro?
         Ans.  Passing Argument means to pass the argument in the calling function to the corresponding formal parameter of
              the called function. The called function can modify the value of the argument by using its reference passed in.
              To illustrate a function that accepts arguments, we will write a macro function that accepts two arguments and
              returns the larger of the two. Function Testmax(x,y If x>=y Then TestMax=x Else TestMax=y EndIf End Function
            6.  Explain the steps to print a comment.
         Ans.  The steps to print comments in a spreadsheet are:
                  Click on Format.
                  Select Page option. Page style default dialog box appears on the screen.
                  Click on the ‘Comment’ checkbox.
                  Click on the ‘OK’ button to complete setting up in order to print comments along with the worksheet. Comments
                will get printed along with the worksheet.

             .   hat is the use of comparing different versions of spreadsheet file
         Ans.  While sharing documents, reviewers may forget to record the changes made by them in the original document.
              In such a case   alc can find the changes by comparing the original document with the edited document.  o
              compare, the user requires the original document as well as the edited document.

             .  For the given sheet  create a Macro to find total points for one month.  ow will you use this macro to find total
              points for 3 months stored in sheet2 and sheet3?

         Ans.  Steps are as follows:
              Step 1: Keep the cursor in B6.
              Step 2: Select the Tools   Maros   Record Macro option.
              Step 3: Perform calculation and click on the Stop Recording button. The Macros dialog box will appear.



         232       Touchpad Information Technology-X
   229   230   231   232   233   234   235   236   237   238   239