Page 22 - TrackpadV2.1_Class8
P. 22

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. However, the

                  data is not automatically arranged in a specific order when 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 smallest to largest, etc.

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




                   20   Trackpad (V2.1)-VII
   17   18   19   20   21   22   23   24   25   26   27