Page 29 - Trackpad_ipro 4.1_Class8
P. 29

The current month will appear. You can also give reference of a cell containing the date to the
                 MONTH() function. Similarly, we can use the YEAR() and DAY() functions to get the year and
                 day from a date, respectively.

                 Logical Functions

                      Function                      Purpose                                 Example

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

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


                  Tech

                    Funda


                                      ✶ 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 an effective way to display data in a pictorial form. It makes it easier to draw comparisons
                 and analyse growth, relationships, and trends among values in a table.

                 Components of a Chart

                 The various components of a chart are as follows:
                    Chart Title: The chart title describes the aim and content of the chart.

                    X-axis: X-axis, also known as category axis, is the horizontal axis of the chart.
                    Y-axis: Y-axis, also known as value axis, is the vertical axis of the chart.

                    Plot Area: Plot area is  the rectangular area bounded by the two axis that contains the actual
                    chart and includes plotted data.


                                                                             Spreadsheet—Functions and Charts    27
   24   25   26   27   28   29   30   31   32   33   34