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