Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 16 - 2607_Trackpad_Pro_5.1_flipbook_C6
P. 16

    b.  Comparison operators   ________________________________________________________________

                          ______________________________________________________________________________________

                         c.  Reference operators    ________________________________________________________________

                          ______________________________________________________________________________________

                      5.  Differentiate between the following:
                         Relative Cell Referencing                                    Absolute Cell Referencing

                         __________________________________                      __________________________________
                         __________________________________                      __________________________________

                      6.  Competency-based/Application-based questions.                                  Experiential Learning

                         a.   Alisha was working on Excel and wanted to compare two data sets to determine the
                            outcome. She's not sure which operator to use. Inform her about the appropriate
                            operator she should use to resolve this.
                          _____________________________________________________________________________________

                         b.   Mansi has made a spreadsheet for the marks obtained by the students of her class in different
                            subjects. Which feature should she use to keep the spreadsheet updated if she has to change marks
                            in one of the subjects of any student?

                          _____________________________________________________________________________________
                         c.   Sonia is creating project information in a spreadsheet, and she wants to estimate an employee's
                            basic salary using the formula (D2-C2*1.5). However, nothing happens after typing the formula into
                            the formula bar. What must she have missed in the formula to produce the proper result?

                          _____________________________________________________________________________________

                         LAB ACTIVITY                                                                      Subject Enrichment

                        Visit your computer lab and perform the following actions:
                        ▶  Enter the following data in Excel:

                          (a)   Find the number of matches lost by each team by using the subtraction formula.
                          (b)   Compare the performance of India and Pakistan by checking if India won more matches than
                               Pakistan.
                          (c)   Calculate the win percentage of each team.

                       14   Premium Edition-VI

| 11 12 13 14 15 16 17 18 19 20 21 |