Page 82 - KEC Khaitan C6 Flipbook
P. 82

Project Work




                     1.   Create the following worksheet in Excel and perform            21 st   #Technology Literacy
                        the given operations:                                          Century   #Productivity & Accountability
                                                                                         Skills






















                        a.  Calculate the total bill amount using the SUM function.

                        b.   Change the bill amount of the patient having P_ID as P0023 and observe the changes
                           in the Total Amount.
                                                                                     21 st   #Technology Literacy
                     2.   Enter the following data in Excel:                       Century   #Productivity & Accountability
                                                                                     Skills












                        Perform the following tasks:

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

                     3.  Enter the following data in Excel and draw a line             21 st   #Technology Literacy
                        chart and column chart.                                      Century   #Productivity & Accountability
                                                                                      Skills





















                   80   Premium Edition-VI
   77   78   79   80   81   82   83   84   85   86   87