Page 28 - TrackpadV5.1_class7
P. 28

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?
                      _______________________________________________________________________________

                      _______________________________________________________________________________

                     d.  What are the two types of sorting available in Excel?
                      _______________________________________________________________________________

                      _______________________________________________________________________________





                   26   Pro (V5.1)-VII
   23   24   25   26   27   28   29   30   31   32   33