M1-R4: IT TOOLS AND BUSINESS SYSTEMS
NOTE:
IMPORTANT INSTRUCTIONS:
1.
Question Paper in English and Hindi and Candidate can choose any one language.
2.
In case of discrepancies in language, English version will be treated as final.
3.
There are TWO PARTS in this Module/Paper. PART ONE contains FOUR questions and
PART TWO contains FIVE questions.
4.
PART ONE is to be answered in the OMR ANSWER SHEET only, supplied with the question
paper, as per the instructions contained therein. PART ONE is NOT to be answered in the
answer book.
5.
Maximum time allotted for PART ONE is ONE HOUR. Answer book for PART TWO will be
supplied at the table when the answer sheet for PART ONE is returned. However,
candidates, who complete PART ONE earlier than one hour, can collect the answer book for
PART TWO immediately after handing over the answer sheet for PART ONE.
TOTAL TIME: 3 HOURS
TOTAL MARKS: 100
(PART ONE 40; PART TWO 60)
PART ONE
(Answer all the questions)
1.
Each question below gives a multiple choice of answers.
Choose the most
appropriate one and enter in the OMR answer sheet supplied with the question
paper, following instructions therein.
(1x10)
1.1
A)
B)
C)
D)
Numbers in base 16 are called as
Octal System
Hexadecimal System
Decimal System
Binary Numbering System
1.2
A)
B)
C)
D)
Octal equivalent of the Decimal number 567 is:
1267
1067
1167
967
1.3
A)
B)
C)
D)
To cut text from the document, press the keys
Ctrl and V
Ctrl and C
Ctrl and A
Ctrl and X
1.4
A)
B)
C)
D)
Which of the following file extensions indicate file created in Paint?
BMP
DOC
STK
PPT
1.5
A)
B)
C)
D)
Which software is used to teach students with help of LCD Projector?
Spreadsheet
Database
Word processing
Power point
M1-R4
Page 1 of 4
January, 2015
1.6
A)
B)
C)
D)
LINUX is?
a Compiler
an Assembler
an Operating System
an Editor
1.7
A)
B)
C)
D)
The DOS command to retrieve list of a file is
FORMAT
DOSKEY
ATTRIB
DIR
1.8
A)
B)
C)
D)
Secondary Memory is
RAM
ROM
Cache Memory
None of the above
1.9
A)
B)
C)
D)
ROUND(1363.45,-2) returns
1400
-1364
1363.45
1464
1.10
A)
B)
C)
D)
The Cell Address $B$4 in a formula in EXCEL means it is a?
Mixed cell reference
Absolute cell reference
Relative cell reference
All of the above
2.
Each statement below is either TRUE or FALSE. Choose the most appropriate one and
ENTER in the OMR answer sheet supplied with the question paper, following
instructions therein.
(1x10)
2.1
Machine Language is machine independent while Higher Level Languages are machine
dependent.
PowerPoint presentation can be embed with sound, video clips and animations.
A Browser is a software program used for viewing Web pages on the Internet.
MIDI means Multimedia Instrument Digital Interface.
Modem converts the digital pulses generated by computer equipment into analog signals.
Recycle Bin is an icon on the desktop that holds deleted files temporarily.
A pixel is the smallest dot that can be represented on a screen or in paint graphic.
Virus cannot survive in a Executable file.
In Word using superscript feature we can write H2O2.
Results are automatic recalculated by a formula if the data is changed in a given cell of
worksheet.
2.2
2.3
2.4
2.5
2.6
2.7
2.8
2.9
2.10
M1-R4
Page 2 of 4
January, 2015
3.
Match words and phrases in column X with the closest related meaning/
word(s)/phrase(s) in column Y. Enter your selection in the OMR answer sheet
supplied with the question paper, following instructions therein.
(1x10)
X
The base of a binary number
Short cut used to paste
In a word document, similar text can appear at top
and bottom of every page, by using option
3.4 It is an automatic placement of a word on the next
line.
3.5 A program to view Web documents on the Internet
3.6 In a work sheet cell A1 contains 7, cell A3 contains 6
and cell A4 contains 11. If cell B1 contains
=COUNT(A1:A4) then what will be displayed in B1
3.7 =MOD(-3,2) entered in a cell displays
3.8 Group of instructions necessary to process data and
give results
3.9 Hyperlink that jump to a particular location can be
created by using
3.10 RDBMS
3.1
3.2
3.3
A.
B.
C.
Y
4
Internet Explorer
Data Interpreter
D.
E.
F.
3
2
G.
H.
Ctrl + p
Word-wrap
I.
Ctrl+v
J.
K.
L.
M.
program
Bookmark
Header and Footer
Relational database
Management System
4.
Each statement below has a blank space to fit one of the word(s) or phrase(s) in the
list below. Enter your choice in the OMR answer sheet supplied with the question
paper, following instructions therein.
(1x10)
A.
Table and Query
B.
Binary Data
C.
D.
Binary Digit
E.
36
F.
Workbook
G.
System
H.
cut/copied
I.
12+24
J.
PIE
K.
chown
L.
Attrib
M.
B2C
4.1
4.2
4.3
4.4
4.5
4.6
4.7
4.8
4.9
4.10
The term BIT is an abbreviation of ________.
A Clipboard is a temporary storage area used for text which is ________.
ASCII Codes are ________bit binary codes.
Relational Database contains ________.
________Unix command is used to change ownership of the file.
A collection of worksheets is known as ________.
If you enter 12+24 in a cell, Excel will display ________.
In ________chart, only one data series can be plotted.
Operating System is a ________software.
A commercial exchange between business and consumers conducted over the internet is
abbreviated as ________.
M1-R4
Page 3 of 4
January, 2015
PART TWO
(Answer any FOUR questions)
5.
a)
b)
c)
6.
Differentiate between system software and application software? Give two examples of each.
Convert binary number 100111 and 101.11 into a Hexadecimal Numbers?
What is an Operating System? Give three advantages of LINUX over WINDOWS.
(5+5+5)
Explain (any three) of the following with example in word:
i)
Foot notes and End notes
ii)
Spell Check
iii)
Mail Merge
iv)
Header and Footer
(5+5+5)
7.
a)
b)
c)
8.
a)
b)
c)
9.
a)
b)
c)
M1-R4
Explain any three financial functions available in MS-EXCEL.
Explain with example the Alphabetical Order sorting on raw, unordered data in Spreadsheet.
Describe with example the Auto-Calculate and Autofill feature in MS-EXCEL.
(6+4+5)
Explain the functions of Compiler, Interpreter and Assembler.
Differentiate between SPAM and VIRUS? How do you avoid each of the two in your system?
Why are high level languages known as machine independent?
(5+5+5)
Explain the security aspects associated with e-commerce.
Explain the steps involved to animate text and graphic objects in Power Point Presentation?
Mention four advantages and disadvantages of index file organization.
(5+5+5)
Page 4 of 4
January, 2015