(Sample Paper) CBSE Sample Paper Class XII - Business Data Processing 2004
Disclaimer: This website is NOT associated with CBSE, for official website of CBSE visit - www.cbse.gov.in
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
- ·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
- How are MS-Access and MS-Word files exchanged ?
- Write a program in VB to generate an odd number series upto nth term.
- Write a function in VB to accept a number in a Text Box and add number with 100 and display the result.
- Write a function in VB to accept a string in a Text Box and count and display the number of words in that string.
- Write a function in VB to create a command button that acts as a cancel button,
- Give the output of the following commands in MS-Excel :
- RTRIM (“ HELLO”)
- LEFT (“COMPUTER”, 2)
- What is Redundancy ?
- Define following functions
- FV ( )
- PV ( )
- Compare Primary key and Foreign key.
- How can data be imported and exported in MS-Access and MS-Word ?