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

