Tuesday, February 27, 2018

M1-R4: JANUARY 2013. IT TOOLS AND BUSINESS SYSTEM, DOEACC O LEVEL ANSWERS, CONDUCTED BY NIELIT

"Olevel course of DOEACC Scheme is equivalent to a Foundation Level Course in Computer Applications. Students can acquire this qualification by undergoing this course and passing the examination conducted by the NIELIT.

1.1 Decimal equivalent of the binary number 110111 is:
A) 55
B) 56
C) 57
D 58

1.2 Numbers in base 10 are called as
A) Octal System
B) Hexadecimal System
C) Decimal System
D) Binary Numbering System

1.3 MIDI stands for
A) Medium Interface for Digital Input
B) Musical Instrument Digital Interface
C) Musical Input for Digital Interface
D) Musical Interface for Digital Input 

1.4 Purpose of Arrange All option in the Word menu is
A) to align all the paragraphs in a Word document
B) to align all the open Word documents on screen for easy accessibility
C) to arrange all open Word files alphabetically
D) none of the above
  
1.5 Payroll system is a typical example of
A) Batch processing
B) On-line processing
C) Real time processing
D) None of the above 
  
1.6 A collection of worksheets is called as
A) Excel Sheets
B) Workbook
C) Excel worksheets
D) Excel Book

1.7 The Save As dialog box can be used
A) for saving the file for the first time
B) to save file by some alternative name
C) to save file in a format other then Word
D) all of the above

1.8 To paste text from the clipboard in the document being edited, press the keys
A) Ctrl and V
B) Ctrl and X
C) Ctrl and A
D) Ins

1.9 A bitmap is
A) A graphic file format made up of small dots
B) A specific kind of bitmap file with the .BMP extension
C) Is a format which windows use for desktop wallpaper
D) All of the above
 
1.10 To change the cell reference C4:C9 to an absolute cell reference, you would enter it as
A) C4:C9
B) C$4:C$9
C) $C$4:$C$9
D) None of the above


2. Each statement below is either TRUE or FALSE. Choose the most appropriate one and ENTER in the “tear-off” sheet attached to the question paper, following instructions therein. (1x10)

2.1 An object, such as a paintbrush picture and word document can be inserted in a worksheet. True

2.2 Both the functions - NOW() and TODAY() can be used to display the current time. False 

2.3 The Recycle Bin is a folder that provides a convenient place to store frequently used documents, graphics and other files. False

2.4 The Internet Protocol addressing system is deployed to keep track of the users connected to the Internet. False

2.5 References that have either a column or a row value absolute and the other relative are known as mixed references. False

2.6 The IF() function evaluates a condition and takes one of the two specified actions depending on the result of the evaluation. True

2.7 Windows clipboard can hold multiple pieces of information at the same point of time.False 

2.8 H2SO4 is written in Word using superscript feature. False 

2.9 There are only two types of page orientation – portrait and landscape. True

2.10 The process of merging the master document and the data source is called as Mail Merge. True

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 “tear-off” answer sheet attached to the question paper, following instructions therein. (1x10)
X
Y
3.1
In the year 1969, Department of Defence of the United States started a network called (G)
A.
Binary
3.2
A device that accomplishes modulation and demodulation (L)
B.
Insert
3.3
Number system to the base 2 (A)
C.
Word Wrapping
3.4
The first screen that appears after the computer is switched on (I)
D.
Shortcut
3.5
While creating a word document, when the insertion point reaches the end of the line, it automatically moves to the next line. (C)
E.
Worksheets
3.6
The menu on which the WordArt option is available (B)
F.
What-if analysis
3.7
It is a collection of worksheets (E)
G.
ARPAnet
3.8
Readymade formulas of Excel (J)
H.
View
3.9
Automatic recalculation of result of a formula if the data is changed (F)
I.
Desktop
3.10
The icons with an arrow in Windows Desktop (D)
J.
Functions
K.
Program
L.
MODEM
M.
INTRANET


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 “tear-off” answer sheet attached to the question paper, following instructions therein. (1x10)
A.
CTRL X
B.
Codeword
C.
Clip Art
D.
Leader
E.
36
F.
55
G.
Slide View
H.
Spreadsheet
I.
Calibri
J.
Password
K.
Database
L.
Compiler
M.
12+24

4.1 A worksheet can be protected using a ____ .
Ans: Password(J)
4.2 If you enter 12+24 in a Excel cell, it will display the result as ___ .
Ans: 12+24(M)
4.3 The ____  command cuts the selected text and graphics and puts it on a clipboard.
Ans: CTRL X(A)
4.4 The character that fills the space up to the next tab stop position is called the ____character.
Ans: Leader(D)
4.5 ____ is a name of a Font.
Ans: Calibri(I)
4.6 ___ is the decimal equivalent of 100100.
Ans: 36(E)
4.7 ____ view allows you to work on individual slides in a presentation software.
Ans: Slide View(G)
4.8 ____ is a gallery of ready-made graphics available in presentation software.
Ans: Clip Art(C)
4.9 ____ is a program to convert high level language into machine language.
Ans: Compiler(L)
4.10 An arrangement of data in a particular order is called as a ____.
Ans: Database(K)

No comments:

Post a Comment