Asked Question Set 7 January 28, 2025October 8, 2022 by admin Home › Computer Operator › Asked Question Asked Question Asked Question Set 7 📝 Model Practice Set ⚡ Instant Answers & Explanation 🎯 Exam Oriented 0% Asked Question Set 7 Asked Question Set 7 1) Drag and drop feature allows you to…..? Open a new document and drop it into the active document Move and copy text using the mouse Switch from insert to over type mode Move and copy text using the clipboard 2) Back up of the data files will help to prevent? Loss of confidentiality Loss of data Virus infection Duplication of data 3) Good design determines? All of these Readability First impression Credibility 4) Queries in Access can be used as? A.View,change and analyze data in different ways D.Both A and B B.A source of records for forms and report C.Only B 5) Access method in Hard disk is? Serial All of these Random Sequential 6) Which of the following is an absolute cell reference? #C$1 $C$1 &C1$ #C1# 7) To select multiple non-adjacent cells in a worksheet you will click them holding? Ctrl key Ctrl+Shift key Shift key Alt key 8) When a formatted number does not fit within a cell, it displays? )DIV/0 None of these #DIV/0 #### 9) Which of the following is not type of page margin? Center Left Right Top 10) What do you cell a single point on a computer screen? Bit Element Cell Pixel 11) To insert three columns between columns D and E you would? Select column E,F and G Select column E Select column D,E and F Select column D 12) Which of the following line spacing in invalid? Double Single Triple Multiple 13) This key uniquely identifies each record in a table of a database is a? Key record Unique key Field name Primary key 14) ASCII code of ‘A’ in decimal is? 34 65 98 95 15) _____has the shortest access times? Cache memory Secondary memory All of these Virtual memory 16) When inserting page number in footer it appeared 1 but you wish to show a how can you do that? All of these From format menu choose bullets and numbering and configure necessary setting From insert menu choose page number and specify necessary setting Click on page number format tool and specify required setting 17) What is the purpose of inserting header and footer in document? To enhance the overall appearance of the document To allow page headers and footers appear on document when printed To make large document more readable To mark the starting and ending of page 18) What happens when you click on insert >>picture>> clip art? H opens clip art task bar It inserts a clipart picture into document None of these It let's you choose clipart to insert into document 19) Which operation you will perform if you need to move a block of text? Cut and paste Paste and delete Paste and cut Copy and Paste 20) Which of the following is NOT available in spread sheet? Mail merge facility Pivot table What-if analysis Statistical Function 21) Which of the following is the programming language? VISIO Java MS-Access MS-Word 22) _____tool helps to reduce file access time from disk? Disk defragmenter Scandisk Backup Format 23) Formatting a cell in currency, you can specify? None of these Decimal places Currency symbol Both of these 24) In word, the mailing list is known as the______? Sheet Data sheet Data source Source 25) Multiple calculations can be made in a single formula using? Complex formula Standard formula Smart formula Array formula 26) Chart in worksheet itself is known as? Embedded chart Overlapping chart Implied chart Inserted chart 27) Computer virus? Can destroyboot sector All of these Can effect installed program Can destroy files 28) Portrait and landscape are? Paper size Page Oprientation All of these Page layout 29) Which of the following retains the information its storing when the power to the system is turned off? ROM DIMM CPU DRAM 30) Getting data from a cell located in a different sheet is called? Functioning Referencing Accessing Updating 31) Ms Office provides help in many ways, which of these is one of them? What is this? Help menu Office Assistant All of these 32) The output quality of a printer is generally measured by? All of these Dots printed per unit time Dot per inch Dot per meter 33) Thesaurus tool in MS-Word is used for? Grammar option Spelling suggestions Synonyms and antonyms words All of these 34) Which of the following is not an operating system? Dos Windows Linux Oracle 35) Objects on the slide that hold text are called? Placeholders Auto layout Object holders Text holders 36) Which one of the following printers is suitable for printing carbon copies? Laser Drum Ink-jet Dot matrix printer 37) Which of the connector is used to plug a telephone line into a modem? Rj-11 RJ45 COM1 Rj-10 38) Red triangle at top right corner of a cell indicates? There is an error in the cell The font color of the text in cell is red The cell can't accept formula There is a comment associated with the cell 39) Which of the following is a file attribute? Read only Hidden Archiv All of these 40) Which of the following is NOT a logical operator? > < = + 41) Short-cut key combination for closing windows is_____? F1 Ctrl+V Alt+F4 Ctrl+S 42) What do you mean by one-to-many relationship between student and class table? One class may have many students One student can have many classes Many classes may have many students Many students may have many classes 43) A row or number used to identify storage location is called? All of these An address A byte A record 44) What is BIOS an acronym for? Bootstrap intial operation system Basic input output system Boot initial operating startup Basic input output startup 45) Which of the following is not a component of control panel? Keyboard Printer Mouse Monitor 46) Which of the following is not a font style? Superscript Regular Italics Bold 47) A bookmark is an item or location in document that you identify as a name for future reference? To mark the ending of a paragraph of document To quickly jump to specific location in document To add anchor in web page To add hyperlinks in webpage 48) Conditonal count can be performed using? Countif() Ifcount() Countiff() Iffcount() 49) RJ-45 UTP cable has____cables? 4 pair 3 pair 2 Pair 5 pair 50) From which menu you can insert header and footer? Tools menu Insert menu Format menu View menu 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