Page 118 - Chinmaya_C6_flipbook
P. 118

Project




                     1.   Create the following worksheet in Excel and perform the given
                        operations:                                                                  Subject Enrichment






























                        a. Calculate the total bill amount using formulas.

                        b.  Change the bill amount of the patient having P_ID as P0023 and observe the changes
                           in the Total Amount.


                     2.   Enter the following data in Excel:                                        Subject Enrichment



















                        Perform the following tasks:


                        a.  C2   =(A2*B2)      b.  C3   =(A5=B3)      c.  E5   =COUNT(A2:B5)












                   116  Premium Edition-VI
   113   114   115   116   117   118   119   120   121   122