Page 398 - Trackpad 402_Class-X_Final
P. 398
18. Type the following arithmetic functions in Calc worksheet and write the output here:
Function Output
=ABS(-541)
=SQRT(625)
=ROUND(12.267, 2)
=SUM(10, 20, 30, 40, 50)
=POWER(2, 5)
=PRODUCT(2, 3, 4, 5)
=MOD(17, 3)
19. Create a scenario for calculating the percentage of five friends using three subjects.
20. Calculate the simple interest with the given Principal=Rs 5000 Rate=5% Time=10 yrs.
• Use goal seek to have less of interest by changing the time variable only.
• Use solver to have less of interest by changing all -rate, principal and time.
21. Create a macro to create a list of students in your class. Format the data with specific font size, color and style. Save
it as a macro.
22. Create the following table using the ‘Design View’.
Reg No. Name Date of Submission Marks Obtained Grade
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.
23. Create the following table using the ‘Design View’.
Roll No. Name Date of Birth Phone No. Place
A001 Manan Gupta 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.
24. 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 Living World Gurdas 275 20
398 Trackpad Information Technology-X

