Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 28 - 2612_Digimind
P. 28

    e.   A teacher has a student mark list sorted according to Roll Numbers. Now, she wants to arrange the
                            same data alphabetically by Student Name without removing the existing data. Which Excel feature
                            should she use?
                             (i)  Sort A to Z                                  (ii)  Filter

                            (iii)  Custom Sort                                 (iv)  Sort Z to A
                      2.  Fill in the blanks using the words from the help box.

                                                     Sort A to Z, IF, Custom Sort, Filter

                         a.  The _____________ command is used to display only the rows of data that meet certain criteria.

                         b.   The  _____________ function  in Excel checks  a condition  and returns different values based  on
                            whether the condition is true or false.
                         c.   To add another column to sort data within a sorted column, you can use the _____________ option
                            in Excel.
                         d.  To sort data in ascending order, you would select the option _____________ in the Sort & Filter menu.

                      3.  Write 'T' for true and 'F' for false.

                         a.  The SUM() function is used to calculate the average of a given set of values.

                         b.  Excel allows us to see the important data and hide the rest data temporarily.

                         c.  Sorting data in Excel cannot be done in descending order.

                         d.  Custom sorting allows you to sort data based on multiple columns.

                      4.  Answer in one or two words.
                         a.  What is the physical arrangement of data in ascending or descending
                            order is called?                                                                ____________
                         b.  Which feature helps you view only specific data in Excel?                      ____________

                         c.  What type of formatting in Excel changes cell appearance based on conditions?   ____________
                         d.  Which tab in Excel contains the Insert Function command?                       ____________

                      5.  Think and answer.
                         a.  What steps are involved in applying a filter to data in Excel?
                          _______________________________________________________________________________

                          _______________________________________________________________________________

                         b.  How can you sort data by multiple columns using Custom Sort in Excel?
                          _______________________________________________________________________________

                          _______________________________________________________________________________

                         c.  What is conditional formatting, and how is it used in Excel?
                          _______________________________________________________________________________
                          _______________________________________________________________________________

                       26   Premium Edition-VII

| 23 24 25 26 27 28 29 30 31 32 33 |