IDB BISEW Exam QuestionsSample (Part-3)

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 arise in which the cell reference must remain the same when copied or when using AutoFill. Dollar signs are used to hold a column and/or row reference constant. Q107.What is function in excel? Ans: A function allows you to calculate a result such as adding numbers, or finding the average of a range of numbers. Q108.What are the common functions used in Excel? Ans: AVERAGE: Returns the average of its arguments COUNT: Counts how many numbers are in the list of arguments COUNTA: Counts how many values are in the list of arguments COUNTBLANK: Counts the number of blank cells within a range MAX: Returns the maximum value in a list of arguments MIN: Returns the minimum value in a list of arguments ROUND: Rounds a number to a specified number of digits SUM: Adds its arguments COLUMNS: Returns the number of columns in a reference Q109.Which symbol is used in absolute cell referencing? Ans: $ Q110.What are IF functions? Ans: Returns one value if a condition you specify evaluates to TRUE and another value if it evaluates to FALSE. Use IF to conduct conditional tests on values and formulas. Q111.Which keyword shortcut is used for searching in Excel? Ans: Ctrl+F Q112.What is Auto Fill in Excel Ans: A very handy feature in Excel is Auto Fill, which allows you to automatically fill cells with preset data. Q113.What is Freeze Panes in Excel? Ans: When working with very large spreadsheets headings located at the top and down the left side of the worksheet often disappear if you scroll too far to the right or down. Without the headings, it's hard to keep track of which column or row of data you are looking at. To avoid this problem use Excel's freeze panes feature. It "freezes" or locks specific columns or rows of the spreadsheet so that they remain visible at all times. Q114.what is html formatted file? Ans: html formatted file means it will be visible as web page either in world wide web or on LAN/Intranet. Q115.Difference between RTF file and TXT file? Ans: RTF stands for rich text format. This is generic word processing file format. This format is used to share word-processing between different word processors. RTF files can be much larger than a word file if a lot of complex formatting is used. TXT is used for storing plain text.TXT can hold only text in it, it cannot hold image or other formatting. Q116.why file extension is important? Ans: File extension is important for windows operating system to determine which application is needed to open a particular file and which icon to show. Q117.What type of file we cannot rename? Ans: Some types of files are used by computer to run. If we rename them the system can crash or be damaged. These files are: .exe, .com, .bat, .dll, ini, .sys etc. Q118. What is temporary file? Ans: 1) windows or other applications create temporary files while working with them. 2) if the system crashes or stops working or the power supply gets interrupted these temporary files are not automatically deleted as normal. 3) some common extensions of temporary files are tmp,temp,chk,old, etc. Q119.How can we write protect a file? Ans: To protect a file: 1) right click on the file then select properties or select the file and press Alt+Enter to view the properties dialog box. 2) in the Attributes section tick the Read-only check box then click apply and OK; the file is now write protected i.e. we can only read it but cannot write on it or change it. Q120.Why do you use (various) screensaver? Ans: 1. To change and blank the screen after certain period of activity. 2. when we use our computer for long time we sometime keep the computer running idly Q121.What is word Pad? what is the benefits of using word Pad? Ans: wordpad is a small word processing application provided along with windows operating system. It has the following advantages: 1. free to use 2. can change or modify font and paragraph style. 3. it can be used by other various applications Q122.what is recycle bin? Ans: it contains files which have recently been deleted. we can restore file from recycle bin. Q123.What is windows explorer? Ans: It is a window of windows operating system. It explores all aspects of computer system using a hierarchical view. Q124. What is Operator? Ans : Operator are those symbol which perform operation on data. Q125.what is drag and drop? Ans: The term drag and drop basically means picking up an item with mouse and dragging it to a new location. Q126.What is the difference between count and counta function? Ans: The count function will count up the number of cells which contain numbers. counta function is used to count the number of cells within a range that are not empty. Q127.What is the syntax of If functions? Ans: if(logical_test, action_if_true, action_if_false) Q128.In if function what operators are used? Ans: =(equal to) , >(greater than , <(less than) , >=(greater than equal to) , <=(less than equal to) Q129.Why are selection techniques important? Ans: often when you want to do something within excel you need to select an item first. this could involve selecting a cell or multiple cells. it many need you to select a row, a column or even the entire table. Q130.what is virus disinfecting? Ans: using a virus checker to detect and eliminate viruses from a computer is called virus disinfecting. Q131.What are Title Bar, Menu Bar, Toolbar, Status Bar and Scroll Bar? Ans: 1) Title Bar: the bar which is displayed on top of almost all programs is called Title Bar.Title Bar may display the name/path of the file opened or the name of the application. 2) Menu bar: menu bar is normally displayed just under the title bar which contain a series of drop down menus. 3) Tool Bar: It contains a series of icons. THESE ICONS ARE like short cuts to certain menu commands in the menu bar drop down list. It makes work fast and easy. 4) Status bar: the bar which is displayed along the bottom of almost every program is called status bar. It displayed information about the file or files opened or selected. 5) Scroll bar: when a document window is bigger than the physical screen size of the computer. Bars may appear on the right and the bottom of the window to make the users see all the information easily. Q132.What is PCMCIA? Ans: PCMCIA stands for Personal Computer Memory Card International Association. Q133.What is modem? Ans: 1) Modem is a device which is used to attach the computer to the telephone system through which one can connect to the internet. 2) Modem converts data into sound which sent over the telephone line. 3) The receiving modem turns the sound back into data and the communication is established. 4) Modem comes from MODulate and DEMODulate. Q134.Why do we need to format a disk? Ans: 1) Formatting a disk is like putting lines on a blank sheet of paper so that we can write on that paper. 2) Formatting allows the operating system to read information stored on the disk and also stored information on the disk. 3) We need to format the disk before we can install OS into the hard disk. 4) We need to format the disk after we have re-partitioned it 5) We need to format the disk if we want to change the file system e.g. FAT to NTFS. 6) We need to format the disk to get rid of viruses and malicious files. Q135.What is GUI? Ans: 1) GUI stands for Graphical User Interface. 2) It is simply an additional part of the operating system which displays windows and drop down menus and also enables us to drive our computer using a mouse. 3) Windows and IBM’s OS/2 are examples of OS which use GUI. Q136.What are the advantages of GUI? Ans: 1) All programs look similar and they are easy to use even switched from one to another. 2) Applications programs are similar to the operating system as a result they are easier to use. 3) GUI allows programmers to easily write consistent looking programs. Q137. What is system development? Ans: The way new software is specified, written by programmers, tested and then delivered to the user is referred to as system development. Q138.What is system development cycle? Ans: System development cycle is defined in the following way: 1) Analysis : System Analysts ask the users exactly what they need and then draw up plants to implement those on a computer based system. 2) Design : A possible design or outline is drafted to make it real. 3) Programming : Programmers convert the whole thing into actual computer codes. 4) Testing : Users are introduced to the new system and asked whether any modification is needed. Q139.What does client / server mean ? Ans: 1) This term relates to the type of network where resources are kept centrally on the server and used locally by the client. 2) The server is usually a very powerful PC or a group of PC’s while each workstation which the users have is less powerful. Q140.What is workgroup computing? Ans: 1) The idea of workgroup is that groups of people working together can share their resources with each other. 2) People within the workgroup can share information on their hard disks. 3) They also can share printers, modems and scanners. 4) The workgroup in connected via a computer network. 5) The network may be a few computers at a single location or of many computers connected globally. 6) The networked nature of computers means that the physical distance between workgroup members is fast becoming irrelevant. Q141.What are the advantages of workgroup computer? Ans: 1) No reliance on central computer : As there is no reliance on a central computer, there in less change of major disruption if one computer goes down for a while. 2) Network administrator is not needed : Provided members of the workgroup have the authoring and access rights. They can share data on a temporary basis with colleagues. They don’t need help of a network administrator. 3) Can be cost-saving : If a dedicated network administrator is not needed in a small office it can save a considerable cost. Q143. What does FTP mean? Ans: FTP means File Transfer Protocol. Q144.What is PSTN? Ans: 1) PSTN stands for Public Switched Telephone Network. 2) It is the technical name for the public telephone system. 3) It is based on traditional ‘copper wire’ technology. 4) It transmits analogue voice data. Q145.What is PSDN? Ans: 1) PSDN stands for Public Switched Data Network. 2) It is the technical name for the telephone system in use today. Q146.What is ISDN? Ans: 1) ISDN stands for Integrated Services Digital Network. 2) ISDN allows much faster transfer rates than-when using modems. 3) It can transfer 64 or 128 Kb data per second. Q147.What is ADSL? Ans: 1) ADSL stands for Asymmetric Digital Subscriber Line. 2) It is a more recent technology. 3) It allows more data to be sent over existing telephone lines. 4) But it requires a special ADSL modem. 5) It can download data at a rate of 0.5 to 8 Mbps and upload at a rate of 16 to 640 Kbps. Q148.What is DSL? Ans:1) DSL refers collectively to all types of Digital Subscriber Lines. 2) Its two main categories are ADSL and SDSL. 3) DSL technology allows faster data transfer. 4) It uses ‘copper wire’ not optic ‘fiber cables’. Q149. What are the difference between digital and analog? Ans: 1) A digital system uses 1 or 0 to transmit data or represent data. 2) An analog does not use multiples of 1 or 0 rather uses full range of Numbers, including fractions. 3) Analog clock can display fractions of a second. Q150. What is baud rate? Ans:1) The sending and receiving speed of a modem is called baud rate. 2) Most modern modems have a maximum baud rate of 56 Kb/s.