Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 31 - 2610_Springdales_C-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 |