Page 35 - TP_Pluse_V2.2_Class_7
P. 35

4.  Long answer type questions.
                    a.  What is the difference between sorting data and filtering data?
                         ______________________________________________________________________________
                         ______________________________________________________________________________
                         ______________________________________________________________________________

                    b.   Write the steps to apply conditional formatting.
                         ______________________________________________________________________________
                         ______________________________________________________________________________
                         ______________________________________________________________________________

                    c.  Write the steps to apply Custom Sort feature.
                         ______________________________________________________________________________
                         ______________________________________________________________________________

                         ______________________________________________________________________________


                 5.  Competency-based/Application-based questions.
                    a.   John is preparing a list of students with their marks obtained in exams. He wants
                       to arrange the data in ascending order according to the students names. Suggest
                       him a feature of Excel which helps him in doing his work quickly.
                    b.   You are tracking student participation scores from 0 to 100. How would you use Conditional
                       Formatting to highlight scores below 50 in red and above 80 in green? What are the benefits of
                       this approach?




                                                                                       teCh Zone



                    Let's soLve                                                                21 st
                                                                                             Century   #Critical Thinking
                       Guess who am I?                                                         Skills

                       a.   I am a group of the Home tab that contains the Sort & Filter command.      ____________
                     b.   I am a feature in Excel to separate unwanted data from a range of data.      ____________
                     c.   I am a feature in Excel to arrange data in ascending or descending order.    ____________
                     d.  I am a type of formatting that can be applied on the basis of a criteria.     ____________
                     e.  I am the order in which the data is arranged from smallest to largest.        ____________

                                                                                            21 st
                     Let's exPLore                                                       Century   #Leadership & Responsibility
                                                                                           Skills
                       Find out the various ways in which people organise data to make their everyday work easier.
                     You can start this by asking a shopkeeper.











                                                                                        Advanced Features of Excel  33
   30   31   32   33   34   35   36   37   38   39   40