Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 150 - logicode 2609 C6
P. 150

    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

                      148   Premium Edition-VI

| 145 146 147 148 149 150 151 152 153 154 155 |