Asked Question Set 9 January 28, 2025October 8, 2022 by admin 0% Asked Question Set 9 Asked Question Set 9 1) Multiple Calculation can be made in a single formula using? Array formula Smart formula Complex formula Standard formula 2) What is the shortcut key to display field codes? Alt+F9 Space+F9 Shift+F9 Ctrl + F9 3) The default subnet mask for the class 3 networks? 255.255.0.0 255.255.255.0 255.255.255.128 255.0.0.0 4) The number of rows in a worksheet of excel 2003 is? None of these 36500 64536 65536 5) Which feature of MS Word enables to send the same letter to different persons? Macros Template Mail merge None of these 6) What is placed to the left of horizontal scroll bar? View buttons Tab stop buttons Split buttons Indicators 7) Which command is used to display a list of deleted files that DOS can undelete? Undelete/all Undelete/list None of these Undelete*.* 8) The technique which defines a set of values acceptable for the field is known as? Validation Verification Acceptance Setting 9) Which of the following is the property of primary key? Limited Duplicate Pictorial Unique 10) What is the shortcut key to add a new slide in a presentation? Ctrl + M Ctrl + P Ctrl + O Ctrl + N 11) Which of the following statement regarding the optical fiber is false? It can support more band-width than copper wire It is less prone to interference than copper wires It is cheaper than copper wire It can transmit data to a longer distance than copper wires 12) What is tha maximum number of slides that can be printed in a bandouts? 12 4 6 9 13) Technique of displaying only those records that meet the defined criteria is known as? Separating Filtering Differentiating Selecting 14) Which command is used to copy files? Diskcopy Copy Ren Type 15) What is gutter margin? Margin that is added to the right margin when printing Margin that is added to the left margin when printing Margin that is added to the outside of the page when printing Margin that is added to the binding side of page when printing 16) Charts in worksheet itself is known as? Overlapping chart Implied chart Inserted chart Embedded chart 17) What is the maximum number of lines set for “lines to drop box”? 10 3 15 5 18) To copy the hidden system files of DOS to another disk,you can use the command? Ren Diskcopy Sys Copy 19) What is the name of the batch file that automatically runs when MSDOS is booted? Config.bat Config.sys Run.bat Autoexec.bat 20) Which of the following is fastest memory? RAM DVD Cache Hard disk 21) Post stands for? Power on Self-Test Power Outage Survival too Peripheral Output Standard Terminal Public Outlay Software Test 22) By default, document in MS Word prints with? All of these A portrait orientation 1 inch top margin 1. Inch bottom margins 23) Abbreviation CAD stands for? Computer Aided Design Computer Aided Definition Calculator Aided Design Computerized At Destruction 24) Which is the best tool for fixing errors on disk? Chkdsk Scandisk Fdisk Fixdisk 25) What is the shortcut key for “find and replace” dialog box? Ctrl + R Ctrl + Shift + = Ctrl + H Ctrl + F 26) ….is used to select multiple non-adjacent cell in a worksheet? Shift key Tab key CTRL key Alt key 27) The arrangement of elements such as title and subtitle text, pictures, tables etc. Is called? Scheme Layout Design Presentation 28) Sped of printer is measured in? CPI MPI FPM PPM 29) Which of the following is not a font style? Italicks Regular Bold Superscript 30) Which of the following is not available in font spacing? Loosely Expanded Condensed Normal 31) Which of the following is an absolute cell reference? #A1# $A$1 &A1$ #A$1 32) Data Definition Language (DDL) includes? All of these Select query Creating table Data insert 33) 10 seconds is equal to? 0.001 milli-sec 10000 milli-sec 100 milli-sec 1000 milli-sec 34) Getting data from a cel located in a different sheet is called? referencing Updating Functioning Accessing 35) What is the shortcut key to “Superscript” the selected text? Ctrl + shift + = Ctrl + Shift + = Ctrl + – Ctrl + = 36) In display unit the ratio 1024×800 is known as? BII PPM DPI Aspect Ratio 37) Which feature is used to create a newspaper like document? Columns Tap stops Tables Bullet & numbering 38) What function key is used for slide show? F5 F4 F6 F3 39) Which command is used to confirm before deleting the directory? Deltree Erase*.* Del*.*/p Deltree/f 40) ASCI value of character ‘a’ is? 97 95 98 96 41) Joystick is……kind of device? Storage Input Processing Output 42) Which of the following is used to change margins? Standard toolbar Page setup dialog box Paragraph dialog box Formatting toolbar 43) What is the output of the text function =MID(“regression”,3,2)? Egr Re Gr Gre 44) Highest speed Network Media is? 6 bytes Optical Fiber Microwave Satellite 45) Invalid formula category.n EXCEL is? Conditional Financial Graphical Statistical 46) A data manipulation command that combines the records from one or more table is called ? PROJECT SELECT PRODUCT JOIN 47) Which of the following is not the part of the CPU? Arithmetic logical unit Control unit Cache memory Hard disk 48) Conditional count can be performed using? Countiff Countif Ifcount Iffcount 49) What is the shortcut key for selling check in documents? Ctrl + F7 Shift+F7 Alt + F7 F7 50) An IP address in IP v4 is of? 3Bytes 6Bytes 4Bytes 2Bytes 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