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