Asked Question Set 16 January 28, 2025October 8, 2022 by admin 0% Asked Question Set 16 Asked Question Set 16 1) Which of the following is correct syntax in Excel? =If(LogicalText, TrueResult)(LogicalTest, FalseResult)) =If(LogicalText, TrueResult, FalseResult) =If(LogicalText, TrueResult), If(LogicalTest, FalseResult)) =If(LogicalText, (TrueResult, FalseResult) 2) Which tool can the user use to set indent or tabs? Toolbar Insert point Ruler Title bar 3) …..is collection of web page and……is very first page that we see on opening of a website? Home-page, web page Web-site, home-page Web-page, home-page Web-page, Web-site 4) Which of the following SQL command can use be used to modify exiting data in a database table? Modify New Update Change 5) Which device is used as the standard pointing device in a Graphical User Environment? Joystick Mouse Light pen Track ball 6) What is a compiler? A compiler does a conversion line by line as the program is run A compiler converts the whole of a higher level program code into machine code in one tap A compiler is a general purpose language providing very efficient execution None of these 7) Many operating system directory structures are? Virtual Hierarchical Disparate Discrete 8) In computer network, what is a collection of parallel electrical wires with the multiple connections that transfer data between components inside a computer ? ALU Buses SMPS Connectors 9) How footnotes, endnotes and indexes are inserted in a document ? As cross-references As hyperlinks As bookmarks As word firlds 10) A form can be used to? Delete records All of these Format printed output Modify records 11) Microsoft Access is a? OODBMS RDBMS None of these ORDBMS 12) How do you wrap the text in a cell? Format, cells, number Format, cells, protection Format, cells, font Format, cells, alignment 13) A term associated with the comparison of processing speeds of difference of different computer system ? EFTS MIPS None of these CPS 14) What do you call a faint image that you add to the background of a document report ? Watermark Gutter Style Backgraound image 15) In microsoft PowerPoint in order to see all the slides on one screen use? View, Slide View, Master View, Slide Show View,slide sorter 16) The ascending orderof a data hierarchy is? Bit-byte-record-field-file-database Byte-bit-field-record-file-database None of these Bit-byte-field-record-file-database 17) Formula palette is used to? Format cells containing numbers Entered assumption data Copy all cells Create and edit formulas containing function 18) Getting data from a cell located in a different sheet is called ? Functioning Accessing Updating Referencing 19) How can we view a cell comment? Click the edit comment commads on the insert menu Click the comment command on the view menu Click the display comment command on the window menu Position the mouse pointer over the cell 20) Which key on the keyboard can be used to view slide show? F5 F2 F1 F10 21) An input device that converts data punched into paper tape into a binary format is? Page reader Paper tape punch Card punch Paper tape reader 22) The…..keeps track of directories and files? File system User interface Kernel Shell 23) Babbage presented is……to the Royal Astronomical society which was able to calculate polynomials? Difference engine Diesel engine Petrol engine Computer engine 24) A table can have only one? Foreign key Unique key Alternate key Primary key 25) By default, on which page the header or footer is printed? On every page On first page On current page On alternate page 26) Presentation designs regulate the formatting and layout for the slide and are commonly called ? Templates Design plates Blueprints Placeholders 27) The ALU of a computer normally contains a number of high speed storage element called ? Registers Hard disks Magnetic disk Semiconductor memory 28) Queries can be created in Access by? Typing queries in SQL view Using query wizard All of these Drag and drop fields on query builder 29) Before the day of windows, users interfaced with the operating system through a…….interface ? Graphical Object orinted Command Utility Command line 30) To insert a new slide in the current presentation, we can choose? Ctrl + O Ctrl + F Ctrl + M Ctrl + N 31) What does the disk drive of the computer do? C.Both A and B A.Read the disk D.None of these B.Load the programme from disk to memory 32) Which of the following is TRUE? UNICODE uses more space and can support more languages than ASCII ASCII is American code and Unicode is only used at universities None of these ASCII uses less space and can support more languages than UNICODE 33) A quicker way to launch a program is to click it in the…..? Quick lunch toolbar Desktop Taskbar System Tray 34) Which one is not a video file extension? JPG AVI MOV MP4 35) What is the shortcut key to open the thesaurus window ? Alt+F7 Ctrl + F7 Shift+F7 F7 36) Most operating systems are comprised of three main components: the file system, the shell and? Code Desktop User interface Kernel 37) Which of the following is a type if relationship that can be applied in access database ? All of these One to One One to many Many to many 38) The HTML tag used to create a hyperlink is? <aurl="htttp://www.myexams.com">MY EXAMS</a> All of these <a>http://www.myexams.com>MY EXAMS</a><br> <a href="http://www.myexams.com">MY EXAMS</a> 39) Which of the following are valid minimum and maximum zoom sizes in MS Word? 20,250 10,500 10,100 10,1000 40) When was the latest ICT policy of Nepal promulgated? 2070BS 2067BS 2073BS 2072BS 41) Which enables you to move directly to specific location in a document ? Subdocuments Cross-references Bookmarks Outlines 42) In Excel, what is a Data Series? A division of results A collection of related data A cell reference A type of chart 43) What would you choose to create a pre-formatted style? Slide design Slide layout Slide transition Slide sorter view 44) Hardware or software designed to guard against unauthorized access to a computer network is known as a(n)? Hacker-resistant server Encryption safe wall Hacker-proof program Firewall 45) Which feature is used for monitoring all document changes ? Track all Edit document Track change Monitor change 46) Which of the following formulas will Excel not be able to calculate? =SUM(A1:A5)/(10-11) =SUM(Purchase)-A4 =SUM(A1:A5)-10 =SUM(A1:A5)*.6 47) Data can be imported into Access database from? Excel files PowerPoint files Notepad files Word files 48) What is the shortcut key to hide entire row? Ctrl + H Ctrl + 9 Ctrl + – Ctrl + R 49) Which of the following HTML tag will provide the largest heading ? <h6><br> <h1><br> <head8><br> <heading 6><br> 50) Which wildcard is used to replace a single character ? ? * & ! Your score isThe average score is 0%Share this quiz with your friends. LinkedIn Facebook Twitter Follow Us @ 0% Restart quiz Exit Please drop your valuable review. Send feedback