Page 396 - Trackpad 402_Class-X_Final
P. 396
Sheet 2
Name July Pocket Money
Amit 900
Sumit 1100
Naina 1300
Suman 1200
Kamal 1250
10. Consider the given table mentioning student's details and perform the following:
Rollno Class Name Phone_no
1 XII Sumit 1234565
2 X Amit 3564583
3 X Anuj 1236589
4 XI Mini 5869542
• Display all the records of table Student.
• Insert one record of your choice.
• Display record of student whose roll number is 3.
• Display record of students who are in class ‘X’.
• Display the record of ‘Anuj’
11. Create an invoice in OpenOffice Calc as given.
• Fill-up details of five items, their quantities and unit prices.
• Using PRODUCT function, calculate the amount for each item.
• Using SUM function, calculate the total amount.
• Using formula, calculate the GST according to the given rate.
• Calculate Invoice amount payable.
12. Make a list of your 10 friends in OpenOffice Calc. Make columns for the distance of their home from school,
distance of post office from their home, etc.
Use sorting to arrange data in an order. Highlight the cells which have distance less than 2.5 km in any cell.
396 Trackpad Information Technology-X

