Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 23 - 2612_Digimind
P. 23

    4  Select the Logical option from the
                                       Or select a category drop-down list.

                                                                                7  Fill the required details. Now you will notice
                                                                                that the condition is evaluated to be true and
                                                                                the result is displayed below the IF frame.

                       5  Select the
                      IF function.

                                                   6  Click on the OK button.                     8  Click on the OK button.

                     In the Logical test box, provide a condition that evaluates to be true or false. In the Value_if_true
                     box, provide a value that you want to display in the active cell if the condition evaluates to be true.
                     Similarly, in the Value_if_false box, provide a value that you want to display in the active cell if

                     the condition evaluates to be false.

                          Tick ( ) if you know this.

                          ▶   The IF function allows us to check a condition and take action based on the results.
                          ▶  The SUM function calculates the total of a given set of values.

                               SORTING DATA IN EXCEL

                     It is easy to maintain data in Excel as the sheet is divided into rows and columns but the data may
                     not be arranged in a specific order automatically as we enter it.

                     For such a purpose, Excel provides us with a feature called sorting. It is present in the Home tab

                     under Editing group. Sorting means arranging the data either in ascending or descending order.
                     Data can be sorted in two ways:

                       Ascending order: Arranging data in increasing order, for example, letters from A to Z, numbers
                       from lowest to highest, etc.

                       Descending order:  Arranging data  in decreasing  order, for example, letters  from Z  to  A,
                       numbers from highest to lowest, etc.

                                                                                             Advanced Features of Excel  21

| 18 19 20 21 22 23 24 25 26 27 28 |