Page 235 - IT 402 v2.0 class 10
P. 235
Step 4: Select the Library Module option and give name to the macro (TOTALPOINTS in this example).
Step 5: Click on the Save button.
To run a macro for other months to find total points follow the given steps:
Step 1: Goto next sheet and place the cursor on the cell where total points are required.
Step 2: Select the Tools Macro Run Macro option. The Macros dialog box will appear.
Step 3: Select the Library Module option and type macro name.
Step 4: Click on the Run button.
Step 5: Repeat the steps for sheet3.
S ub j e ct E nr ich me nt
B. Application based questions:
. he following data is from the final result sheet of an educational institution. nswer the uestion that is followed
under the worksheet.
SCHOOL MARKS
SCHOOL MARKS REPORT
Roll No. Students Name Eng Hindi Math Science Total Per
101 ABC 35 37 42 41 155 77.5
102 PQR 37 41 45 46 169 84.5
103 MNO 31 40 42 45 158 79
104 LMN 33 39 44 42 158 79
105 XYZ 36 38 47 40 161 80.5
a. Increase the Total marks of each student by 3 marks. Apply the features of recording change to record those
changes.
b. Add comment to display “Marks of English” in place of Eng, “Marks of Hindi” in place of Hindi, “Marks of Maths”
in place of Maths, “Marks of Science” in place of science, “Percentage Marks” in place of Per.
Ans. a. Write the formula as =Total + 3 or =Cell address of Total marks + 3. To apply features of Record Changes to
record those changes are:
Open the given worksheet to record changes.
Click on Edit and Select the Changes option.
Click on the ‘Record’ option from the sub-menu that appears.
Now start making changes in the spreadsheet document. The changed cells become highlighted by a border
around the cells.
Calc automatically adds a comment to the recorded changes that have been done along with the author’s
name, date, and time of the creation of this comment in the comment box.
b. Steps to use Add Comment to display the above comments:
Select the cell in which omment is to be inserted here the cell with ng written in it first the one with
Hindi written in it next, and so on).
Right click and select the ‘Insert Comment’ option.
The comment box appears on the screen. Type the desired Comment.
Click outside the box to close it. The new comment gets inserted.
2. Hema is a chartered accountant. She used to maintain the accounts in a spreadsheet on everyday basis. There is
a number of steps which she needs to follow every time. Can you suggest her a feature of spreadsheet through
which she can perform these tasks quickly without repeating the steps every time? [CBSE Sample Paper, 2022]
a. Record Changes b. Track Changes
c. Goal Seek d. Using Macros
Ans. Using Macros
More About Spreadsheet 233

