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

"O" level 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. Each question below gives a multiple choice of answers.   (1x10)

1.1 Which of the following is a communication device?

A) Printer

B) Monitor

C) Keyboard

D) Modem

1.2 Which of the following file extensions indicate only graphics files?

A) BMP and DOC

B) JPEG and TXT

C) TXT and STK

D) BMP and GIF

1.3 What type of software is LINUX?

A) Compiler

B) Operating System

C) Utility Software

D) Application Software

1.4 To create a Para Break in MS-WORD, which key is used?

A) Enter

B) Esc

C) Tab

D) Shift

1.5 Which software would you use to teach students in Computer classes?

A) Spreadsheet

B) Database

C) Word processing

D) Power point

1.6 Which of the following translates a program written in Assembly language into machine

code?

A) A compiler

B) An assembler

C) An operating system

D) An editor

1.7 Which of the following is a tool to send letter to many recipients in MS-Word?

A) What-if

B) Mail merge

C) Goal seeking

D) Sorting

1.8 Using MS-Power Point which layout will you use to display hierarchies of employees in your

company?

A) Chart

B) Table

C) 2 Column Text

D) Organisation Chart

1.9 SQL stands for?

A) Standard Query Language

B) Structured Query Language

C) Shortest Query Language

D) System Query Language

1.10 Using the Cell Address $A4 within a formula in EXCEL means it is a?

A) Mixed cell reference

B) Absolute cell reference

C) Relative cell reference

D) All 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 All modern computer use the Binary number System.  TRUE

2.2 Analog computer is a mixture of Hybrid and Digital Computer.  FALSE

2.3 The EBCDIC is a 16 bit code.  FALSE

2.4 Compilers are system software.  TRUE

2.5 In WORD, search is case sensitive.  FALSE

2.6 You can embed sound, video clips and animations into your power point presentation.  TRUE

2.7 In EXCEL, a formula starts with =.  TRUE

2.8 In EXCEL, by default, the numbers are left aligned and text values are right aligned.  FALSE

2.9 Date and Time are internally stored as serial number in EXCEL.  TRUE

2.10 AutoCorrect can be used to correct common typing errors automatically as you work.  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)

A. Entity B. CTRL+S C. Primary Key D. 8, 16 E. Chart F. 3 G. Hardware H. 4 I. 12, 16 J. Bit K. Endnote L. Footer M. Program

3.1 Smallest unit of storage   J

3.2 What are the base of Octal & Hexadecimal number system  D

3.3 Something which exits and whose information is being stored in Database  A

3.4 Set of one or more attributes that can uniquely identify tuples within a relation  C

3.5 Short cut used to save a file   B

3.6 Pictorial presentation of worksheet data   E

3.7 Text that appears at the bottom of every page   L

3.8 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 cell B1  F

3.9 Group of instructions necessary to process data andgive results  M

3.10 Any part of the computer which you can physicallytouch   G

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. Data B. Paste C. Binary Digit D. Better Digit E. Attachment F. 36 G. Word Wrap H. Pie I. 1224 J. Relational Database Management System K. Real Database Management System L. View M. Clipboard

4.1 The term BIT is an abbreviation of ____C____.

4.2 An electronic document sent with the Email is termed as ____E____.

4.3 A virtual table derived from one or more tables is known as ____L____.

4.4 A temporary storage area used for keeping the cut/copied text is called ____M____.

4.5 Process of placement of text going past right margin to next line is termed as ____G____.

4.6 Short cut CTRL+V is used to ____B____.

4.7 If you enter 12+24 in a cell, Excel will display ____12+24____.

4.8 In ____H____ chart, only one data series can be plotted.

4.9 RDBMS stands for ____J____.

4.10 ____A____ label serves as data marker, which represents a single data item.