Page 21 - Trackpad_V1_Book 7_Flipbook
P. 21

5  In the or select a category
                       box, select the Logical option.

                                                                    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.













                         4  Select IF function.




                                       6  Click OK button.                                  8  Click 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 is called sorting. 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  19
   16   17   18   19   20   21   22   23   24   25   26