Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 58 - Data_Science_Part_A C12
P. 58

    Step 8:  Press and hold the mouse button to select the range of cells.

            Step 9:  Click on Shrink button again to insert the range selected.

            Step 10:   Click on the OK button of the Function Wizard. The result will be displayed in the cell G2.

            3.10.11 Auto Fill

            It is a feature in the spreadsheet package like LibreOffice Calc in which a certain kind of predefined series of data such
            as name of months of a year, serial numbers, etc., are automatically generated once the user feeds the initial data.

            3.10.12 Copying and Moving Formula

            To apply the same formula across multiple cells in rows or columns, you don't need to re-enter it for each cell. Instead,
            you can copy the formula to other cells, which saves time and effort, especially with long or complex formulas, and
            minimises the risk of errors.
            (i) Use of Copy and Paste Commands for Copying Formula
            (ii) Use of Cut and Paste Commands for moving Formula

            Step 1:  Select the cell with the Formula you want to copy.
            Step 2:  Click on the Copy/Cut button from the Standard toolbar.
                     OR
                      Press Ctrl + C to copy the formula.

                      Press Ctrl + X to move the formula.
            Step 3:  Select the destination cell where you want to paste the formula.

               56   Touchpad Data Science-XII

| 53 54 55 56 57 58 59 60 61 62 63 |