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