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