Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 27 - 2610_Springdales_C-7
P. 27

    Follow these steps to get the required information:

                                                                2   Click on the Marks Obtained
                                                                    in Second Term header.

                                       1   Apply  filters to
                                           the data.

                            3   Place your mouse over the
                                Number Filters option.

                                                                                    4   Select the Greater
                                                                                        Than option.

                          5   Enter 80 in the
                              criteria box.
                                                                                                        Click on the   6
                                                                                                        OK button.

                     Notice that only the details of the students who have obtained marks greater than 80 are displayed and
                     the remaining rows remain hidden.

                     Removing Filters

                     Once applied, the filters are easily removable. Click anywhere in the worksheet and repeat steps to
                     apply filters. You'll notice that the filter arrows in front of column headers disappear, and the hidden
                     rows also reappear.

                              Topic Flashback                                                     21 st  Century   #Critical Thinking
                                                                                                      Skills
                            Tick ( ) the correct statements.

                            1.  Sorting of data means to organise the data in ascending or descending order.

                            2.  Excel allows you to sort only one column.

                            3.  The filters once applied cannot be easily removed.

                            4.  Excel allows you to filter unwanted data from a set of data.

                                                                                          Advanced Features of Excel    25

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