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