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