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

