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

