Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 30 - 2610_Springdales_C-7
P. 30

    2.   Ankita has a list of students with their final examination marks. She wants to display the records of the
                            students from the list who scored 90 marks in the final examination. Which option will help her?

                                   a. Sort A to Z                                 b. Number Filters

                                   c. Sort Smallest to Largest                    d. None of these
                         3.   Which  of the following  options  is used  when  you  want to highlight  all the  cells satisfying  a given
                            condition?

                                   a. Data Bars                                   b. Color Scales

                                   c. Top/Bottom Rules                            d. Highlight Cells Rules

                         4.  Smallest to Largest option is used to             .

                                   a. Sort numbers                                b. Sort text

                                   c. Both a. and b.                              d. None of these

                         5.  If you want to remove conditional formatting from a spreadsheet, which option will you choose?

                                   a. New Rule                                    b. Clear Rules

                                   c. Remove Rules                                d. Delete Rules

                          Tick ( ) the correct statements and cross ( ) the wrong ones.

                         1.  Excel allows you to sort both numeric and textual data.

                         2.  You can sort the data according to a particular column as well as a range of data.

                         3.  The Sort & Filter option is used to apply filter to a column.

                         4.  Excel does not allow you to use a custom filter.

                    Q    Answer the following questions:
                      A
                         1.  What is the difference between sorting and filtering?

                         2.  Name any four options present under the Highlight Cell Rules command.

                         3.  What is the purpose of the Data Bars option under the Conditional Formatting command?

                            Premium Edition-VII
                     28

| 25 26 27 28 29 30 31 32 33 34 35 |