Asked Question Set 5 January 28, 2025October 8, 2022 by admin 0% Asked Question Set 5 Asked Question Set 5 1) Each excel file is a workbook that contains different sheets, Which of the following cannot be a sheet in workbook? Worksheet Data sheet Module sheet Chartsheet 2) How can you update the values of formula cells if auto calculate mode of excel is disabled? F8 F9 F10 F11 3) In the relational models, cardinality is termed as? Number of tables Number of constraints Number of tuples Number of attributes 4) A computer program that translates one the program instructions at a time into machine language is called a/an? Compiler CPU Interpreter Simulator 5) Borders can be applied to? Paragraph Cells All of these Text 6) Personal computers use a number of chips mounted on a main circuit board. What is the common name for such boards? Fatherboard Daughter board Breadboard Motherboard 7) Where can you find the horizontal split bar? On the top of vertical scroll bar On the right of horizontal scroll bar On the bottom of vertical scroll On the left of horizontal scroll bar 8) When did archrivals IBM and apple computers Inc. Decided to join hands? 1978 1991 1990 1984 9) Which device is used as a standard pointing device in a Graphical User environment? Keyboard Mouse Trackball Joystick 10) Which of the following device can have maximum storage of data? Hard disk Magneto optic disk Floppy disk Compact 11) WAN Stands for? Wide array net Wide area network Wap area network Wireless area network 12) Which of the following is not a type of page margin? Top Right Center Left 13) You can use the formula palette to? Create and edit formula containing functions Copy a range of cells Format cells containing numbers Enters assumptions data 14) Tab scroll buttons are placed on excel screen? Towards the bottom left corner Towards the bottom right corner Towards the top left corner Towards the top right corner 15) ALU is? Application logic unit Array logic unit None of these Arithmetic logic unit 16) Where can you change automatic or manual calculation mode in Excel? Go to Tools >>Options>>Calculation and mark the corresponding radio button Double click CAL indicator is status bar None of these Both of these 17) Which tool you will use to join some cells and place the content at the middle of joined cell? Click on merge and center tool on formatting toolbar From format cells dialog box select the centered alignment From format cells dialog box click on merge cells check box From format cells dialog box choose merge and center check box 18) Which of the following is not the output device? Flatscreen Printer Scanner Touchscreen 19) You can merge the main document with data source in Excel. In mail merge operation, word is usually? Client None of these Server Source 20) Virtual memory is? A type of memory used in super computer An extremely large main memory An extremely secondary main memory An illusion of extremely large secondary memory 21) Which of the following is not valid version of MS Office? Office 2007 None of these Office XP Office Vista 22) You cannot close MS Word application by? Choosing file menu then exit submenu From file menu choose close submenu Click X button on title bar Press Alt+F4 23) Who designed the first electronics computer-ENIAC? All of these J presper Ecket and john W.Mauchl Joseph M.Jacquard Von-Neumann 24) The view of total database content is? Definition of physical structure of database system Conceptual view Addition of new structures in the database system Manipulation & processing of database 25) DML is provided for? Definition of physical structure of database system Description of logical structure of database Addition of new structures in the database system Manipulation & processing of database 26) Which file starts MS Word? Word2003.exe Word.exe Windword.exe Mswrod.exe 27) Who invented the high level language C? Niklaus Writh Dennis M.Ritchie Seymour papert Donald Kunth 28) Which number system is usually followed in typical 32 bit computers? 16 2 32 10 29) You want to set such that when you type Baishakh and drag the fill handle, Excel should produce jeshtha,Asadh and so on. What will you set to effect that? Auto fills options Fill across worksheet Custom list Fill series 30) Material consisting of text and numbers is best presented as? A bullet slide All of these A table slide A title slide 31) The name box on to the left of formula bar? Shows the name of cell or range currently working on None of these Shows the name of worksheet currently working on Shows the name of workbook currently working on 32) What is the shortcut key to open the open dialog box? Shift F12 Alt F12 F12 Ctrl F12 33) The key F12 opens a? Save dialog box Save as dialog box Close dialog box Open dialog box 34) A page fault occurs? When the page is not in the memory When the process enters the blocked status When page is in the memory When the process is in the ready state 35) background color or effects applied on a document is not visible in? Web layout view Print Preview Reading View Print layout view 36) If you want to keep track different editions of a document,which features will you use? Versions Editions Track change All of these 37) In UNIX the status of the process may be? Sleeping All of these Orphan Running 38) Which of the following device have limitation that we can only store information but cannot erase or modify it? Tape drive CD ROM Hard disk Floppy disk 39) In microsoft Powerpoint Two knd of sound effects files that can be added to the presentation are? .wav files and .gif files .wav files and .mid files .jpg files and .gif files .wav files and .ppg files 40) What is the place to the left of horizontal scroll bar? View buttons Indicators Split buttons Tab stop buttons 41) When a range is selected, how can you activate the previous cell? Press Enter None of these Press Tab Press the Alt key 42) How can you show or hide the gridlines in Excel worksheet? Click gridline tool on forms toolbar None of these both of these Go to tools>>options>>view tab and mark or remove the check box named gridline 43) A feature of MS Word that saves the document automatically after certain interval is available on? Save tab on options dialog box None of these Both of these Save as dialog box 44) Which of the following device can be used to directly image printed text? OMR MICR OCR All of these 45) How many ways you can save a document? 3 5 6 4 46) Modern Computer is very reliable but they are not? Fast Infallible Cheap Powerful 47) The PID of kernel process is? 3 1 Undefined 9 48) Which of the following is not the correct method of editing the cell content? Press the Alt key Click the formula bar Press the F2 key Double click the cell 49) Which is not the state of process? Ready Running Privileged Blocked 50) What is a portion a document in which you set certain page formatting options? Document Page Page setup Secton 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