Page 21 - TrackpadV2.1_Class8
P. 21

The sum is displayed
                                                                                   in the active cell.









                                             Subject: How to calculate average

                                             To calculate the average of given numbers in defined range of cells,
                                             enter  the formula  =AVERAGE(number1,  number2, number3,  ...
                                             number n). For example, =AVERAGE (4,5,6) will be 5.






                           IF()


                 The IF() function checks a condition to evaluate whether it as true or false and based on the
                 result, suitable actions are performed. This function takes three arguments into consideration:
                 the condition, the value to be displayed when the condition is true, and the value to be displayed
                 when the condition evaluates to be false.


                                                         2  Click on the Formulas tab.




                    3  Click on the
                   Insert Function
                   command.



                                                                                                      1  Select the
                                                                                                     cell where you
                                                                                                     want the result
                                                                                                     to be displayed.











                                                                                         Advanced Features of Excel  19
   16   17   18   19   20   21   22   23   24   25   26