Page 142 - Trackpad_V5_Book 6
P. 142

Project





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





















                  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
                                                                                         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 chart and column chart.

                                                                                          21 st   #Technology Literacy
                                                                                        Century
                                                                                         Skills  #Productivity





















            140   Pro (Ver. 5.0)-VI
   137   138   139   140   141   142   143   144   145   146