Page 180 - IT 402 v2.0 class 10
P. 180

Sales in February Month



















        Sales in March Month


















          new worksheet is inserted and renamed as   uarter Sales  to store the  otal Sales of each item.
         otal Sales  of  individual  items  must  be automatically  calculated and stored in    uarter Sales  worksheet
        through cell referencing using keyboard.

         o calculate  otal Sales of  en  i.e.  to make the cell reference in cell   :
          Select the cell    in   uarter Sales  worksheet.

           ype the formula in the cell     :  S M  anuary.   February.   March.   .




                                                                      en press ‘Enter’
                                                                       key to get the
                                                                      resultant ‘Total
                                                                       Sales’ of Pen.




















           epeat the above steps for rest of the items.



         178       Touchpad Information Technology-X
   175   176   177   178   179   180   181   182   183   184   185