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