Asked Question Set 17 January 28, 2025October 8, 2022 by admin 0% Asked Question Set 17 Asked Question Set 17 1) Which shortcut key is used to hide entire column in Excel? Ctrl + ? Ctrl + 0(zero) Ctrl + C Ctrl + H 2) In a datasheet, what does each row represents? Database Table Field Record 3) Formatting a cell in number format you cannot set? Use 1000 separator Decimal place Currency symbol Negative numbers 4) Which of the following task is accomplished by using bookmarks? To add hyperlinks in web page To add anchor in web page To quickly jump to specific location in document To mark the ending of a paragraph of document 5) Which formula is used to display current date and time in MS Excel? =time() =Date() =today() =now() 6) The shortcut key for the format painter is? Alt+Ctrl+c Alt+shift+c Ctrl + Shift + C None of these 7) In MS access,”Hyperlink” data type can store…….? Path of file Web address All of these Email address 8) In analogue computer All of the these Output is displayed in digital form Input is never converted to digital form Input is First converted to digital form 9) FAT stands for? File Accomodation Table File Allocation Table File Access Tape File Activity Table 10) Which view in PowerPoint can be used to enter speaker comments? Normal Slide sorter Notes page views Slide show 11) What is full form of SMPS? Storage mode power shortage Simple mode power supply Switch mode power supply Storage mode power supply 12) Which command will be used to display a file within the specified directory of pathname? Dirpathname Dirpathnamepathname Dirpathnamefilename Dirch 13) Which command is used to delete the directory that is empty? MD Erase RD Del*.* 14) Portrait and landscape are? All of these Page layout Page Oprientation Paper size 15) In word, the mailing list is known as the……..? Source Sheet Data source Data sheet 16) Which of the following is not available on the Ruler of MS Word screen? Right indent Center indent Left indent Tab stop box 17) A function inside another function is called a……..function ? Text Sum Nested Round 18) The shortcut key is used to switch between sheets? C.Alt + Pageup A.Ctrl + Pageup D.Both A and B B.Ctrl + Pagedown 19) The secondary storage devices can only store data but they cannot perform ? Logical operation Fetch operation Arithmetic operation All of these 20) Restore command is used to? Restore file which are deleted Restore files from disks made using the BACKUP command Restore files which are deleted recently Restore files from recycle bin 21) Which of the following is not a font style ? Regular Superscript Bold Italics 22) …….enables computer to communicative via telephone line? Motherboard Modern NIC ISP 23) 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 24) Which chart is better represents the progress of stock market on daily basis? Pie chart Line chart Row chart Column chart 25) The formula “=T(value)” is used to check whether a value is……? Number True Tax Text 26) Thesaurus tool in MS Word is used for? Grammar options Spelling suggestions All of these Synonyms and antonyms words 27) Ctrl+J is used for……….? Align Justify Insert hyperlink Search Print 28) EBCDIC stand for? Extended bit code decimal interchange code Extended binary coded decimal interchange code Extended bit case decimal interchange code Extended binary case decimal interchange code 29) The section of the CPU that selects, Interprets and sees to the execution of program instructions? ALU Memory Control unit Register Unit 30) Which of the following in not a type of page margin ? Left Top Center Right 31) In MS PowerPoint, file with readymade styles that can be used for a presentation called ? Wizard Auto style Template Pre formatting 32) The communication mode that supports two-way traffic but only one direction at a time is? Half Duplex Multiplex Simplex Duplex 33) An error is also known as? Icon Bug Debug Cursor 34) Choose the Odd one? Plotter Touch Panel Scanner Mouse 35) What is a portion of a document in which you set different page formatting options than reset of the document ? Section Page Document Page setup 36) A computer program that converts assembly language to machine language is? Interpreter Assembler Comparator Compiler 37) Which of the following line spacing is invalid? Triple Double Single multiple 38) If you need to duplicate the entire disk, which command will you use ? Diskcopy Chkdsk Format Copy 39) Computer cannot do anything without a? Program Memory Chip Output device 40) The result of 3^2-2*4+1 is? 2 35 29 41) How are data organized in a spreadsheet? Lines and spaces Rows and columns Layers and place Height and width 42) The shortcut key for filter in Ms excel? Ctrl + Shift + L Alt+ctrl+L Ctrl + shift + f Alt+ctrl+L 43) Firmware is contained In? SRAM DRAM Cache ROM 44) NOT,AND,OR and XOR are? Arithmetic operation Logical operators Relational operators Binary operator 45) What invention enabled developers to create microcomputer? Transistor Magnetic disk Vacuum tube Intergrated circut 46) The dimension of A4 size paper is? 8.17"/X11.60" 8.27"X11.96" 8.5"X11.69" 8.27"X11.69" 47) When you copy a formula in excel, excel? Does out adjust relative cell references Erase the original copy of the formula Adjusts cell references in the newly copied formula Adjust absolute cell references 48) Before a disk drive an access any sector record, a computer program has to provide the records disk address, what information does this address specify? Sector number All of these Track number Surface number 49) What is the ASCII code for capital “C”? 76 99 43 67 50) ….is the ghosted test behind the content on the page? Watermark Ghostmark Earmark Inkmark 51) What do you call a primary key field included in another table? Parent key Index Foreign key Child 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