Page 265 - open office
P. 265

Function                               Result (Considering a number as X)

                   PRODUCT(   )        It multiplies all the given arguments.

                                       E.g.,  PRODUCT(5 2 3)   3 ,  PRODUCT(-5 6  )


                             N ot e s

                            AUTOSUM is a shortcut tool for adding the values of a range of cells. To do so:
                                                                          f a range o
                                                                                   f cells. T
                            A A UT OSUM is a shor t t cut t ool for adding the v alues o f a range o f cells. T o do so:
                                OSUM is a shor
                                                  ool for adding the v
                             UT
                                                                    alues o
                                              cut t
                                                                                          o do so:
                                                  o be added
                                                                                                           ar
                                                  o be added
                                                                                                     mula b
                                                                                                           ar
                                                  t
                                                                                                             . The sum
                                            f cells
                                                                                                             . The sum
                                            f cells
                                                  t
                                                                               osum
                                                                                        on near
                                                                                        on near
                                                                                    butt
                                                                                    butt
                                                                               osum
                                                             and click on the Aut
                                                                                                     mula b
                                                             and click on the Aut
                                                                                               the for
                                                                                               the for
                            Select the range
                            Select the range
                            Select the range of cells to be added and click on the Autosum button near the formula bar. The sum
                                           o
                                           o
                            is displayed in the next cell.
                            is display ed in the next cell.
                 Date and Time Functions
                 We can add the date and time in a cell. Built into Open Office Calc are a number of DATE and TIME functions
                 that can be used to do this.
                         Function                                             Result
                     TODA ()                  Produces the current date; it contains no argument.
                      OW()                    Produces the current date and time; it contains no argument.
                                              Returns the year from a date value. E.g.
                     YEAR(“Date”)
                                               EAR(DATE(2     3  2))
                                              Returns the month from a date value (1-12). E.g.,
                     MO TH( Date )
                                              MO TH(DATE(2     3  2)) returns  3  for March.
                                              Returns the day of the month from a date value. E.g.,
                     DAY(“Date”)
                                              DA (DATE(2     3  2))
                 Statistical Functions
                 Statistical Functions take numeric argument(s) and produce results accordingly. Following are the different
                 types of statistical functions.
                    Function                                              Result
                   AVERAGE( )       Produces the average (mean) of the given arguments.
                                    E.g., A ERA E(1  2  3 ) Displays output: 2
                                     A ERA E(A1 A2 A3) Displays the average of the cells A1, A2 and A3
                                     A ERA E(A1:A1 ) Displays the average of the cells from the range A1 to A1
                   MAX( )           Produces the largest value from the given range of cells.
                                    E.g.,  MA (1  2  15 25) Displays output:25
                                     MA (A1:A5) Displays the largest value from cell A1 to A5.
                                    =MAX(B2:C4) Displays the largest value of cells B2, B3, B4,C2, C3 and C4.






                                                                                     Working with Spreadsheet       265
   260   261   262   263   264   265   266   267   268   269   270