Material Content for IT TOOLS AND BUSINESS SYSTEMS January 2015

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 Numbers in base 16 are called as

A) Octal System

B) Hexadecimal System

C) Decimal System

D) Binary Numbering System

1.2 Octal equivalent of the Decimal number 567 is:

A) 1267

B) 1067

C) 1167

D) 967

1.3 To cut text from the document, press the keys

A) Ctrl and V

B) Ctrl and C

C) Ctrl and A

D) Ctrl and X

1.4 Which of the following file extensions indicate file created in Paint?

A) BMP

B) DOC

C) STK

D) PPT

1.5 Which software is used to teach students with help of LCD Projector?

A) Spreadsheet

B) Database

C) Word processing

D) Power point

1.6 LINUX is?

A) a Compiler

B) an Assembler

C) an Operating System

D) an Editor

1.7 The DOS command to retrieve list of a file is

A) FORMAT

B) DOSKEY

C) ATTRIB

D) DIR

1.8 Secondary Memory is

A) RAM B) ROM

C) Cache Memory

D) None of the above

1.9 ROUND(1363.45,-2) returns

A) 1400

B) -1364

C) 1363.45

D) 1464

1.10 The Cell Address $B$4 in 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 “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.

2.2 PowerPoint presentation can be embed with sound, video clips and animations.

2.3 A Browser is a software program used for viewing Web pages on the Internet.

2.4 MIDI means Multimedia Instrument Digital Interface.

2.5 Modem converts the digital pulses generated by computer equipment into analog signals.

2.6 Recycle Bin is an icon on the desktop that holds deleted files temporarily.

2.7 A pixel is the smallest dot that can be represented on a screen or in paint graphic.

2.8 Virus cannot survive in a Executable file.

2.9 In Word using superscript feature we can write H2O2.

2.10 Results are automatic recalculated by a formula if the data is changed in a given cell of worksheet.

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)

QUESTION OPTION
3.1 The base of a binary number  A. 4
3.2 Short cut used to paste  B. Internet Explorer
3.3 In a word document, similar text can appear at top and bottom of every page, by using option  C. Data Interpreter
3.4 It is an automatic placement of a word on the next line.  D. 1
3.5 A program to view Web documents on the Internet  E. 3
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  F. 2
3.7 =MOD(-3,2) entered in a cell displays  G. Ctrl + p
3.8 Group of instructions necessary to process data and give results  H. Word-wrap
3.9 Hyperlink that jump to a particular location can be created by using  I. Ctrl+v
   J. program
   K. Bookmark
   L. Header and Footer
   M. 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)

4.1 The term BIT is an abbreviation of ________.

4.2 A Clipboard is a temporary storage area used for text which is ________.

4.3 ASCII Codes are ________bit binary codes.

4.4 Relational Database contains ________.

4.5 ________Unix command is used to change ownership of the file.

4.6 A collection of worksheets is known as ________.

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

4.8 In ________chart, only one data series can be plotted.

4.9 Operating System is a ________software.

4.10 A commercial exchange between business and consumers conducted over the internet is abbreviated as ________.

Options ; Answer

A. Table and Query B. Binary Data C. 8 D. Binary Digit E. 36 F. Workbook G. System H. cut/copied I. 12+24 J. PIE K. chown L. Attrib M. B2C

View More Material

Share