Page 67 - TechPluse_C6_Flipbook
P. 67

AVERAGE(range)         It gives the average of the given        Input: =AVERAGE(16,21,18,7,13)
                                         numbers in a range.                      Output: 15



                  COUNT(Number1,  It returns the count of the number of  Input: =COUNT(6,4,8,9,7)
                  Number 2, …) OR        given values or values in the given      Output: 5
                  COUNT(range)
                                         range of cells.

                 Date Functions


                             Functions                          Purpose                          Example

                  DATE(YEAR, MONTH, DAY)            It returns the date in DD/MM/ Input: =DATE(2019,13,12)
                                                    YY format.                        Output: 13/12/19

                  TODAY()                           It returns the current date of    Input: =TODAY()
                                                    the computer.                     Output: 7/23/2020

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

                                                                                      Output: 2020
                  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 down arrow  of the  Select Function
                        button on the Formula Bar.

                       To use other functions, click on Insert → Function option.


                                                                                               Select Function button



                  Tech


                    Funda
                                     To open Insert Function dialog box: Ctrl +F2











                                                                        Formulas, Functions and Charts in Calc       65
   62   63   64   65   66   67   68   69   70   71   72