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