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