Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 154 - 2612 Digimind C6
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   Premium Edition-VI

| 149 150 151 152 153 154 155 156 157 158 |