M1-R4: IT TOOLS AND BUSINESS SYSTEMS JUL 2018

M1-R4: IT TOOLS AND BUSINESS SYSTEMS JUL 2018

TOTAL TIME: 3 HOURS TOTAL MARKS: 100

(PART ONE – 40; PART TWO – 60)

PART ONE

(Answer all the questions)

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 Which is incorrect 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. 
D) It can create a graph from given data.

1.2 Which is the character encoding standard that provides unique number to every character? A) Unicode 
B) ASCII 
C) ENIAC 
D) IBM 

1.3 Which one is the invalid size of Cache memory? 
A) 2048 Kilobytes 
B) 3072 Kilobytes 
C) 92162 Kilobytes 
D) 512 Kilobytes

1.4 Which short-cut key is used to open a new file in MS-Word? 
A) Ctrl + W 
B) Alt + N 
C) Ctrl + N 
D) Ctrl + F

1.5 Which is the correct Hexa-decimal representation of binary 1010110110011? 
A) 12663 
B) 15B3 
C) 3B51 
D) 5555

1.6 MBR is an acronym for 
A) Most Boot Report 
B) Master Byte Record 
C) Master Boot Record 
D) Most Burn 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) 
C) ii), iii) 
D) i), iii) 

1.8To perform addition of all the cells from B8 to B11, which is the correct option? 
A) =ADD(B8:B11) 
B) =(B8+B11) 
C) =SUM(B8+B11) 
D) =SUM(B8:B11)

1.9 Which of the following file extension indicate file created in Paint? 
A) .BMP 
B) .DOC 
C) .STK 
D) .PPT

1.10 Which one is not a type of memory? 
A) ROM 
B) Cache 
C) EEPROM 
D) Joy-stick

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 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. 

2.10 64 Megabytes means 65536 Kilobytes.

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)

Sr.No.	X	Y(Ans.)
	The Base of a Binary Numbers
	It is non-volatile memory that can be erased by higher voltage
	A particular area where we can write text that is shown on every page of the document
	It is a file format to store video file
	One type of storage device with high capacity
	This symbol is required at the beginning of any calculation in excel
	A type of file system in Windows operating system
	RDBMS
	It is short-cut to start slide show from the current slide
	Symbol used in email address

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. 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. 

4.10 One can copy file from one location to another using mouse. It is known as ________.

PART TWO

(Answer any FOUR questions)

5. 

a) Write a short note on storage devices of computer. 
b) Explain the concept of primary key and foreign key in RDBMS. 
c) Represent (43EF)16 into binary and (1349)10 into binary. 
(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. 
b) Compare the Windows operating system with Linux operating system. 
(8+7)

7. 

a) Explain the following terms: 
i) Auto correction in MS-Word 
ii) Disk defragmentation 
iii) Cell reference 
iv) Web cam 
b) Enumerate the components of multimedia and explain in brief. Enlist the commonly used file formats of multimedia files. 
(8+7)

8. 

a) What is the need of Database Management System? Give three examples of popular Database Management System. 
b) Compare Compiler, Interpreter and Assembler. 
c) What is the difference between SPAM and VIRUS? How do you avoid each of the two in your system? 
(7+3+5)

9. 

a) Discuss the various layouts of a slide of Power-Point presentation. 
b) Write notes on classification of memory. 
c) Explain the use of information technology in Railway reservation system. 
(5+5+5)

- o O o -