Asked Question Set 13 January 28, 2025October 8, 2022 by admin 0% Asked Question Set 13 Asked Question Set 13 1) Which of the following is a set of actions that the user can create to automate common tasks? Pages Macros Modules Reports 2) How many cells are there in f16 to H17? 3 12 6 9 3) In goal seek, the “by changing cell” refers to the cell? A containing the outcome formula Containing the constraints Containing the target value That you are attempting to calculate 4) Which elements of a worksheet can be projected from accidental modifications? Objects All of these Scenarios Contents 5) We need……To terminate the signal while using UTP cable? SN-Terminal RJ-11 BNC RJ45 6) Who invented analytical engine? Charles Babbage George Bool Dr. Herman Hollenith Braise Pascal 7) How footnotes, Endnotes and Indexes are inserted in a document? As Cross references As Word fields As bookmarks As hyperlinks 8) Which tool can the user to set indents or tabs? Tool bar Ruler Title bar Insert option 9) Data integrity contro? Has the data dictionary keep the data and time of fast access backup and most recent modification for all files Requires the use of passwords to prohibit unauthorized access to the file None of these Is used to set upper and lower limits on numeric data 10) Which of the following coded uses 7 bits to represent a character? BCD EBCDC GRAY ASCII 11) In Microsoft PowerPoint the entry effect as one slide replaces another in a show is called a? Animation Custom animation Slide transition Present animation 12) World Wide Web is founded by? Charles Babbage Tim Bener lee E.F. Codd Bill Gates 13) For each instruction in program memory the CPU goes through a? Execute store decoded sequence Fetch decode execute sequence Fetch executed decoded sequence Decode fetch execute sequence 14) The network topology with highest reliability is…….? Mesh topology Bus topology Ring topology Star topology 15) If name “profit” is assigned ti cell D5 then? B.Formula D5/2 may be written as "profile"/2 A.Value of D5 is "profit" D.None of these C.Both A and B 16) Word count gives you………? Number of paragraphs All of these Number of character Number of lines 17) In Access, which wild card is not mostly used? * # @ ? 18) What message will be displayed in the status line when a formula +A1+A2 is entered in cell A1? Zero Circ Error Mem 19) The programs which are as permanent as hardware and sorted in ROM are known as? ROM ware Filmware Hardware Software 20) A format rule that affects the entire worksheet is called? Individual format rule Hierarchical format rule None of these Global format rule 21) What do you call the transistor that translates assembly language program into machine codes? Assembler Interpreter Compiler Debugger 22) What is the shortcut key for slide show? Ctrl + S Alt+S F9 F5 23) What would you choose to create a pre-formatted style? Slide layout Slide transition Slide sorter view Slide design 24) Computer virus is a software program which has the essential ability to? All of these Clone itself Damage Data Hide itself 25) What is the executable file of Ms Excel? MS Excel Excel None of these Win Excel 26) Which enables you to move directly to specific location in a document? Cross references Outlines Subdocuments Bookmarks 27) Which function do you use to return the remainder after a number is divided by division? MOD() FACT() ROUND() DIV() 28) What is the shortcut key to reach at the begging and at the end of a long 1000 page document? Shift+Home and Shift+End Ctrl+Page and Ctrl+PgDn Ctrl+Home and Ctrl+End Alt+Home and Alt+End 29) Which keys do you press to quit without saving in MS DOS? Ctrl + C Ctrl + S Ctrl + Q Ctrl + A 30) Which of the following have the fastest access time? Magnetic tap Magnetic disk Semiconductor memory Compact disk 31) When computer is turned on, which of the following is first executed? Operating system Application software System software Bootstrap loader 32) Which of the following you can do with electronic mail? A.Send and read mail D.Both A and B C.Delete someone else's mail B.Delete, reply to or Forward 33) Recycle Bin Stores? Temporary deleted files Permanently deleted files None of these Unnecessary files 34) Pie-chart in Excel can be created using…….? One Data series and all values are positive One data series and all values are negative Two data series and all values are negative Two Data series and all values are positive 35) What is a Data series in MS Excel? A collection of related data A division of Results A type of chart A cell reference 36) ………shows the list of synonyms? Auto correct Thesaurus Spelling and grammar Auto Text 37) Which of the following is not an internet protocol? IPX IPV4 IPV6 None of these 38) Which object is used to create a form in Mocrosoft Access? Tables and Reports Queries and Reports Tables only Tables and queries 39) Protecting the data from unauthorized access is called? Data encryption Data validity Data security Data inaccessibility 40) tag is used to? Display the number list Bold the text Underline the text Display the bulleted list 41) A query is? D.None of these B.Expressed using a query language A.A miniature program that tells the DBMS what to do C.Both A and B 42) The basic operation performed by a computer are? Allof these Storage Arithmetic operation Logical operation 43) The indicator on the screen that shows where things will happen next in MS Word is called ? Control key Arrows key Cursor None of these 44) The 0,1 of the data is known as? Nibble Bit Byte Half Byte 45) What is the shortcut key to open the thesaurus window? Alt+F7 Shift+F7 F7 Ctrl + F7 46) Which of the following is not a body tag properties? Text Bgcolor Background Image 47) Studies have shown that the easiest documents to read use? None of these Ragged left margins Ragged right margins Right justified margins 48) Which of the following wild card is used most often in command lone operation? ? % # * 49) Which feature is used for monitoring all document changes? Track change Monitor change Edit document Track all 50) How do you switch between programs? Shift+F10 Alt+Tab F6 F1 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