Solved NIELIT IT Tools and Business Systems (July 2018)
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.
1.1 : statement for MS-Word?
A) It can be used to prepare annual report.
B) It can be used to generate same document to send multiple persons.
C) It has autocorrect facility and dictionary facility.
1.2 : Which is the character encoding standard that provides unique number to every character?
A) Unicode B) ASCII
1.3 : Which one is the invalid size of Cache memory?
A) 2048 Kilobytes B) 3072 Kilobytes
1.4 : Which shortcut menu is used to create a new file in word.
A) Cntl + W B) Alt + N
1.5 : Which is the correct Hexa-decimal representation of binary 1010110110011?
A) 12663 B) 15B3
1.6 : MBR is an acronym for
A) Most Boot Report B) Master Byte Record
1.7 : Which tasks are performed by operating system in a computer?
i) Memory manager ii) Process Manager
iii) Device Manager iv) File Manager
A) i), ii), iii), iv) B) i), ii), iv)
1.8 : To perform addition of all the cells from B8 to B11, which is the correct option?
A) = ADD( B 8 : B 11 ) B) =( B 8 + B 11 )
1.9 : Which of the following file
extension indicate file created in Paint?
A) .BMP B) .DOC
A) ROM B) Cache
C) EEPROM D) Joy-stick
Answer
2. Each statement below is either TRUE or FALSE. Choose the most appropriate one and enter your choice in the “OMR” answer sheet supplied with the question paper, following instructions therein. (1x10)
2.1 F5 is the short-cut key to start slide show in Power-point.
2.2 1011 is an example of valid decimal number.
2.3 Red Hat is a company who distributes license for Windows.
2.4 Converter is a system software that translates high-level language into machine code.
2.5 Device driver is a program that controls a particular device attached to a computer.
2.6 Large Area Network is a network of computers that spreads in a large building.
2.7 Letter, A4, Legal are the example of type of presentation.
2.8 dir is command of DOS that works like ls command in Linux.
2.9 Scanner and speaker are the types of input devices.
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
|
Y
|
||
3.1
|
The Base of a Binary Numbers
|
A.
|
2
|
3.2
|
It is non-volatile memory that can be erased by higher voltage
|
B.
|
Shift+F5
|
3.3
|
A particular area where we can write text that is shown on
every page of the document
|
C.
|
Relational Database Management System
|
3.4
|
It is a file format to store video file
|
D.
|
AVI
|
3.5
|
One type of storage device with high capacity
|
E.
|
NTFS
|
3.6
|
This symbol is required at the beginning of any calculation in
excel
|
F.
|
EEPROM
|
3.7
|
A type of file system in Windows operating system
|
G.
|
avg()
|
3.8
|
RDBMS
|
H.
|
clipart
|
3.9
|
It is short-cut to start slide show from the current slide
|
I.
|
header
|
3.10
|
Symbol used in email address
|
J.
|
DVD
|
K.
|
equal
|
||
L.
|
F10
|
||
M.
|
@
|
4. Each statement below has a blank space to fit one of the word(s) or phrase(s) in the list below. Choose the most appropriate option, enter your choice in the “OMR” answer sheet supplied with the question paper, following instructions therein. (1x10)
A.
|
ctrl+c
|
B.
|
min
|
C.
|
IT Act
|
D.
|
8
|
E.
|
1024
|
F.
|
drop table
|
G.
|
drag and drop
|
H.
|
ctrl+e
|
I.
|
delete table
|
J.
|
Format painter
|
K.
|
transition
|
L.
|
Fopen
|
M.
|
png
|
4.1 ..........deals with cybercrime and electronic commerce.
4.2 At the time of on-screen presentation, the motion effects that occurs in slide show when moving from one slide to the next slide is known as .....
4.3 ........is a short-cut to align all the selected sentences in center of the page.
4.4 ........function is used to find the smallest value in the range of cells.
4.5 ........facility copies only format of the selected text not the content.
4.6 To remove a table from the database, .........command is used.
4.7 .........is a file format supported by Windows to store images.
4.8 Base of Octal Number System is ..........
4.9 1KB equal .........bytes.
PART TWO
(Answer any FOUR Questions)
5.
(7+4+4)
6.
a) What is the difference between function and formula in Excel? Provide example. Explain the working of the functions with example: count, max, if, sqrt in worksheet.
(8+7)
Next Set.
6.
a) What is the difference between function and formula in Excel? Provide example. Explain the working of the functions with example: count, max, if, sqrt in worksheet.
(8+7)
No comments:
Post a Comment