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

