Asked Question Set 11 January 28, 2025October 8, 2022 by admin 0% Asked Question Set 11 Asked Question Set 11 1) You can print? An entire worksheet All of these A range of cell by range name A single worksheet 2) Which command is used to display all the having (.exe) extension but the different file name? Dir filename.* dir*.ext Dir filename.ext dir*.sys 3) Which of the following formulas is not entered correctly? =B7*B1 10+50 =B7+14 =10+50 4) To auto fit the which of column? All of these Double click the right border of column Double click the column header Double click the left border of column 5) Which of the following is not a valid view type in MS-word? Outline layout Web layout Print layout Inline layout 6) Which among the following are the best tools for fixing errors on disk? Fdisk Scandisk Chkdsk Fixdsk 7) GIF images can have only upto……colors? 128 256 512 1024 8) Component of computer system? Input unit Processing unit Output unit All of these 9) Which file format can be added to a Power Point show? .jpg .gif All of these .wav 10) Getting data from cell located in a different sheet is called? Referencing Updating Functioning Accessing 11) Key combination used for UNDO in MS word is? Ctrl + 1 Ctrl + S Ctrl + U Ctrl + C 12) Which symbol must all formula begin with? @ ( = + 13) Transistor is related to………generation computers? Fifth Second Fourth Third 14) C language was developed by….? Steve jobs Bill Gates Linus Torvalds Dennis M.Ritchie 15) The key F12 opens a? Close dialog box Save dialog box Open dialog box Save as dialog box 16) CHKDSK command is used to? Diagnose the hard disk error Report the status of files on disk All of these Analyze the hard disk error 17) A feature of MS Word that saves the document automatically after certain interval is available on? Save as dialog box None of these Pressing Ctrl + S Save tab on options dialog box 18) Program developed according to the requirement specific to an office is…..? Packaged software Tailored software All of these Utility software 19) You can break the column by? Pressing alt+enter Pressing shift+enter Pressing ctrl+enter Pressing ctrl+shift+enter 20) Absolute reference to cell A3 is expressed as? $A$3 @A$3 @A3 A$3 21) Which file starts MS Word? Msword.exe Word2003.exe Winword.exe Word.exe 22) If any person publishes illegal materials in electronic form, he shall be liable to the punishment with? Fine not exceeding two thousand rupees and with imprisonment not exceeding five years or with both Fine not exceeding two thousand rupees or with imprisonment not exceeding three years File not exceeding one hundred thousand rupees or with the imprisonment not exceeding five years or with both Fine not exceeding two thousand rupees or with imprisonment not exceeding three years or with both 23) Which command is used to change the file name? Both of these Rename None of these Ren 24) You want to track the progress of the stock market on a daily basis. Which type of chart should you use? Pie chart Column chart Row chart Line chart 25) What is the short cut to justify text to center? Ctrl + C Ctrl + S Ctrl + 1 Ctrl + E 26) MS-Excel files have a default extension of? .xlw .xsl .doc .xls 27) Which of the following is not a type of page margin? Left Right Center Top 28) To invoke help in MS window one has to use? F3 F4 F1 F2 29) A protocol is——-? Interconnection pattern of computers A device for internet Set of rules for communication An operating system 30) Unicode standard is? Keyboard layout Character encoding system Software Font 31) What is a portion of a document in which you set certain page formatting options as default? Document Page Page setup Section 32) If you want to keep track of different editions of a document which features will you use? All of these Versions Track change Editions 33) To underline selected text in one can use? Shift+A Tab+U Ctrl + U Alt+U 34) ………..is a collection of data stored in a standardized format, designed to be shared by multiple users? Database management system Database Relation Record 35) Cache memory…….. ? Helps to store more data in hard disk Holds last time visited web site only Placed between main memory and microprocessor, Stores data permanently 36) The batch file uses the extension ? .DOS .DOC .BAT .PRG 37) IBM 1401 was brought to prepare the census report of…..? 2018BS 2028BS 2038BS 2048BS 38) Which of the following is the type of computer on the basis of size? Micro Hybrid Analog Digital 39) Which of the following should yoy use if you want all the slide in the presentation to have the same”look”? Outline view A presentation design template Add a slide option Tie slide layout option 40) If you press………, the cell accepts your typing as its contents? Insert Tab Ctrl + enter Enter 41) To add the number of cell A2 and A9? =sum(A2,A9) =add(A2:A9) =sum(A2 and A9) =sum(A2 and A9) 42) File with which extension is not executable? exe bat com sys 43) The sql query : SELECT *FROM employee? All of these Displays all records from employee table Displays structure of employee table Displays all field names from employee table 44) Which of the following is an example for automatic text formatting? Adjusting extra space Underlining hyperlink Replacing two-'s with an hyphen All of these 45) A dot matrix printer? Is output device Cannot print alphabet Cannot print number Input device 46) A circular reference is? A formula that either directly or indirectly depends on itself Geometric modeling tool Always erroneous A cell that points to a drawing object 47) Excel uniquely identifies cells within a worksheet with a cell name which is a? Cell names Number Column numbers and row letters Column letters and row numbers 48) Which of the following storage is fastest? Register RAM Blue-ray disc ROM 49) Feature that enables several people to work to create and update a document? Document sharing Document collaboration Document protection Document locking 50) A field or group of fields that uniquely indentifies every row of a table is……, Primary key Foreign key Hot key Access key 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