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