Page 154 - trackpad v5.1 class 6 flipbook
P. 154

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























                  152   Pro (V5.1)-VI
   149   150   151   152   153   154   155   156   157   158