Page 26 - Touchpad_Plus_V3.2_Class 7
P. 26

Date Functions

                  Some of the date functions are given in the table below:

                              Functions                          Purpose                          Example

                   DATE(YEAR, MONTH, DAY)            It returns the date in DD/MM/ Input: =DATE(2024,23,7)
                                                     YY format.                        Output: 23/7/2024
                   TODAY()                           It returns the current date of    Input: =TODAY()

                                                     the computer.                     Output: 7/23/2024
                   MONTH(TODAY())                    It returns the current month.     Input: =MONTH(TODAY())

                                                                                       Output: 7
                   YEAR(TODAY())                     It returns the current year.      Input: =YEAR(TODAY())

                                                                                       Output: 2024
                   DAY(TODAY())                      It returns the current day.       Input: =DAY(TODAY())

                                                                                       Output: 23

                   Clickipedia



                         The common functions like SUM, AVERAGE, MAX, MIN and COUNT
                        can be used by using the functions from the properties pane.
                        To use other functions, click on Insert → Function option.






                                                                                                Select Function button


                           Tech Funda



                         To open Insert Function dialog box: Ctrl +F2





                      CHARTS IN CALC
                  A chart is an effective way to display data in a pictorial form. It makes it easier to draw comparison
                  and analyse the growth, relationship and trends among the values in a table.

                  Components of a Chart

                  A char has the following components:
                       Chart Title: Chart title describes the main aim and content of the chart, which represents
                     your chart.

                       X-axis: X-axis is the horizontal axis of the chart. It is also called the category axis.

               24       Plus (Ver. 3.2)-VII
   21   22   23   24   25   26   27   28   29   30   31