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