Asked Question Set 21 January 28, 2025October 8, 2022 by admin 0% Asked Question Set 21 Asked Question Set 21 1) Which of the following device is best to use when designing SOHO network to ensure the least amount of collisions? Access point Bridge Switch Hub 2) Which statement is false? You can restore any files in recycle bin if you ever need Allnof these You can increase free space of disk by sending files in recycle bin You can find deleted file in recycle bin 3) Which spreadsheet feature is used to highlight specific cells? Cell formatting Data filter Cell highlight Conditional formatting 4) Database management systems are features with? The ability to calculate efficiently with the help of built in function and analyze The facility to easy editing, spelling check,auto pagination layout and printing reports All of these The ability to store large amount of data to facilitate easy update, sort and retrieval 5) Which is a small green square in the lower right corner of a selected cell or range that you can use to copy one cell to adjacent cells or to create series ? Fill handle Formula bar Cell pointer Column marker 6) Gutter position can be set in following positions ? Left and top Left and right Left and bottom Left only 7) ……..is used to convert from upper case to lower case and vice versa? Lower case Sentence case Toggle case Upper case 8) Which feature of presentation software is used to create consistent layout throughout the presentation? Slide design Layout master Slide master Theme 9) Which of the following are considered both input and output devices? Printer,Speaker Smart TV,Touch screen,KVM,STB Keyboard,Mouse,Touchpad Smart card reader,Monitor,Sensor,Biometric,device 10) The HTML tag used to create hyperlinks is? <a url="https://www.mcqsewa.com>Examnor</a> None of these <a namelink="https://www.mcqsewa.com>Examnor</a> <a href="https://www.mcqsewa.com">Examnor</a> 11) Which field property is used to hide actual input by content like***? Protect Hide rule Input mask Format 12) When you split a window, the window is devided into how many panes? D.Both A and C A.Two B.Three C.Four 13) Which generation of computer was based on GUI based operating system? Second Forth First Third 14) Which function in MS excel counts the number of character in a cell? LGT LT LENGTH LEN 15) If a process falls, operating system writes the error information to a? None of these Another running process Log file New life 16) Hard disk uses magnetic storage data using rapidly rotating disk called? Platter Head Accuator Flater 17) Which tag is used to display the numbered list? <Dl> </Dl> <ol> </ol> <li></li> <ul></ul> 18) Which one of the following piece of code produces output x2? x<square>2</square> x<pow>2</pow> S<sq>2</sq> x<sup>2</sup> 19) Key combination used for Thesaurus is? Shift+F7 Ctrl + F7 Ctrl + T Shift+T 20) Key combination used for align right is? Ctrl + Y Ctrl + R Shift+R Ctrl + U 21) Which among following is not the linux operating system ? Fedora Solaris Mint Red hat 22) Which of the following statements about hidden and unhidden worksheet is correct ? Unhidden worksheet cannot contain formula that refer to hidden worksheet Excel cretes a minimized window for each hidden worksheet A hidden worksheet cannot be inadvertently deleted Where you click find the find and replace dialog box will show matched content within hidden worksheet as well as unhidden ones 23) What is the shortcut key for showing “find and replace” dialog box to replace of text by another text? Ctrl + H Ctrl + D Ctrl + F Ctrl + R 24) Which MS access object is used to retrieve data from tables? Query Report Marco From 25) Which of the following device has MAC address? Network card Amplifier Sound card Modern 26) Which one is not correct ? Primary key doesn't accept null value Primary key must be numeric field only Primary key doesn't allow duplicate entry Primary key is essential for relationship 27) Which operating system is sensitive to deadlines? Embedded OS Critical OS Real time OS Time sharing OS 28) What would you do for the quick access to the page you visited ? Typing the URL into the search bar Searching for it on google Going to another page that links to it Saving it as a favourite/bookmark 29) What is the octal equivalent off AB16? 523 325 532 253 30) Formula palette is used to? Entered assumption data Copy all cells Create and edit formulas containing functions Format cells containing numbers 31) To present slideshow from currently slide you press? Alt+F5 Ctrl + F5 F5 Shift+F5 32) Where the ‘new commeny’ toll resides in word processor? Review Tab Insert Tab Reference Tab View Tab 33) Which of the following is “not equal to” operator in spreadsheet? # <> != All of these 34) Which of the following is an example of an absolute cell reference? $A$9 A$9 A9 A9:E9 35) What is the storage element for a Static RAM? Capacitor Filp flop Resistor Diode 36) What function key used hyperlink facility? Ctrl + K Ctrl + H Alt+K Alt+H 37) Even after a major component failure, the system can continue working if nothing has happened. What is it called ? Fault tolerance Redundancy Interoperability Backup 38) Where we need to right click to display “task bar and start menu properties” dialog box? Start menu Status bar Taskbar Menu bar 39) Which among the following is used to launch an application while clicking a button in powerpoint presentation ? Slide navigation Hyperlink Slide show Action 40) Which type of scanner is used in point of sales? OML OCR OBCR MICR 41) Which tool of word processor is used for creating documents with set styles and formatting settings? Template Readymade documents Mail merge Style and formatting Your score isThe average score is 0%Share this quiz with your friends. LinkedIn Facebook Follow Us @ 0% Restart quiz Exit Please drop your valuable review. Send feedback