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