Page 30 - C_GPT _V4 _class_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?









                        CodeGPT (Ver. 4.0)-VII
                 28
   25   26   27   28   29   30   31   32   33   34   35