Page 31 - C_GPT _V4 _class_7
P. 31

4.   If the existing Conditional Formatting rules do not meet your requirements, which option will you use
                           to create your own rules?














                        Scratch Your Brain.                                                        21 st  Century   #Critical Thinking
                                                                                                       Skills
                                                                                                           #Initiative
                       1.  Analyse the following data and answer the questions given below:

                            Roll No.  Name      Age   Gender    Grade   Math Score     Science Score    English Score

                            101       Rahul     17    Male      11      85             78               82
                            102       Priya     16    Female    10      92             85               88

                            103       Rohan     18    Male      12      78             80               75

                            104       Nisha     17    Female    11      88             90               85

                            105       Sameer    16    Male      10      90             85               80

                           a.  Which feature is used to display the records of female students only?

                           b.  Which feature is used to arrange the data in the descending order of English Score?

                           c.  Which feature is used to highlight the cells in the Grade column where grade is 10?

                       2.   Competency-based/Application-based questions:

                           a.   Anika is responsible for organising and prioritising tasks for her team using Excel.
                             She wants to sort the tasks based on the priority, where tasks with the same priority
                             are sorted alphabetically by their names. What can she do to achieve this?
                           b.  Ravi has the following data in an Excel worksheet:


                                  Name          Marks
                              Divya         97

                              Mihir         76
                              Tanya         88

                              Rishi         89
                              Shivam        78

                                He wants to sort the data according to the names of students. Help him by writing the steps to do so.










                                                                                      Advanced Features of Excel    29
   26   27   28   29   30   31   32   33   34   35   36