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