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
   230   231   232   233   234   235   236   237   238   239   240