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
   391   392   393   394   395   396   397   398   399   400   401