Page 33 - ThinkGPT_V2.1_C6_Flipbook
P. 33

Let us use the mathematical functions in Excel. To use the mathematical functions, follow the given steps:












                                                                                             2   To  calculate  the
                                                                                            price  of  Pencils, type
                    1  Type the
                                                                                            the =PRODUCT(B3:C3)
                    following data
                                                                                            function  and  press  the
                    in  the  Excel
                                                                                            Enter key.
                    worksheet.



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






















                                                   3  To calculate the subtotal, type the =SUM(D3:D5)
                                                  function and press the Enter key.











                                                                                            4  Calculate the Tax
                                                                                            by using the =D6*C7
                                                                                            formula.




                               5  Calculate the Total by using the =SUM(D6:D7) function.








                                                                              Formulas and Functions in Excel  31
   28   29   30   31   32   33   34   35   36   37   38