Page 56 - TP_Prime_v2.2_Class_6
P. 56

Step 2:  To calculate  the price of Pencils, type  the  =PRODUCT(B3:C3) function  in  the
                           cell D3.

                  Step 3:  Press the Enter key from the keyboard.
                  When you press the Enter key, the price of the pencils appears in cell D3. Using the Auto

                  Fill feature, we can calculate the prices of the Geometry Boxes and Pens.
                  Step 4:  To calculate the subtotal, type the =SUM(D3:D5) in the cell D6.
           Prime (Ver. 2.2)-VI  When you press the Enter key, subtotal appears in the cell D6.
                  Step 5:  Press the Enter key from the keyboard.



                  Step 6:  Calculate the Tax by using the =(D6*7)/100 formula.

                  Step 7:  Calculate the Total by using the =SUM(D6:D7) function. Final output appears as
                           shown:




          54


















                                                         Using PRODUCT Function
















                                     Using SUM Function                          Displaying Total

                  Text Functions

                         Function                       Purpose                                Example

                   CONCATENATE           It joins together  two  or more  Input: =CONCATENATE(“Touch”,
                   (text1, text2)        different text strings.                 “pad”)

                                                                                 Output: Touchpad
   51   52   53   54   55   56   57   58   59   60   61