Page 30 - TP_iPlus_V2.1_Class8
P. 30

Functions                        Purpose                                 Example

                                                                                   Age = 18
                                                                                   Score = 85
                                      This function returns TRUE if
                   AND(condition1,
                                      all specified conditions are true;           Input:
                   condition2, ...)
                                      otherwise, it returns FALSE.                 =AND(Age >= 18, Score >= 60)
                                                                                   Output: TRUE
                                                                                   Age = 16

                                      This function returns TRUE if at least       Score = 85
                   OR(condition1,
                                      one of the specified conditions is true;  Input:
                   condition2, ...)
                                      otherwise, it returns FALSE.
                                                                                   =OR(Age >= 18, Score >= 60)
                                                                                   Output: TRUE

                     Quick Byte




                            The common functions like SUM, AVERAGE, MAX, and MIN, can
                          also be used by using the down arrow of the AutoSum command.

                            To use other functions, click on the More Functions option.






                   i +   COMMON ERRORS
                  Sometimes  when we use wrong  type of data,  operand  or operator  in a formula, then error

                  message is displayed. Given below is the list of errors which commonly occur in Excel.

                     Errors                                           Reasons
                                It occurs when the cell contains a number, data or time that is wider than the cell width or
                    ####
                                when the cell contains a date and/or time formula that produces a negative result.
                    #VALUE      It occurs when the wrong type of argument or operand is used.

                    #NAME       It occurs when Excel does not recognize text in a formula.

                    #NUM        It occurs when there is a problem with a number in a formula or function.
                    #REF!       It occurs when a cell reference is not valid.

                    #DIV/0!     It occurs when a formula applying division by zero is used.


                   i +   CHARTS IN EXCEL

                  A chart is a visual or graphical representation of data from a worksheet which is very useful for
                  instant analysis and decision making. There are various options related to charts that can be
                  used to display data in a graphical format. It makes it easier to draw comparisons and analyse
                  the growth, relationships, and trends among the values in a table.


                    28
                         iPlus (Ver. 2.1)-VIII
   25   26   27   28   29   30   31   32   33   34   35