Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 81 - 2615_KEC
P. 81

    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

                                                                                                         Project Work  79

| 76 77 78 79 80 81 82 83 84 85 86 |