Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 55 - Data_Science_Part_A C12
P. 55

    For Example, A formula, say as A6=A1+A2+A3+A4+A5 can be written using the SUM function along with the cell range
                A6 as: =SUM(A1:A5)

                Name is the name of the function that signifies the nature of operation. Argument specifies the values or the range of
                cells on which the specific operation is being applied and is always enclosed within the opening and closing parenthesis
                (i.e. Name refers to the operator and Argument refers to the operand).

                3.10.6 Mathematical Functions

                These functions perform mathematical calculations on the specified arguments. Some mathematical functions are:
                                                               Table 3.1: A

                      Function                                           Description
                 SUM(X,Y,..)         It produces the sum of the numbers for a range of cells. E.g., =SUM(C1 ...C4), =SUM(C1:C4)
                                     (will produce the addition of cells from C1 to C4)

                 ABS(X)              It produces the positive (absolute) value of a given integer.
                                     E.g., =ABS(-8)=8, =ABS(4)=4, =ABS(-3.7)=3.7
                 INT(X)              It produces the integer value of a given integer.
                                     E.g., =INT(12.54)=12, =INT(-8.72)=-9

                 SQRT(X)             It produces the square root of a positive integer.
                                     E.g., =SQRT(9) = 3, =SQRT(2) = 1.414213562
                 ROUND(X,Y)          It produces the value of X that is rounded to the number of digits specified by Y.

                                     E.g., =ROUND(12.234,2)= 12.23, =ROUND(32.67,0)=33
                 MOD(X,Y)            It produces the remainder of X divided by Y.
                                     E.g., =MOD(11,2) = 1, =MOD(90,2) = 0
                 POWER(X,Y)          It produces the value of X raised to the power of Y.
                                     E.g., =POWER(5,2)=25, =POWER(-5,0.5)=#NUM!

                 PRODUCT(X,Y)        It multiplies all the given arguments.
                                     E.g., =PRODUCT(5,2,3) = 30, =PRODUCT(-5,6,0) = 0
                3.10.7 Date and Time Functions

                We can add the date and time in a cell. Built into LibreOffice Calc are a number of DATE and TIME functions that can be
                used to do this.
                                                               Table 3.2: A

                        Function                                           Description

                 TODAY( )                 Produces the current date; it contains no argument.

                 NOW( )                   Produces the current date and time; it contains no argument.
                 YEAR(“Date”)             Returns the year from a date value. E.g. =YEAR(DATE(2024,3,2))

                 MONTH(“Date”)            Returns the month from a date value (1-12). E.g.,
                                          =MONTH(DATE(2024,3,2)) returns “3” for March.
                 DAY(“Date”)              Returns the day of the month from a date value. E.g., =DAY(DATE(2024,3,2))

                                                                                                     ICT Skills-III  53

| 50 51 52 53 54 55 56 57 58 59 60 |