Page 30 - iPro_trackGPT_V5_Class8
P. 30

Logical Functions


                        Function                         Purpose                                Example

                                          It checks whether the given condition     Percentage = 80
                   IF(condition, value1,  is met,  and  returns  value1  if the  Input: =IF(Percentage  >= 50,
                   value2)                condition evaluates to true, and value2  “Passed”, “Failed”)
                                          if the condition evaluates to false.      Output: Passed
                                                                                    Age = 18

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

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


                               Tech Tweak

                            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.



                     CHARTS IN EXCEL

                  A chart is a graphical representation of data designed to make information easier to understand
                  and analyse. It helps you compare numbers, observe changes over time, and identify patterns or
                  relationships. Charts use visual elements such as bars, lines, or slices to simplify the process of
                  viewing and analysing data.

                  Components of a Chart

                  The various components of a chart are as follows:
                     Chart Title: The chart title explains the main purpose and content of the chart.

                     X-Axis: The x-axis is the horizontal axis of the chart, commonly known as the category axis.
                     Y-Axis: The y-axis is the vertical axis of the chart, commonly known as the value axis.

                     Plot Area: This is the rectangular section between the X and Y axes. It displays the actual
                     chart, including the plotted data, data series, category, and value axes.




                    28    TrackGPT iPRO (V5.0)-VIII
   25   26   27   28   29   30   31   32   33   34   35