Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 27 - 2612_Digimind
P. 27

    uiz   Bee        Write the use of custom sorting.
                                              _________________________________________________________________

                            Hashtag

                          #SUM(): This function is used to calculate the total of a given set of values
                          #IF(): This function is used to check a condition to be evaluated as True or False

                          REVISIT

                       ▶   The SUM() function calculates the total of a given set of values.
                       ▶   The IF() function checks a condition to be evaluated as True or False, and based on the result, suitable
                         actions are performed.
                       ▶   The physical arrangement of data in ascending or descending order is called sorting.
                       ▶   The feature of viewing rows of data suiting a specified selection criterion is called filtering data.

                     1.  Tick ( ) the correct option.
                        a.   A teacher has a large list of students and wants to display only those students who scored more than
                           80 marks. Which Excel command should be used to filter the data?
                            (i)  Sort & Filter                                (ii)  Data Validation
                           (iii)  Pivot Table                                 (iv)  Conditional Formatting

                        b.   While creating a marks sheet, Arjun wants Excel to display “Pass” if a student scores 40 or more and
                           “Fail” otherwise. Which Excel function will help him check this condition and give the result?
                            (i)  SUM()                                        (ii)  AVERAGE()
                           (iii)  IF()                                        (iv)  COUNT()
                        c.   Neha has entered student marks in an Excel sheet and wants to arrange them from highest to
                           lowest to prepare a merit list. Which Excel feature should she use?
                            (i)  Filtering                                    (ii)  Data Validation
                           (iii)  Conditional Formatting                      (iv)  Sorting

                        d.   Kanika is preparing the monthly expense report in Excel. She wants to find the total amount spent
                           by adding all the values in a column. Which Excel function should she use?
                            (i)  AVERAGE()                                    (ii)  SUM()

                           (iii)  IF()                                        (iv)  MAX()

                                                                                             Advanced Features of Excel  25

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