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