Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 57 - Data_Science_Part_A C12
P. 57

    3.10.10 Entering Function in a Cell

                Functions are entered in a cell to produce the output of data. Following are the steps to enter function in a cell:
                Step 1:    Select the cell in which the output has to be displayed or
                        function is to be inserted. (Here, cell G2 has been selected
                        to enter the function.)
                Step 2:  Click on Insert menu from Menu bar.
                Step 3:  Select the Function option from drop-down menu.
                         OR

                          Click on the fx button from the Formula Bar. ‘=’ sign will appear in the Formula bar and the Functions
                         Wizard dialog box appears on the screen. On the left side of the wizard, different categories for the type of
                         data, calculation or analysis are displayed like: Database, Date & Time, Financial, Logical, etc. On the right side,
                         the corresponding in-built function is displayed.
                Step 4:  Select the Category as Mathematical from the list box.

                Step 5:  Select the Function as SUM from drop-down menu.
                Step 6:  Click on the Next button.

                Step 7:  To fill the range of cells to be calculated click on the Shrink button next to the Number 1 text box.

                                                                                                     ICT Skills-III  55

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