IsDB-BISEW, Exam Module and Answer

Q151.Identify where computer might be more appropriate than people. Ans: 1) Repetitive tasks 2) Easily automated tasks. 3) Mathematical calculations. 4) Dangerous Situations. Q152.Identify where people might be more appropriate than computer. Ans: 1) Imagination. 2) Emotions, feelings, love, real person talking. 3) Decision making. 4) Nursing. 5) Planning. 6) Creativity. 7) Pattern recognition. Q153.Name some of the uses of large-scale computer applications. Ans: 1) Business administration system (ERP – Enterprise Resource Planning). 2) Airline booking systems. 3) Insurance claims processing. 4) Online banking. Q154.Name some of the uses of large-scale computer applications in government. Ans: 1) Census. 2) Vehicle registration. 3) Revenue collection. 4) Electronic voting. Q155.Name some of the uses of large-scale computer applications in healthcare. Ans: 1) Patient record system. 2) Ambulance control system. 3) Diagnostic tools and specialist surgical equipment. Q156.Name some of...

Q102.Formulas within Excel start with which symbol? Ans: =(equal to) Q103.What are the commonly used operators in Excel? Ans: +(plus), -(minus), *(multiplication), /(divide) Q104.What are the error messages in Excel? Ans: ######: The contents of the cell cannot be displayed correctly as the column is too narrow. #REF!: indicates that a cell reference is invalid. #NAME? : Excel does not recognise text contained within a formula. #DIV/01: This indicates that you have tried to divide a number by zero Q105.There are how many types of cell references in Excel? What are they? Ans: There are two types of cell references in Excel. They are: 1. Relative 2. Absolute Q106.What is the difference between relative and absolute cell reference? Ans: Relative Cell References This is the most widely used type of cell reference in formulas. Relative cell references are basic cell references that adjust and change when copied or when using AutoFill. Absolute Cell References Situations aris...

Q51.Write down the different type of computer and describe shortly. Ans: According to the usage and working capacity computers can be divided into three different types: Such as • Super Computer • Mini Computer or Mainframe Computer • Micro Computer or Personal Computer Super Computer: Super computers are very powerful and heavy duty computers which generally use in scientific, medical or astronomical works. Mini Computer or Mainframe Computer: A mainframe or mini computer is designed specially for used by many people usually at the same time or large data processing system which require specialized staff to operate to operate effectively. Micro Computer/Personal Computer : A personal computer(PC) is any general purpose computer whose size capability and price make it useful for individuals. The great facilities of PCs are it can be operated by any end user who may not have specialized computing skills or knowledge. Laptop, etc are such kind of computer. Q52.What is a Network Compute...

Q1.What is mainframe computer? Ans: big, powerful, expensive computers used in the background by large organizations. Q2.What is a PC? Ans: PC- personal computer It is a micro-computer. It is a general purpose computer whose size, capabilities and price is limited which make it useful for individuals. Q3.What is Mac? Ans: The Apple Mac is a computer. It uses different operating system. It requires special version of application program. Q4.What is a networked computer? Ans: A network computer allows to connect two or more computers together. Q5.What is laptop? Ans: Laptop a small portable which run on batteries as well as main power Q6.What is PDA? Ans: Personal Digital Assistant It is a small size computer/device. It uses special pen rather than keyboard. It is used for storing and retrieving information. Q7.What are input devices? Ans: Allows to input information to the computer. Q8.What are output devices? Ans: Allows to output information from computer. Q9.What is peripheral devic...