CBSE-Sample Paper

Class-XII-2004

Business Data Processing

Time allowed : 3 hours

Maximum Marks : 50

Note :- All questions are compulsory.

1. Fill in the blanks :

(i) The extension of a spreadsheet file in MS-Excel is_____________.
(ii) MS-Word is ___________ package.
(iii) Extension of MS-Word is___________.
(iv) Cell address of the 5 row and 2 column in a worksheet is represented by _____________.
(v) ___________ is a multi-row function in MS-Access.
(vi) ___________ is an Accounting package.
(vii) The extension of standard module in VB is _____________.
(viii) The extension of Paintbrush file is _____________.
(ix) Expansion of OLE term is _____________.
(x) AND, NOT, OR, XOR are ___________ operators.
(xi) ___________ is a tool for Database Management.
(xii) Events are used in ________________.
(xiii) Address of sixth cell in worksheet is ________________.
(xiv) JPEG is file format for ___________ picture.
(xv) RTF format stands for ___________.
(xvi) The appearence of the form can be changed by ____________.

2. Multiple choice questions :

(i) Which one of the following is not a part of MS-Office ?

• Word
• Excel
• AutoCAD
• All of the above

(ii) Which of the following is not supported by MS-Word ?

• ·RTF
• · DOC
• ·TXT
• ·EXE

(iii) Which one of the following is used for querying operator ?

• XOR
• NOR
• AND
• None of the above

(iv) Which of the following is used for building complex condition ?

• Relational operator
• Arithmetic operator
• Logical operator
• None of the above

(v) ADO is the new form of

• RDO
• DAO
• OLE
• None of the above

(vi) Which of the following is a clipboard file ?

• · DOC
• ·EXE
•  · COM
• None of the above

(vii) Which one of the following is a multi-row function ?

• Avg
• Max
• Found
• All of the above

(viii) Query used to update a database is

• Create table
• Insert into
• Delete form
• Update

(ix) Extension of database in MS-Access is

• · dbf
• · pdf
• ·mdb
• None of the above

(x) ____________ is not a functional function.

• FV ( )
• MPV ( )
• SUM ( )
• PMT ( )

(xi) Combo Box is used in ______________.

• MS-Excel
• MS-Office
• VB
• Note of the above

(xii) The grouping option is used in Powerpoint to

• Group more than one object
• Delete the object(s)
• Scroll to the object(s)
• None of the above

(xiii) Following is used for Spreadsheet Management :

• MS-Word
• MS-Excel
• MS-Access
• None of the above

(xiv) List Box is used in

• MS-Word
• VB
• MS-Excel
• None of the above

3. Define the following :

• Global and Local Variables
• Command Button
• Types of Relationship
• Operator
• DML

4. Short questions

• What is the use of day book ?
• Define Relational Database.
• What is Tuple ?
• What is data inconsistency ?
• What is cardinality of a Relation ?
• What are macros ?
• List use of Relational operator.
• Explain any two data types in VB.
• Give difference between UPDATE and UPDATE CANCEL.
• How do you delete and add items in Combo Box ?

5. Long questions

1. How are MS-Access and MS-Word files exchanged ?
2. Write a program in VB to generate an odd number series upto nth term.
3. Write a function in VB to accept a number in a Text Box and add number with 100 and display the result.
4. Write a function in VB to accept a string in a Text Box and count and display the number of words in that string.
5. Write a function in VB to create a command button that acts as a cancel button,
6. Give the output of the following commands in MS-Excel :

• RTRIM (“ HELLO”)
• LEFT (“COMPUTER”, 2)

7. What is Redundancy ?
8. Define following functions

• FV ( )
• PV ( )

9. Compare Primary key and Foreign key.
10. How can data be imported and exported in MS-Access and MS-Word ?