Page 422 - IT 402 v2.0 class 10
P. 422
13.
• he cells containing marks greater than or e ual to should be highlighted with ood cell style.
• he cells containing marks greater than or e ual to and less than should be highlighted with
Neutral cell style.
• The cells containing marks less than 70 should be highlighted with Bad cell style.
Subjects
Student Name Hindi English Maths Science Computer Science
Amit 67 77 90 85 98
Divya 87 65 80 98 73
Chirag 78 90 67 85 92
Anshika 96 84 99 75 62
14.
Date of Marks
Reg No. Name Grade
Submission Obtained
T/121/15 Anshu Verma 11/07/15 18 A
T/137/15 Anjali Kumari 12/07/15 20 A+
T/145/15 Deepak Kohli 14/07/15 17 B+
• Name the table as ‘Marks Distribution’.
• Enter atleast 3 records.
• Sort the data on the basis of grades.
Roll No. Name Date of Birth Phone No. Place
A001 Manan upta 12/09/1987 2354667667 Delhi
A002 Ryansh Sharma 09/05/1986 3435555555 Chattisgarh
A003 Rahul John 02/05/1990 656554432 Mumbai
• Sort the place in decreasing order.
• Set Roll No as the primary key.
• Delete the record no. A002.
• Add another record.
16. Create the following table for the Library Management System.
Book ID Books Publication Price Quantity
1 Touchpad Orange Education 296 10
2 Pratibha Madhuban 256 20
3 Cyber Olympiad Orange Education 300 20
4 iving orld urdas 275 20
420 Touchpad Information Technology-X

