DOEACC O LEVEL (NIELIT) M1-R4: IT TOOLS AND BUSINESS SYSTEMS JANUARY 2014 SOLVED QUESTION PAPER.     by Vivek Roy .                            

===============================

1.1Which of the following file extensions does not indicate graphic files?

A)BMP   B)JPEG   C)DOC   D)GIF 

ANS: C)

1.2 In MS-Power Point which layout can be used to display hierarchies of employees in a
Company?

A)Dialog Box   B)Table   C)Pie Chart   D)Organization Chart

Ans:

 1.3The value of Primary key

A)cannot be null   B)can be null   C)can be duplicate   D)none of these

 Ans: A)

1.4What does an electronic spread sheet consists of? 

A) Rows   B)Columns   C)Cells   D)All of the aboveColumns

Ans:D)

1.5 The formula in cell A2 is =B2+C3 on copying this formula in cell C2 the formula will be 

A)=D3+E4   B)=D2+E3    C)=D2+E4   D) =D3+E3

Ans: B)

 1.6)Non-impact based printing device is
A)Dot-Matric Printer  B)Scanner   C)Laser Printer   D)None of the above

Ans: C

1.7) Which of the following shortcut is used to open a new file?
A)CTRL+S
B)CTRL+N
C)ALT+N
D)CTRL+V

Ans: B


1.8)MIS stands for
A)Maintenance Information System
B)Model Information System
C)Management Information System
D)Media Information Source

Ans:C)

 1.9)The Internet is owned by
A)IAB    B)IETF    C)Inter NIC     D)All of the above
 ans: D)

(Who Owns the Internet?

No one actually owns the Internet, and no single person or organization controls the Internet in its entirety.
The Internet is more of a concept than an actual tangible entity, and it relies on a physical infrastructure that connects networks to other networks.
There are many organizations, corporations, governments, schools, private citizens and service providers that all own pieces of the infrastructure, but there is no one body that owns it all. There are, however, organizations that oversee and standardize what happens on the Internet and assign IP addresses and domain names, such as the National Science Foundation, the Internet Engineering Task Force, ICANN, InterNIC and the Internet Architecture Board. )


 1.10)While sending a file or message on the net, it is divided into very small parts known as
A)Point    B)Particle    C)Pin    D)Packet

Ans:D)



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 A set of instruction which perform a task is called program. True

2.2 A byte is the smallest unit of storage.  False

2.3 Analog computer is a mixture of hybrid and digital computer.False

2.4 Margins are the distance between the text and the edges of the paper.True

2.5 By default, the numbers are left aligned and text is right aligned in a spreadsheet. False
(actually numbers are Right aligned and text is Left aligned)

2.6 If you enter 127A in a cell it will be treated as number in the electronic spreadsheet as it startswith digit. False

2.7 In Access deleted record can be undone.

2.8 Access sorts data only in ascending order. False

2.9 Internet is network of networks. True

2.10 Paperless office & Virtual office are same.False


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 Information                     A. The base of Octal number system                       
3.2 DSS                                 B. Highest transmission text program                     
3.3 LINUX                             C. Returns highest value from cell A1 to A9            
3.4 http                                  D. Software to translate HLL to Machine Code      
3.5 Interpreter                       E. Person to Person Protocols                                 
3.6 PPP                                  F. Hyper text transfer protocol                                 
3.7 ls – l                                  G. Mixed cell reference in electronic spreadsheet  
3.8 $A44                                H. Processed Data                                                   
3.9 8                                       I. Command to get lost list of files in LINUX          
3.10 =max(a1:a9)                  J. Operating System                                                 
                                               K. Point to Point Protocols                                      
                                               L. Command to get long list of files in LINUX        
                                              M. Decision Support System                                     
 

 Ans: 3.1>H      3.2> M  3.3>J   3.4>F    3.5> D   3.6> K    3.7> L     3.8>  G
3.9> A   3.10>C




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. LINK     B. 1000          C. MODEM        D. PASTE       E. AUTOSUM        F.CUT/COPIED          G. 1024    H. CAT    I. COMPILER      J. DATABASE  MANAGEMENT SYSTEM    K. CUT     L. DATABASE MODEL SYSTEM    M. HARDDISK


 4.1 The 1KB equals  1024 bytes.

4.2 AUTOSUM is used in electronic spreadsheet to total rows and/or columns.

4.3 The HARDDISK  is the example of Secondary memory.

4.4 Short-cut CTRL+X is used to  CUT.

4.5 DBMS stands for DATABASE  MANAGEMENT SYSTEM

4.6 The command to view the contents of a file in LINUX is   CAT

4.7 COMPILER translates a program written in high-level language into machine code.

4.8 Foreign Key is used to LINK the given table with other table.

4.9 A Clipboard is used for keeping the CUT/COPIED  text.

4.10 MODEM is a device to convert digital signal to analog & vice versa.

PART TWO
(Answer any FOUR questions)

5.A) Draw a block diagram of basic units of the Computer System. List various sub units of the CPU
and give the function of each of the units.
















5.b)  i)Convert:i)(7706)8 to Hexadecimal  ii)(7305) 10 to Octal.