Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 58 - 2611_SmartGPT Pro V(5.0) C-5
P. 58

    Functions                            Purpose                                Example

                                                                                              Input:
                       Average(range)       It returns the average of the given               =AVERAGE(12,3,6)
                                            numbers in a range.
                                                                                              Output: 7

                                                                                                                PURE
                          In functions, we can also use the cell address in place of the values.                FACT

                      Perform the following steps to use the mathematical functions:

                                 1  Type the given
                                data in the Excel
                                worksheet.

                                                             2  To calculate the price of Pencils,
                                                            type the =PRODUCT(B3:C3) function
                                                            and press Enter key.

                                                                                                         4  Calculate the
                                                                                                        Tax by using the
                                                                                                        =(D6*7)/100
                                                                                                        formula.

                         3  To calculate the subtotal, type                   5  Calculate the
                        the =SUM(D3:D5) function and                         Total by using the
                        press Enter key from the keyboard.                   =SUM(D6:D7) function.

                      When you press the Enter key, the price of the pencils appears in cell D3. Using the AutoFill
                      feature, we can calculate the prices of the Geometry Boxes and Pens.

                      Text Functions

                      Text functions are used to work on the characters entered as text.

                       56   Computer Science (V5.0)-V

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