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