500-IMP-ITT-Questions-for-Online-Final-Exam PDF

q_id q_desc op1 op2 op3 op4 ans Input,...

q_id q_desc op1 op2 op3 op4 ans Input, Input, Input, Processing, Input, Processing, Programming, BC1 IPOS stands for ________________. Programming, A Output, Storage Output, Sequencing Output, Output, Storage Sequencing Data that has been made meaningful and useful is called BC2 Process Information Input Output B _____________. BC3 A megabyte equals approximately ___________ bytes. One thousand One million One billion One trillion B _____________ transforms a computer into a terminal, which Word processing Telecommunication BC4 Graphics software Database C can connect to a multiuser computer system. software s software ____________ are the steps that one must follow to BC5 Programs Procedures Policies Guidelines B accomplish a specific computer-related task. In a mainframe computer system, a ____________ processor None of the BC6 Host Front-end Backend C is responsible for handling data retrieval operations. above The ______________ has sometimes been called a BC7 Workstation Microcomputer Mainframe Minicomputer A 'supermicro'. Embedded BC8 Video game players use _________________. Portable computers Smart cards PDAs B computers q_id q_desc op1 op2 op3 op4 ans Second generation computers were programmed using Low-level BC9 Machine language Assembly language High-level language C ________________. language In ALU, _______________ stores the results of arithmetic General-purpose BC10 operations temporarily before they are put out to the Instruction Register Program Counter Accumulator C Registers computer's memory. Accelerate the Store the results of Store the start-up Be used as a hard computer's speed BC11 The main purpose of cache memory is to ______________. D calculations instructions drive while keeping the price low Optical Mark Optical Message Optical Mark Optical Message BC12 OMR stands for ________________. A Recognition Recorder Reader Recognition Dual Independent Disk Independent Drive BC13 DIB stands for __________________. Dual Industry Bus B Bus Bus Independent Bus TurboTax- A tax Graphics BC14 Which of the following is not a General Purpose Program? Desktop Publishing Word Processing preparation C Software package Peripheral Peripheral Public Component Personal Computer BC15 The full form of PCI is _________________. Component Component D Interconnect Interconnection Industry Interconnect Optical mouse uses ___________ to detect the mouse's None of the BC16 Metal ball Optical sensors Laser C movement. above q_id q_desc op1 op2 op3 op4 ans Which of the following is not a characteristic of useful BC17 Relevant Timely Accurate Redundant D information? Picture Multiplier Photo Multiplier Picture Magnifier Photo Magnifier BC18 PMT stands for _______________. B Tube Tube Tube Tube BC19 Hand-held scanners are often called _____________ scanners. Sheet-fed Flatbed Drum Half-page D Which of the following is used in objective tests for entrance BC20 MICR OCR OMR Bar Code Reader C examinations? BC21 Monochrome monitors display _______ color(s). One Two Three Four B Super Video Soft Video Graphics Soft Video Graphics Super Video BC22 The full form of SVGA is ______________. D Graphics Adapter Array Adapter Graphics Array data than can be the vertical how sharply an transmitted in a distance between individual pixel how densely the BC23 Resolution is an indication of _________________. D fixed amount of each pixel on the appears on the pixels are packed time screen screen BC24 Which of the following is a non-impact printer? Daisy-wheel printer Dot-matrix printer Line printer Laser printer D q_id q_desc op1 op2 op3 op4 ans _________is an input device that can read text or illustrations BC25 printed on paper and translate the information into a form Scanner Joystick Keyboard MICR A that the computer can use. Digital Versatile BC26 The full form of DVD is ________________. Digital Video Disc Both A and B Neither A nor B C Disc Which of these is useful in transferring data from one None of the BC27 RAM ROM Hard disk C computer to another? above BC28 ___________ printers produce letter-quality type. Daisy-wheel Dot-matrix Ink-jet Laser A During the Process Management functioning of an Operating OS1 Procedure Process Task Job B System, a __________ is defined as a program in execution. Which of the following is not a function of the operating Process Device Arithmetic Command OS2 C system? Management Management Calculations Interpretation In an Operating system, _______________ is the interval from OS3 the time of submission of a job to the system for processing Throughput Response Time Turnaround Time Completion Time C to the time of completion of the job. Currently able to Currently able to In memory, will In an Operating system, when a process is in the suspended run, but must wait Currently waiting run, but for some OS4 execute in given C state, the process is ______________. until CPU becomes on I/O reason the CPU time available operating system q_id q_desc op1 op2 op3 op4 ans Program Control Process Control Procedure Control None of the OS5 PCB stands for ___________________. B Block Block Block above In an Operating System with threads facility, what is the basic OS6 Process Task Program Thread D unit of CPU utilization? In Operating System, ___________ refers to the ability of a Multiprogrammin OS7 Multitasking Multiprocessing Multithreading B computer system to support more than one processor. g Good computing Which of the following is not achieved using a time-sharing Reduction in CPU Quicker response OS8 Data Redundancy facility to small A operating system? idle time time users Which file operation Is used to position the read/write pointer None of the OS9 Position Seek Set Attributes B to a specific place in the file? above Error in a nuclear Which of the following situation requires real-time Error in study None of the OS10 reactor thermal Car breakdown A processing? material above power plant Which of the following is the Sun Microsystem's version of OS11 HP-UX Linux Solaris Windows C UNIX? Which one of the following is the most recent version of OS12 Windows 95 Windows 7 Windows 98 Windows Vista B Windows operating system by Microsoft? q_id q_desc op1 op2 op3 op4 ans In Windows 7, the feature ___________ automatically OS13 maximizes a window when it is dragged to the top of the Aero Peek Aero Snap Quick Launch Virtual Hard Disk B screen. OS14 Windows 7 is available in ____ editions. Five Six Seven Eight B Graphical User Gaming User Graphical User Generic Usage OS15 GUI stands for _____________________. A Interface Interface Intelligence Index A _________ is a list from which we can give an instruction by OS16 Icon Dialog Box Window Menu D clicking a command. The ___________ is the place where Windows temporarily OS17 Start Menu Recycle Bin Notification Area Trash B stores the deleted files. Using the feature of _____________ in Windows 7, we can OS18 Calculator Math Input Panel Sticky Notes Snipping Tool D capture images of screen areas. In Windows 7, _____________ feature enables the user to log User Account None of the OS19 on and operate the computer with a more secure standard Control Panel Credential Manager A Control above user account. An operating A file is a collection Multitasking is a File management system is an of related method with is not done by OS20 Which of the following statement is false? D interface between information multiple tasks Operating hardware and user. defined by its processes sharing System. q_id q_desc op1 op2 op3 op4 ans Which of the following is not a shut-down option available in OS21 Log off Lock Sleep Hibernate D Windows 7? Run Time Real Time Real Time None of the OS22 RTOS stands for _________. B Operating System Operating System Operational Source above In Windows 7 Taskbar shortcut menu, which of the following command displays the windows on top of each other, with the Show windows Show windows side OS23 Cascade windows Show the desktop C title bar of each window visible and the contents of only the stacked by side top window visible? Dynamic Link Diagrammatically None of the OS24 What is the full form of DLL? Drastic Link Library B Library Linked Library above Which of the following is not a valid execution state in the OS25 Executing Waiting Charged Blocked C lifespan of a process? To improve the performance of a computer system, it is OS26 Throughput Turnaround Time Response Time Completion Time A desirable to maximize __________. In Operating System, which of the following is not contained OS27 Process Identifier Process State Program File Name Program Counter C in a Process Control Block? In Operating System, threads in multithreading refer to Different parts of a Different users' OS28 Different programs Different processes A ______________. single process processes q_id q_desc op1 op2 op3 op4 ans In case of ___________ operating system, the user views the OS29 Distributed Centralized Network Real-time A system as a 'Virtual Uniprocessor'. The version of DOS shipped with IBM's PCs was called None of the OS30 MS-DOS PC-DOS IBM-DOS B _________. above Which of the following is not a feature of Windows 7 Media Communication Windows OS31 Games D operating system? Management tools Calendar Region Desktop Remote Desktop Remote Data Real-time OS32 What is the full form of RDP in windows 7? B Protocol Protocol Protocol Desktop Protocol A/An ______________ is a collection of updates, fixes and/or OS33 enhancements to a software program delivered in the form of Microsoft update Update Pack Service Pack Service Patch C a single installable package. In MS Word 2010, which of the following is not a view Thumbnail Page WO1 Headings View Search Results View Snapshot view D provided by the Navigation Pane? View In MS Word 2010, _______ is a large area just below the ruler None of the WO2 Ruler Text Area Title Bar B where the desired content can be inserted. above In MS Word 2010, ________ displays the title of the WO3 Title Bar Text Area Ruler Header A document on which we are currently working. q_id q_desc op1 op2 op3 op4 ans Which of the following is a "Protect Document" option Encrypt with WO4 Mark as Final Restrict Editing All of the above D available in MS Word 2010? Password In MS Word 2010, which of the following is not a type of the WO5 Error Warning Threat Tip C issues detected by the "Accessibility Checker"? In MS Word 2010, an Accessibility ________ is given for WO6 content that in most, but not all, cases makes a file difficult for Error Warning Threat Tip B people with disabilities to understand. In MS Word 2010, a ____________ is a preset document WO7 layout with a collection of styles which are saved to a file and Template Screenshot Style Agenda A can be applied to other documents. In MS Word 2010, which of the following option is not WO8 Tables Illustrations Home Symbols C available in the Insert Toolbar? In MS Word 2010, _____ option automatically resizes the Autofit to WO9 table to fit in a Web browser window when we change the Autofit to window Fixed column width Fixed row width A contents window size. In MS Word 2010 Tables, the option ________ deletes the Delete entire WO10 Delete entire row Shift cells left Shift cells right B entire column of the table where we clicked in. column In MS Word 2010, which of the following is not an option in WO11 Picture Chart Screenshot Font D the Illustrations group of the Insert Ribbon? q_id q_desc op1 op2 op3 op4 ans In MS Word 2010, ________ is the ratio between picture None of the WO12 width and picture height which can be maintained even when Resolution Aspect Ratio Pixel width B above resizing a picture. In MS Word 2010, a _________ identifies a location or a WO13 selection of text that we name and identify for future Template Threat Bookmark Screenshot C reference. Which of the following is a group under the Mailings Ribbon WO14 Create Start Mail Merge Finish All of the above D of MS Word 2010? In MS Word 2010, the option of _____ lets the user to flip, WO15 rotate, move or resize all shapes or objects at the same time Cropping Grouping Editing Ungrouping B as though they were a single shape or object. In MS Word 2010, ______ helps in selecting individual objects None of the WO16 Selection Pane Navigation Pane Screenshot A to change the order and visibility of objects in the document. above In MS Word 2010, a ______ is a series of commands that we None of the WO17 can use to automate a repeated task, and can be run Symbol Macro Equation B above whenever we have to perform the task. In MS Word 2010, which of the following is a group under WO18 Themes Page Setup Page Background All of the above D Page Layout tab? Count the number Count the words as Count the number None of the WO19 In MS Word 2010, which of the following is an invalid option? of words in a text D we type of pages above box q_id q_desc op1 op2 op3 op4 ans In MS Word 2010, which of the following is not an option Insert Table of WO20 Update Table Cross-Reference Formula Bar D under Captions group in References Ribbon? Figures In MS Word 2010, which of the following sequence of steps Insert -> Symbols -> Page Layout -> Size - View -> Page Layout Data -> Sort -> WO21 A need to be followed to write an equation? Equation > Equation -> Size -> Equation Equation In MS Word 2010, ______ is a gallery where we can create, WO22 store, and find reusable pieces of content, including AutoText, Themes Macro Quick Parts WordArt C document properties and fields as displayed. In MS Word 2010, when we open a document, it may be in Word 2007 Word 97-2003 WO23 Word 2010 All of the above D any of the following modes. Compatibility Mode Compatibility Mode Reversible Text Return Text WO24 In MS Word 2010, the extension "rtf" stands for ___________. Rich Text Format Return Text File B Format Figure In MS Word 2010, _____ allows the user to copy multiple text WO25 and graphical items from Office documents or other programs Clipboard Format Painter Macro Navigation Pane A and paste them into another Office document. In MS Word 2010, the option ______ makes the selected text WO26 Outline Emboss Engrave Subscript B appear to be raised off the page in relief. In MS Word 2010 Table, the shortcut key to move to the last WO27 Alt + End Shift + Tab Alt + PgDn Alt + PgUp C cell in column is __________. q_id q_desc op1 op2 op3 op4 ans In MS Word 2010, a _____ is a list of sources, usually placed at WO28 the end of a document that we consulted or cited in creating Bookmark Bibliography WordArt SmartArt B the document. In MS Word 2010, ____ lists the references in a legal Table of WO29 document, along with the numbers of the pages the Bookmark Bibliography WordArt D Authorities references appear on. In MS Word 2010, _____ view displays the final document Original Showing Final Showing WO30 Final Original C with all tracked changes and comments showing. Markup Markup In MS Word 2010, which of the following option is invalid WO31 Accept Reject Next First D under Changes group in Review Ribbon? In MS Word 2010, which of the following option is present in Show Source WO32 the Compare drop-down menu under Compare group in Compare Combine All of the above D Documents Review Ribbon? In MS Word 2010, ____ effect makes the selected text appear WO33 Outline Emboss Engrave Subscript C to be imprinted or pressed into the page. In MS Word 2010, under which tab the option Start Mail WO34 Page Layout View Mailings Home C Merge is available? In MS Word 2010, which of the following option is not WO35 Hyperlink Bookmark Cross-reference SmartArt D available in the Links group on the Insert Ribbon? q_id q_desc op1 op2 op3 op4 ans Which of the following is not a valid Document View in MS WO36 Web Layout Live Preview Outline Draft B Word 2010? ____ is a fixed layout electronic file format that preserves WO37 document formatting and enables file sharing in MS Word UDS XLS DOC PDF D 2010. In MS Word 2010, which option is not available under the Spelling & WO38 Research Word Count Mark Citation D Proofing Group on the Review Ribbon? Grammar In MS Word 2010, _______ option in Text group under Insert None of the WO39 Date & Time Signature Line Object A Ribbon inserts the date and time in the Word document. above In MS Word 2010, the shortcut key that is used to insert a None of the WO40 Ctrl + K Ctrl + H Ctrl + M A hyperlink is ________. above Highlight the Highlight the Highlight the Highlight the In MS Word 2010, to remove the Drop Cap from a paragraph paragraph that paragraph that paragraph that paragraph that WO41 B that contains the Drop Cap, follow these steps. contains the Drop contains the Drop contains the Drop contains the Drop Cap, Click Text -> Cap, Click Insert -> Cap, Click Insert -> Cap, Click Margins define the A ruler spans on Themes have a amount of white None of the WO42 In MS Word 2010, which of the following statements is false? top of the Word palette of 12 D space that appears above document. colors. at the top, bottom, In MS Word 2010, a ______ is a translucent image that None of the WO43 Bookmark Watermark Bibliography B appears behind the primary text in a document. above q_id q_desc op1 op2 op3 op4 ans In MS Word 2010, the ______ option under Arrange group on WO44 the Page Layout Ribbon lets the text flow around the image Square Through Tight Behind Text C and hugs its shape. The TextArea is an The horizontal The TextArea is a area where the scrollbars are used None of the WO45 In MS Word 2010, which of the following statement is true? large area just B desired text can be to move up and above above the ruler. inserted. down the An embedded AutoText is a The Headings A macro once object can be reusable content view under WO46 In MS Word 2010, which of the following statements is false? created can never C created in a Word that we can store Navigation Pane be deleted. document. and access again provides a Macro name must Macro name must Macro name must WO47 In MS Word 2010, which of the following statement is true? not contain any not contain any All of the above D begin with a letter. space. unusual characters. The ____ feature of MS Word 2010 is used to create a set of WO48 documents, such as forms, envelopes, letters etc. to be sent Macros Format Painter Spell Checker Mail Merge D to many customers. In MS Word 2010, ____ is the keyboard shortcut key to open WO49 Ctrl + O Ctrl + S Ctrl + V Ctrl + Alt + A A an existing document. In MS Word 2010, the shortcut key to use Format Painter is WO50 Ctrl + Alt + C Ctrl + Tab + C Ctrl + Shift + C Ctrl + Alt + A C ______. In MS Word 2010, the shortcut key to go to the File tab is None of the WO51 Ctrl + F Alt + F Shift + F B ______. above q_id q_desc op1 op2 op3 op4 ans Suppose we have a Word document containing four pages Print them with and we are printing five copies of it. Now we want them in the Print them Print them with WO52 Print them collated Landscape A page 1-4 order for each of the five sets. What is to be done in uncollated Portrait orientation orientation the following situation? WO53 The 'x' in the docx file extension stands for _____. XPS XHTML XML XCESS C In MS-Word 2010, a _________ is a combination of characters WO54 that is written as a glyph, which is written as though it is a Ligature Font Style Template A single character. In MS-Word 2010, which of the following option is available WO55 Bullets Indentation Sort All of the above D under Paragraph group of Home tab? Add-Ins registered Add-Ins present on Add-Ins In MS-Word 2010, under various Add-In Categories option, Template files and currently our computer but automatically WO56 the "Document Related Add-Ins" are the referred to by open B running in our not currently disabled because ____________________________. documents Office program loaded it causes Office In MS-Word 2010, the ___________ macro runs when Word None of the WO57 AutoOpen AutoExec AutoNew B Is opened. above Which of the following is the shortcut key to select an entire WO58 Ctrl + S Ctrl + C Ctrl + A Ctrl + M C MS-Word 2010 document? In MS-Word 2010, which SmartArt graphic should be used to WO59 Process Hierarchy Pyramid Any of the above B create an Organization Chart? q_id q_desc op1 op2 op3 op4 ans In MS-Word 2010 document, the red wavy underline indicates None of the WO60 Spelling errors Grammar errors Address Block A ______________. above The task of changing the appearance of a Word 2010 WO61 Editing Proofing Inserting Formatting D document is referred to as __________. In MS-Word 2010, the insertion point in a table can be moved WO62 Tab Shift + Tab Arrow All of the above D using ______________ key(s). In MS-Word 2010 document, which key deletes a character to WO63 End Delete Home Backspace B the right of the cursor? _____________ commands are used to move selected text WO64 Move and Paste Copy and Paste Cut and Paste Delete and Paste C from one place to another in a MS-Word 2010 document. By default, on which page of a Word 2010 document, the On alternate WO65 On first page On last page On every page C header or the footer is printed? page A set of form A set of Which of the following can be achieved using Mail Merge in A set of Labels or Different sets of WO66 letters, email numbered B MS-Word 2010? Envelopes templates messages, or fax coupons In MS-Word 2010, which simplifies the process of formatting None of the WO67 text if the same formatting is required in more than one Auto Text Format Painter Font dialog box B above location? q_id q_desc op1 op2 op3 op4 ans Word is the Excel is the The worksheet is The document is Which is true when we insert an Excel worksheet into a Word WO68 destination destination the destination the source A document? document document document document In MS Word 2010, an __________ lists the terms and topics WO69 that are discussed in a document, along with the pages that Hyphen Bibliography Bookmark Index D they appear on. None of the WO70 In MS-Word, AutoText and AutoCorrect are _________ tools. Styling Editing Designing B above Visual Basic for Visual Basic for Visual Basic None of the EX1 VBA stands for ______________________. A Applications Abacus Appliances above EX2 The Excel 2010 worksheet contains _______ columns. 10,000 26,284 16, 000 16,384 D EX3 Formulas in Excel 2010 usually begin with _____. = + - % A A cell in a different A cell in another A cell reference in a MS Excel 2010 spreadsheet can refer to A value from a EX4 sheet within the spreadsheet All of the above D _________________. remote application same spreadsheet entirely q_id q_desc op1 op2 op3 op4 ans Object Linking and Object Loading and Object Linking and Outward Linking EX6 Full form of OLE is __________________. A Embedding Embedding Exchange Exchange Keyboard shortcut to show a shortcut menu in MS Excel 2010 EX7 Shift + F10 Shift + F1 Shift + F11 Shift + F12 A is _______________. Keyboard key in Excel 2010 to close the visible menu, or, with EX8 Home Alt End Esc D a submenu visible, close the submenu only, is _________. Web pages that are Stored URLs that Links that connect None of the IN24 Internet bookmarks are _________________. hosted on one or A can be retrieved to other web pages above more web servers ___________ web sites are used to preserve valuable IN25 Blog Archive Affiliate Flash B electronic content threatened with extinction. Uniform Resource Universal Resource Ubiquitous Useful Resource IN26 URL stands for ________________________. A Locator Locator Resource Locator Locator Web crawling, Web crawling, Indexing, Web Indexing, Searching, IN27 A search engine operates in the following order: Indexing, D Searching, Indexing crawling, Searching Web crawling Searching Opens the Displays Starts to search for The Starter button in the File/Edit toolbar of Navigator Gold Prints the current IN28 document in the information about text in the current B 2.0 ____________. document browser window web creation document q_id q_desc op1 op2 op3 op4 ans Forms support in JavaScript Drag and drop Editor window does IN29 Which of the following is not a limitation of Navigator Gold? editor window is capabilities are capability is not D not display tables. not stable. limited. supported. In Internet, ______ refers to a specification by which IN30 AJAX CGI CSS HTML B programs can communicate with a Web server. A device that connects the computer to the Internet is Network None of the IN31 Browser Modem B __________. Neighbourhood above Sending unwanted e-mails in bulk is known as None of the IN32 Pornography Spamming Virus threat B _____________. above _________ is a program or a tool that helps in locating a file None of the IN33 Archie Veronica Jughead A anywhere on the Net. above ________ is a network protocol used to transfer data from IN34 Telnet SMTP FTP IRC C one computer to another through a network. ________ is a small tool to extract links/files from one or IN35 multiple website or directory listings and save them to a Webcow ScanDL LeechGet LeechGet2001 A specified directory. In the Internet address http://mail.icai.org, the domain name IN36 http mail icai org C is __________. q_id q_desc op1 op2 op3 op4 ans ________ is a document containing words that connect to IN37 Hyperlink HyperText Webpage Website B other documents. ______ server presents its contents as a hierarchically None of the IN38 POP IMAP Gopher C structured list of files. above ICMP and ARP protocols work in ____ layer of OSI reference IN39 Physical Data Link Network Transport C model. Faster and more Information None of the IN40 Which of the following is not an advantage of Internet? reliable E-Commerce D availability above communication Value Addition Valid Addition Value Added None of the IN41 VAN stands for ______________. C Network Network Network above In EDI, a/an _________contains one or more documents for IN42 Internal Format File Transmission File External Format File EDI document B the same trading partner. In EDI, ____ is a standard protocol for securing credit card IN43 NET CAT https SET D transactions over insecure networks, specifically, the Internet. ______ involves the electronic movement of funds and fund IN44 ATM EFT Credit Cards EDI B information between financial institutions. q_id q_desc op1 op2 op3 op4 ans Broadcast and Web based and Active and Online advertising can be categorised in two types, these are Internal and IN45 billboard portal based Passive D ______________. external advertising advertising advertising advertising None of the EX9 Excel 2010 gives a ____ extension to the template file..xlsx.xltx.dotx B above EX10 In Excel 2010, use _____ to move up to the row above. Tab Shift + Tab Enter Shift + Enter D Which function is used in Excel 2010 to enter current date EX11 Date CurrentDate Today Workday C under the tab Date & Time? To delete selected rows in Excel 2010, click the arrow next to None of the EX12 Delete in Cells group in Home Tab, and then click Delete Delete Rows Delete Sheet Rows C above ______________. To copy data to a different sheet in Excel, press EX13 ______________ while dragging the selection to the sheet's Ctrl + Enter Shift + Tab Ctrl + Alt + N Ctrl + Alt D tab. EX14 Keyboard shortcut to save a workbook in Excel 2010 is _____. F10 F11 F12 F13 C References to cells in other workbooks of MS Excel 2010 are Relative Cell EX15 Links Hyperlinks Connections A called __________. References q_id q_desc op1 op2 op3 op4 ans To fix the formula in a cell so that absolute cell reference is EX16 F1 F2 F3 F4 D used, _____ key is used in Excel 2010. In Excel 2010, when E$5 is copied across, the __________ EX17 Row Column Either A or B Both A and B B reference can change. In Excel 2010, a range is defined by the addresses of two EX18 Colon Semicolon Comma Dot A opposite corner cells separated by a _________. EX19 Which of these is a valid range name in Excel 2010? A12 A$12 ___A.B 1a C Use the Define Use the Name Box Name command Create a name from EX20 How to name a range in Excel 2010? All of the above D in the Formula Bar from the Formulas a row or column Ribbon While creating range names from a row or column, if the label EX21 for a column or row contains spaces, Excel replaces the space Hyphen Caret Underscore Asterisk C with a/an ___________. EX22 Which operator is used for exponentiation in Excel 2010? Asterisk Caret Forward slash Backslash B In Excel 2010, ___________ are structured programs that EX23 Functions Formulas Ranges Equations A calculate a specific result. q_id q_desc op1 op2 op3 op4 ans ______ category of functions in Excel 2010 searches for and Lookup and EX24 Logical Information Engineering D returns values from a range. reference EX25 In Excel 2010, FACT(2.9) returns __________. 2 4 6 Error #NUM! A Logarithm of a Natural logarithm Base-10 logarithm Base-2 logarithm EX26 In Excel 2010, LOG function returns the ________. number to a B of a number of a number of a number specified base EX27 In Excel 2010, MOD(-5, -3) returns _______. 2 -2 -3 -4 B EX28 In Excel 2010, MROUND(1.3, 0.2) returns _______. 1.4 1.2 1.3 1.5 A In Excel 2010, __________ returns the average of the EX29 AVEDEV VARA COVAR STDEV A absolute deviations of data points from their mean. In Excel 2010, _________ error message is given if the formula EX30 #NAME? #Value ##### #REF! D contains a reference to a non-existent cell. The process of examining a MS Excel 2010 worksheet for EX31 Checking Auditing Inspecting Assessing B errors in formulas is referred to as ____________. q_id q_desc op1 op2 op3 op4 ans In Excel 2010, _________ error message is given if the formula EX32 #NAME? #REF! ##### #DIV/0! A contains text that Excel doesn't recognize. To manually calculate all the formulas in a worksheet of MS- EX33 F6 F7 F8 F9 D Excel 2010, press _______. To have column and row headings visible while scrolling the EX34 worksheet of MS Excel 2010, _______________ feature is Splitting Panes Freeze Panes Radar Panes Format B used. Keyboard shortcut to open Format Cells dialog box in Excel EX35 Ctrl + F Ctrl + 1 Ctrl + Alt Ctrl + 0 B 2010, is _______________. To define a table in MS-Excel 2010, select a cell in the data set EX36 Ctrl + T Ctrl + L Either A or B Neither A nor B C and press ___________. The contents of the The contents of the The contents of the The row is In Excel 2010, if a row is selected and Delete key is pressed, row are cleared but row are cleared as row are cleared as removed and the EX37 C ____________________________. the emptied row well as the row is well as the row is contents are remains in place removed but the removed and the moved in the By default, MS-Excel 2010 aligns text to the ________ of the EX38 Left Center Right Justified mode A cell. While wrapping text in Excel 2010, the number of wrapped The width of the The length of the EX39 Both A and B Nothing C lines is dependent on ___________________. column cell contents q_id q_desc op1 op2 op3 op4 ans If cells A2, A3, B2 and B3 in a worksheet of MS Excel 2010 are EX40 A2 A3 B2 B3 A merged, the cell reference for the merged cell is _______. A _____________ chart in Excel, shows the relationship of 100% Stacked EX41 individual items to the whole, comparing the contribution of Clustered Column Stacked Column 3-D Column B Column each value to a total across categories. In MS-Excel 2010, a 3-D column chart uses three axes - a EX42 Depth Length Breadth Width A horizontal axis, a vertical axis, and a ________ axis. Volume-open-high-low-close subtype of stock charts in Excel EX43 3 4 5 6 D 2010, requires _____ columns of data. In Excel 2010, a ____ is useful when user wants to find EX44 Surface Chart Area Chart Doughnut Chart Bubble Chart A optimum combinations between two sets of data. In Excel 2010, a 3-D surface chart without color is called a None of the EX45 Wired Contour Wireframe C ___________ 3-D surface chart. above In Excel 2010, if user wants to create a hyperlink to a specific EX46 location in the file or on the Web page, click _________ in the Current Folder Recent Files Bookmark Browse the Web C Insert Hyperlink dialog box. Whether the When a record is deleted using a data form in Excel 2010, It doesn't get It gets deleted but It gets deleted and deletion is EX47 C ________________________. deleted it can be restored cannot be restored permanent or temporary is q_id q_desc op1 op2 op3 op4 ans In Excel 2010, user can add a _____ to the table, which is a EX48 special row in a list that provides a selection of aggregate Table row Total row Aggregate row List row B functions useful for working with numerical data. In Excel 2010, the user can sort up to _____ levels using the EX49 1 2 3 4 C Sort dialog box. In Excel 2010, the default criteria setting for AutoFilter in each EX50 Top10 Bottom10 Top half All D field is __________. Subtotal option is in __________ group of Data tab in Excel EX51 Sort & Filter Outline Data Tools Calculation B 2010. External data source for an Excel 2010 workbook can be EX52 A text file A database An OLAP cube All of the above D _________________. Which of the following cannot store connection information EX53 Workbook.odc file.htm file.udcx file C of an external data source in Excel 2010? Ubiquitous Data Universal Data Universal Data User Digital EX54 UDC stands for _______________________. B Connection Connection Continuity Connection EX55 The default pivot chart type in Excel 2010 is a ________ chart. Column Line Scatter Bubble A q_id q_desc op1 op2 op3 op4 ans Macros option is in Code group of ____________ Ribbon in EX56 Insert Data Home Developer D Excel 2010. EX57 _________ is not a type of sparkline in MS-Excel 2010. Line Row Column Win/Loss B In a PivotTable report in Excel 2010, nonnumeric fields are EX58 added to the ________________ area of the layout section, Row Labels Column Labels Values Report Filter A by default. __________ are easy-to-use filtering components that enable EX59 the user to quickly filter the data in a PivotTable report in MS- Sparklines Slicers Macros Data Forms B Excel 2010. In Excel 2010, ___________ function is used to create EX60 DIRECT DEPENDENT INDIRECT LOOKUP C validation based on dependent drop-down lists. None of the EX61 In Excel 2010, range C3:C6 indicates _______________. Cells C3 through C6 Cell C3 and Cell C6 Cell C4 and Cell C5 A above EX62 The first cell in an Excel 2010 worksheet is labeled as ____. AA A1 A0 1A B In Excel 2010, which function is used to return the remainder EX63 ROUND FACT MOD DIV C after a number is divided by a divisor? q_id q_desc op1 op2 op3 op4 ans Spreadsheet Communication Word processing EX64 Microsoft Excel 2010 is a powerful ____________. DBMS package A package software package package In Excel 2010, which of the following is Text Concatenation EX65 " ! # & D operator? To select multiple non-adjacent cells in an Excel 2010 EX66 Ctrl Alt Shift Ctrl + Shift A worksheet, click them holding _________ key. If we want to sort an employee file so that they would be Zip codes Last name Zip codes Last name listed alphabetically by last name and first name within (ascending), then (ascending), then (descending), then (descending), EX67 A individual zip codes (smallest to largest), which of the last name first name last name then first name following would be the correct sorting order? (ascending), then (ascending), then (ascending), then (descending), A quick way to return to a specific area of a worksheet in Excel EX68 2010 is to type the cell address or range name in the Name Box Formula Bar Zoom Box Sheet Tab A ____________. Name of the Name of the Name of the cell or Formula in the In MS-Excel 2010, the Name Box shows the worksheet EX69 workbook currently range currently cell currently C ________________________. currently working working on working on working on on We want to set such that when we type Baishakh and drag the Fill Across EX70 fill handle, Excel should produce Jeshtha, Aashadh and so on. Custom List AutoFill Options Fill Series A Worksheet What should we set to effect that? In Excel 2010, what is represented by the small black square in EX71 Copy handle Fill handle Insert handle Border B the lower-right corner of an active cell or range? q_id q_desc op1 op2 op3 op4 ans If we want all of the white cats grouped together in an Excel Pet Type, then Pet Type, then Color, then Pet EX72 2010 worksheet of all the animals, we need to sort by Color, then Gender B Color Gender Name _________. Suppose we accidentally erased a record in an Excel EX73 worksheet. Which command can be used to restore it Insert Replace Paste Undo D immediately? Which of the following is a valid cell address in MS Excel EX74 96g 79 64 AB A5 D 2010? Insert a chart Which of these is the best way to show the monthly rainfall in Insert a photograph Insert a database EX75 Insert a calendar showing rainfall C an Excel 2010 report? of rainfall of rainfall amounts Suppose you are editing a MS Excel 2010 worksheet that you had previously saved. If you want to save the edited sheet EX76 New Save As Edit Save B without losing the original one, which command should you use? In order to arrange the names of the students from those with the highest marks to those with the lowest in an Excel EX77 Ascending Descending Alphabetical Random B worksheet, we need to sort on the marks field in _____________ order. In order to perform a calculation in an Excel 2010 worksheet, EX78 Table PivotTable Formula Chart C we need to use a ___________. Which of the following functions would give the sum of the SUM(A1:A4 ^ EX79 SUM(A1:A4, A3:A5) SUM(A1:A4 A3:A5) SUM(A1:A4 : A3:A5) B contents of cells A3 and A4 in MS-Excel 2010 worksheet? A3:A5) q_id q_desc op1 op2 op3 op4 ans In MS-Excel 2010, which of the following operator has the EX80 Range Union Negation Exponentiation A highest precedence? In MS-Excel 2010, the option to disable the printing of EX81 gridlines along with the text is available on ___________ tab Page Margins Header/Footer Sheet D of Page Setup dialog box. Which of the following is not a category of functions in MS- EX82 Financial Engineering Agricultural Information C Excel 2010? A ________ is a set of colors, fonts, and special effects that PP1 provides attractive backgrounds for the PowerPoint 2010 Theme Style Template Effect A slides. In MS-PowerPoint 2010, which tab provides the facility to add PP2 Home Insert Animations Transitions B a video and audio to the presentation? Using ________ tab of Chart Tools in MS-PowerPoint 2010, None of the PP3 Design Layout Format A we can control the chart type, layout, styles, and locations. above Microsoft Which technology provides the facility to share and edit a SharePoint Microsoft Office PP4 SharePoint Server All of the above D PowerPoint presentation by multiple users? Foundation 2010 Live Workspace 2010 In MS-PowerPoint 2010, the ___________ option prints None of the PP5 images that contain variations of gray tones between black Graystyle Colorscale Grayscale C above and white. q_id q_desc op1 op2 op3 op4 ans The shortcut key to start the slide show of a PowerPoint 2010 PP6 F2 F3 F4 F5 D presentation is _____. Any transitions in Audio is not Any animations in Video played in Which change is not observed in PowerPoint features when a the presentation transmitted to the the presentation the presentation PP7 C PowerPoint 2010 slide show is broadcasted online? are shown as Fade audience through are shown as Fade is not shown to transitions in the the browser animations the audience. A slide effect used The way one slide PP8 What is a slide transition in MS-PowerPoint 2010? Overheads Letters to introduce a slide C looks in a slide show How can we exit the slide show of a MS Powerpoint 2010 By pressing down By pressing left By pressing Tab PP9 By pressing Esc key C presentation? arrow key arrow key key _____________ is a template used to create consistent PP10 Notes Master Slide Master Handout Master Clip Art B layouts throughout the MS PowerPoint 2010 presentation. In MS PowerPoint 2010, __________ tool can be used to None of the PP11 Screen Clipping Screen Cropping Clip Art A select part of a window while taking a screenshot. above In MS-PowerPoint 2010, which playback option should be Loop until PP12 Automatically Play across slides On Click D used to play an audio clip continuously? Stopped The animation effect _______ determines how an object PP13 Entrance