Page 403 - Trackpad 402_Class-X_Final
P. 403

2.  Create a project on Consumption of Dairy Products in New Delhi in Calc:
                     This sheet can be shared with Dairy Companies who are supplying their dairy products in New Delhi.






























                      Consider your 3 friends as representatives of Company A, B and C, respectively. Share the worksheet with
                      your friends to update the selling data of Dairy Products in New Delhi by their company.

               3.  Follow the given instruction to complete the project in OpenOffice:
                     Create a Macro that performs 'Paste Special' with Add and Subtract.
                     Create your own Macro function to return the number 10.
                     Create a Macro to sort the following data: 10, 8, 15, 6.

                                                                 10

                                                                  8

                                                                 15
                                                                  6

               4.   Bharat Associates Pvt. Ltd. wants to design a database which can store the details of its Customers and make
                  their billing details. The table name and its structure are as follows:


                             Table Name : CUSTOMER                            Table Name : BILLDETAILS

                        Field Name              Data Type                 Field Name             Data Type

                   CustId                 Number[NUMERIC]           CustID                 Number[NUMERIC]

                   CName                  Text[VARCHAR]             Quotation              Number[NUMERIC]
                   Add1                   Text[VARCHAR]             Challan                Number[NUMERIC]








                                                                                                      Projects  403
   398   399   400   401   402   403   404   405   406   407   408