Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 54 - Data_Science_Part_A C12
P. 54

    Suppose, the data entered in cells A1, A2, A3 and A4 are 5, 15, 20 and 60 respectively. In cell A5, a formula is entered to
            calculate the sum of these numbers with their cell address; thus it will be displayed as ‘=A1+A2+A3+A4’.

            Here, the output will be 100 that will be displayed in the cell A5 as soon as the ‘Enter’ key is pressed.

            3.10.4 Using Mouse to Select Values

            Using the mouse to select values is a simple and efficient way to create formulas by directly selecting cells instead of
            manually typing their references.
            Perform the following steps to select values using the mouse:
            Step 1:  Click on the cell where you want the result.
            Step 2:  Type = to begin your formula.

            Step 3:  Use the mouse to click on the cell that contains the first value to include in the formula.
            Step 4:  Type an operator like +, -, *, or / to indicate the desired calculation.
            Step 5:  Click on other cells to include them in the formula. Each reference will appear in the formula as you select it.
            Step 6:  Press Enter key to complete the formula and view the result.
                     For example: Type =D2+D3+D4+D5+D6, the result will be 15.

            3.10.5 Functions
                                                                                   =SUM(A1:A5)
            Functions are in-built formula in LibreOffice Calc that can
            be  used  to  perform  arithmetical  and  non-arithmetical
            tasks. A function contains Name and Argument.

                                                                    Name                                Argument

               52   Touchpad Data Science-XII

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