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