MSCIT Question Bank (As per revised curriculum)

QID ch1 ch1 QUESTION A “computer competent” person must know how to upgrade and repair their computer A computer monitor is a video display device ANSWER option2 option1 TRUE TRUE OPTION1 OPTION2 FALSE FALSE is the term used to describe a communications system connecting two or more computers together FALSE FALSE FALSE FALSE FALSE FALSE FALSE hard disk FALSE FALSE the number of children born in Chicago in 1950 mean of your credit the percentage of card balances for the brown-eyed peop past three years in your class optical disk DVD is the conection describes the relationship between among computer users, often seen at a data element and a conferences database record OPTION3 OPTION4 ch1 A computer network option2 describes the information channels within a system unit ch1 ch1 ch1 ch1 ch1 ch1 ch1 ch1 ch1 ch1

A computer network allows two or more computers to communicate A computer network supports connectivity A document file is one of the most common types of file A keyboard is one of the common output devices A monitor and printer are the most common input devices for personal computers A mouse is one of the common input devices A PDA is a small, portable computer A storage device that consists of rigid metallic platters, that are used to store programs and very large data files A typical word processor is an example of application software A word processor is an example of a browser application An example of data is option1 option1 option1 option2 option2 option1 option1 option2 option1 option2 TRUE TRUE TRUE TRUE TRUE TRUE TRUE floppy disk TRUE TRUE the average rainfall in Texas for 1995 ch1 option2 ch1 ch1 ch1 ch1 ch1 ch1 ch1 ch1 ch1

An operating system like Windows NT is an example of application software Another name for software is Another name for the keyboard, mouse, monitor and system unit is Application software is used to directly control computer hardware Communication hardware allows two or more computers to share data Computers are used in most areas of business today Connectivity is a term used to describe communication among computers Data is processed into information Database, spreadsheet and document are the most common types of computer files option2 option3 option3 option2 option1 option1 option1 option1 option1 TRUE procedures firmware TRUE TRUE TRUE TRUE TRUE TRUE FALSE data software FALSE FALSE FALSE FALSE FALSE FALSE programs hardware information solidware ch1 ch1 ch1

Device that translates data and programs that humans can understand into a form option1 that the computer can process Device that translates the processed information from the computer into a option2 form that humans can understand Device used to convert electronic signals from the computer into electronic signals option2 that can travel over a telephone line Devices that allow information to be sent option3 from one computer to another are called Floppy disks and hard disks are both examples of secondary storage Floppy disks are secondary storage, hard disks are primary storage Floppy disks, optical disks, DVDs and hard drives are all examples of Guidelines for using a computer or documentation for using a particular software package are called option1 option2 option3 option1 input device utput device microprocessor hard drive input device output device microprocessor hard drive translator modem converter communications hardware memory transference comware ch1 ch1 ch1 ch1 ch1 advanced I/O input/output hardware peripheral firmware TRUE TRUE removable media procedures FALSE FALSE primary storage or secondary storage memory software data CPUs personal digital assistance ch1 In business, the most commonly used computer is a mainframe option2 TRUE FALSE In large corporations with big data processing budgets simulcast ch1 ch1 ch1 ch1 ch1 ch1 ch1 In which areas of today’s business world would you expect to find option1 microcomputers?

Information and data are the same thing Integrating video, voice, music and even graphics in a presentation is called It is still rare to find computers in use in most small businesses Many college students buy a mainframe computer to help them with their studies Memory is an example of primary storage Microcomputers are divided into two general categories One major difference between primary and secondary storage is One of the most widely used browsers is Part of the input hardware for most of computers is a GUI People who use computers to play games or solve business are called “end users” primary storage is permanent Privacy and security are important issues for computer professionals Procedures and software mean the same thing Software is another name for programs Software is another name for the facts and/or figures that are used as input to an infomation system Software used to interact between user programs and the computer is called option2 option2 option2 option2 option1 option3 Only in areas that In areas that In nearly all areas of require extensive emand exact business and all areas of mathematical answes or word life processing processing TRUE FALSE combination packages TRUE TRUE TRUE high speed and low speed primary storage is temporary, secondary storage is permanent Microsoft Office TRUE TRUE TRUE TRUE TRUE TRUE TRUE application software multimedia FALSE FALSE FALSE graphical and nongraphical secondary storage is magnetic, primary storage is optical Microsoft’s Internet Explorer FALSE FALSE FALSE FALSE FALSE FALSE FALSE system software operation software portable and desktop mega-multi-media ch1 option1 math based and text based primary storage is secondary storage is removable, faster than primary secondary storage is storage built in Windows Explorer Navigation ch1 ch1 ch1 ch1 ch1 ch1 ch1 ch1 ch1 option2 option2 option1 option2 option1 option2 option1 option2 option2 custom ma software ch1 ch1 ch1 ch1 ch1 ch1 ch1 ch1 ch1 ch1 Supercomputers, the largest computers, are used for scientific research The “end users” of a computer system are the peole who write the rograms than tell the computer how to process the data The average daily temperature of Bismark, North Dakota is an example of information The capacity of a DVD is greater than a CD The challenge of the future is to make the new technology fit the people who use it The challenge of the future of technology is to make the technology more powerful The computer monitor is software that watches waht is happening inside the CPU The Internet is part of all computer operating systems The Internet is the largest computer network in the world The Internet is thought to be one of the most important technologies in the 21st century option1 TRUE FALSE option2 TRUE FALSE option1 option1 option1 TRUE TRUE TRUE FALSE FALSE FALSE option2 TRUE FALSE option2 option2 option1 option1

TRUE TRUE TRUE TRUE FALSE FALSE FALSE FALSE a communications one of the parts of a device within network designed to Pentium computers prevent system that speeds data crashes access online services Netscape Navigator mainframe computers ch1 The Internet is option2 a collection of the largest computers within one communication company used for network in the communication and data world exchange WWW browser ch1 ch1 The internet service that provides a multimedia, user-friendly interface to numerous resources available on the Internet The largest computers used mainly for research, are called option1 option3 megacomputers maxicomputers supercomputers ch1 ch1

The microprocessor and memory are the option1 two parts of the system unit The most common input hardware for personal computers are The most common output hardware for personal computers are The most important part of an Infomation System is the data The most important part of an information system is the The most important system software is the The most widely used type of computer is the The mouse and the keyboard are the two parts of the system unit The name for the kind of software that performs tasks like word processing or database management is The newer DVD has less capacity than the older CD The number of students in your computer class today is data The program used to navigate, explore, and find information on the internet is called a The raw material used to create information is called The smallest personal computer is the notebook The term “data” is used to refer to option1 TRUE FALSE a graphical user a printer and a interface(GUI) and a monitor mouse a graphical user a printer and a interface(GUI) and a monitor mouse keyboard and a a mouse and keyboard screen a mouse and keyboard TRUE people application software supercomputer TRUE DOS TRUE TRUE search tool metaware TRUE unprocessed facts and figures a keyboard and a screen FALSE hardware automation software mainframe FALSE system software FALSE FALSE netware process hardware FALSE the output of a computer ch1 ch1 ch1 ch1 ch1 ch1 ch1 ch1 ch1 ch1 ch1 ch1 option4 option2 option1 option4 option4 option2 option3 option2 option1 option3 option3 option2 software microprocessor minicomputer data operating system microcomputer application software operation software browser data netter manuals/procedures ch1 option1 facts that have been the process of processed into a comput more usable form ch1 The term “end user” is used to describe people who option3 use the output from computers (the end product) unprocessed facts and figures Procedure se microcomputers are the last to use a write software for to perform computer or the computers information information from a processing tasks computer the input to a computer Software facts that have been the process of processed into a computation more usable form Data Hardware ch1 The term “information” is frequently used to refer to The term “program” is another name for which part of the information system? The term “supercomputer” is used to describe a desktop system that has stateof-the-art speakers, CD-ROM, graphics monitor, and a very fast processor The term used to describe tying computers together so data can be sent among them is The two main parts of the system unit are option3 ch1 option2 ch1 option2 TRUE FALSE ch1 ch1 ch1 option4 option2 inter-processor access a mouse and keyboard the Internet and the World Wide Web TRUE database TRUE I/O interconnectedness commware connectivity he microprocessor a printer and a and memory monitor DVD and multimedia FALSE worksheet FALSE document The two most important technologies for option1 the 21st century are thought to be The type of computer that falls between personal computers and mainframe computers is the minicomputer The type of file created by an electronic spreadsheet like Excel The World Wide Web is not an important technology To be considered “computer competent” a individual only needs to know enough about the computer to be able to satisfy their information needs option1 option2 option2 primary storage and secondary storage integration of sub-notebooks and computers into larger hard drives people ch1 ch1 ch1 presentation ch1 option1 TRUE

FALSE have an extensive know how to both knowledge of use and repair the available hardware computer system and software they use application operation softw software ch1 To be considered “computer competent” option2 a person needs to Type of software that can be described as option3 “end-user” software be an expert in most of be able to use a the software available computer when for their computer they begin their job system DOS system software ch1 ch1 When a computer is turned off, information in primary storage is lost When talking to a computer literate person, the term “monitor” is used to describe Which of the following is not an advanced application?

Which of the following would not be considered portable computer? Windows 2000 is an example of a(n) option1 TRUE system software that watches what happens inside the CPU artificial intelligence a desktop computer operating system TRUE FALSE an output device an output device that monitors also called a video environmental display screen conditions web publishers a notebook computer graphical user interface FALSE application software data and information word processor a personal digital assistant application software a special chip used to check for illegal software multimedia a handheld computer basic tools ch1 option2 ch1 ch1 ch1 ch1 option3 option1 option1 ch1 ch1 ch1 ch1 ch1 ch1 ch1 ch1 ch1

Windows 2000 is an example of system option1 software Word processing, electronic spreadsheets, database managers, and option2 graphics programs are all grouped under the title You are in sales and would like a computer that you could take with you on sales calls and would enable you to option2 quickly write down notes with a pen. What type of computer would you purchase? You have just collected the class’s ages and then calculated the average age of the option3 class. The average would be considered You have just collected the class’s ages. Each individual’s age would be option1 considered An assembler is compiler. option1 Analytical engine was conceptualized by option1 Charles Babbage.

Apart from Abacus, Napier’s bones were option1 the first device used in computations. Both FORTRAN and COBOL were option2 developed in 1964. Computer language named C is an option2 interpreter language. operating systems browsing programs notebook PDA desktop Portable data the output stream information calculation data TRUE TRUE TRUE TRUE TRUE the input stream FALSE FALSE FALSE FALSE FALSE information statistics ch1 ch1 ch1 ch1 ch1 ch1 ch1 ch1 ch1 ch1 ch1 ch1 ch1 ch1 ch1 ch1 ch1 ch1 Difference engine was designed by option1 Charles Babbage. Farrenti Mark I was the first computer option1 developed for sale. First difference engine was actually built option1 by George Scheutz.

Hollerith first used his tabulating machines for US Census of 1890. Hollerith was the first to come up with option2 stored program concept. How many main types of computer are OPTION4 there according to size ? Interpreter programs run as fast as option2 compiled programs. Machine language programs consists of a option1 long sequence of binary numbers. Mercury filled tubes were the first form option1 of memory. Pentium family computers fall under OPTION4 ___________ computers Personal computers of present days are faster than the supercomputers developed option1 in early 1970’s. Prolog language is basically designed for option1 artificial intelligence programming.

Punch cards were used for data and option1 program input in early computers. Slide rule was used for engineering option1 calculations till about 1970. The analytical engine was the first option2 electronic digital computer. The first generation computers used option2 transistors. The Tabulating Machine Company formed by Hollerith eventually became option1 IBM. UNIVAC was the earliest computer in option2 IBM mainframe computer series. TRUE TRUE TRUE TRUE TRUE 1 TRUE TRUE TRUE Mini TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE FALSE FALSE FALSE FALSE FALSE 2 FALSE FALSE FALSE Main frame FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE Super Micro 3 4 ch1

What is the physical part of the computer OPTION2 called ? What is the meaning of ‘Alphanumeric’? OPTION3 What is the name of first Indian super computer Software Hardware CPU Operating System ch1 Only Letters Only Numbers A combination of A combination of Letters, Numbers Letters and Numbers and Special characters PARAM Special Power Control Requirement Less expensive DHARAM All of the above All of the above ch1 ch1 ch1 ch1 ch1 ch1 ch1 ch1 ch1 ch1 ch1 ch1 ch1 ch1 ch1 OPTION3 KARAM Bulky Small in size TRUE Desk top computer Mini computer Desktop Input Device CPU Mini-computer Pentium Floppy Disk Main Frames Laptop Cyber NARAM More Data Processing Power Slower FALSE

What is the salient feature of main frame OPTION4 computer What is the salient feature of Mini OPTION4 computer Wheelword was the name of the first computer developed for simultaneous use option1 by many users. Which computer need fluorocarbon fluid OPTION3 in flooring Which computer needs special flooring OPTION2 for installation ? Which computer requires environment OPTION4 control ? Which of the following components is OPTION2 used to store data? Which of the following is a data OPTION1 processing unit? Which of the following is called a OPTION3 Personal Computer? Which of the following is Desktop OPTION4 computer Which of the following is not a storage OPTION3 device? Which of the following is not a type of OPTION4 computer? Which of the following is not Desktop OPTION4 computer ? Which of the following is not Super OPTION2 computer ?

Personal Computer Super computer Super computer Mini Memory RAM Super-computer 486 computer Magnetic Tape Mini Computer Notebook Pentium Micro computer Micro Output Device Hard Disk Micro-computer Laptop Keyboard Micro Computer Pentium Cray Main frame Main frame Mainframe Central Processing Unit Floppy Mainframe computer All of the above Hard Disk Laser PARAM PARAM ch1 ch1 ch1 ch1 ch1 ch2 ch2 ch2 ch2 Which of the following is the main OPTION4 component micro computer Which of the following is the smallest OPTION3 size of computer? Which of the following tasks is not OPTION3 performed by minicomputer Which of these is known as Desktop OPTION2 computer William Shokley developed first junction option1 transistor in 1951. ____ in a cell consists are used to identify information in a worksheet.

They option1 usually consist of words or symbols ______ allows you to share information or page objects between files created in option1 different applications ________ software is used to create textoption1 based documents __________ are used to create slide shows on the computer option1 Use of micro processor Small in size Mainframes Multitasking Super TRUE labels Super Computers More data processing Power Micro Computers All of the above Mini Computers Multiprogramming Environment control Time sharing Micro FALSE values descriptors formulas Mini Mainframe OLE word processing Presentation graphics hypertext spreadsheet Analytical development programs menu toolbar browser formula dynamic link connectivity package. FALSE replace database Super slide packages box Office Assistant Office Assistant function database operating system package. insert word writer Slidemaker tools ch2 ch2 ch2 ch2 ch2 ch2 ch2

A ______ is rectangular area that can contain a document, program, or message option1 A __________ contains icon buttons that access frequently used commands A __________ provides access to features of the program A built-in tool that performs calculations automatically is a(an) A collection of related data that has been entered into a computer is called a A collection of separate software applications that are sold as a group, like Microsoft Office, is called a(n) A database sort directs the software to find and display one or more records option2 option1 option3 option3 option4 option2 window menu bar menu bar value function software series. TRUE toolbox feature presentation feature presentation dynamic file link spreadsheet software suite ch2

A DBMS is a A list of associated commands that can be pulled down into the main screen is called a(n) A menu is the tool most people use to fix errors in text-based documents A microcomputer can be considered an electronic tool in today’s business world A number, stored in a cell is called a(n) A prewritten formula that performs an automatic calculation is called a formula A prewritten formula that performs an automatic calculation is called a function A set of icons that represent the various commands available is called a(n) A software suite is a collection of separate applications bundled together and sold as a group A software suite is a set of instructions and practice exercises to help a new user learn about a software package A template is a professionally designed model of a presentation A template is another name for a single slide in a slide show A value stored in a cell in a spreadsheet is called a formula An instruction or calculation stored in a cell is called a(n) An instruction stored in a cell in a spreadsheet is called a formula An instruction stored in a cell in a spreadsheet is called a value An integrated software package is a collection of separate applications bundled together and sold as a group option1 double based database management dynamic based database marketing mathematical system management series system software insertion point TRUE TRUE value TRUE TRUE menu TRUE vertical bar or arrow FALSE FALSE intersection FALSE FALSE toolbar FALSE task list GUI label cell technical application tool. menu ch2 ch2 ch2 ch2 ch2 ch2 ch2 ch2 ption4 option2 option1 option1 option2 option1 option2 option1 ch2 ch2 ch2 ch2 ch2 ch2 ch2 ch2 option1 option1 option2 option2 option2 option1 option2 option2 TRUE TRUE TRUE TRUE value TRUE TRUE TRUE FALSE FALSE FALSE FALSE formula FALSE FALSE FALSE label subtotal ch2 ch2 ch2 ch2 ch2 ch2 ch2 ch2 ch2 ch2 ch2 ch2 ch2 ch2 Analysis in a spreadsheet was designed to answer “How Much? “. Analysis in a spreadsheet was designed to answer “What If? ” option2 option1 TRUE TRUE cut and paste TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE FALSE FALSE undo errors FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE dynamically link files recalculate values

Analysis is the ability of spreadsheets to option4 Animation refers to a presentation that contains special visual and sound effects Another name for systems software packages is application software Application software are programs that perform “useful” work or tasks, such as typing and calculating Application software is another name for the basic software tools used in business Applications software controls the computer’s resources Cartooning refers to a presentation that contains animation Computing, formatting, and recalculating are examples of word processing operations Data presented in picture form is difficult for most people to understand DBMS stands for database management system DBMS stands for dynamic based management system Finding a specified word and replacing it with another is an example of copy and paste For most people Data presented as pictures are easier to understand than the same data presented as numbers From the help window, the _________ option is used search for help on a particular word or phrase option1 option2 option1 option1 option2 option2 option2 option2 option1 option2 option2 ch2 option1 TRUE FALSE ch2 option3 contents index find table ch2 ch2 h2 ch2 ch2 ch2 ch2 ch2 ch2 ch2 ch2 ch2 ch2 ch2 ch2 ch2 From the help window, the _________ option is used to locate a specific topic from an alphabetical list of Help icons Hypertext links can be created to crossreference information within the current document and between documents If you were trying to figure out how to use a feature of your spreadsheet program, what tool would you choose? In a relational database each table is made up of columns called fields In a relational database each table is made up of columns called records In a relational database each table is made up of rows called fields In a relational database each table is made up of rows alled records In a relational database, data is organized in related _______ In a relational database, data is organized into tables In a relational database, each table is made up of rows called _______ and columns called _____ In a word processor, automatically moving the insertion point to a new line when the text approaches the right margin is called In today’s business world, a microcomputer is considered an Labels are often used to identify information in a worksheet Letters, memos, term papers, and reports are all examples of documents Letters, memos, term papers, and reports are all examples of menu processes Letters, memos, term papers, reports, and contracts are all examples of option2 contents index find table option1 TRUE FALSE option1 option1 option2 option2 option1 option2 option1 option4 Help TRUE TRUE TRUE TRUE fields TRUE fields, records Learn FALSE FALSE FALSE FALSE tables FALSE tables, objects About Why relations records relations, subtables records, fields option2 margin holding word wrap computer program. FALSE FALSE FALSE models sentence salvage line length control option1 option1 option1 option2 option4 electronic tool. TRUE TRUE TRUE menus specialist’s tool application. word processors documents ch2 ch2 ch2 ch2 ch2 ch2 ch2 ch2 ch2 ch2 ch2 ch2 ch2 ch2

Menus can be created to cross-reference information within the current document and between documents Object linking and embedding is a feature that allows you to share information or page objects between files created in different applications One feature of a spreadsheet is the ability to rapidly recalculate values One of the important features of a spreadsheet is the ability to dynamically link files Only specialists commonly use microcomputers in business today Presentations that include special visual and sound effects are called Professionally designed model presentations are called Related data, stored together in a computer, is called a database Related data, stored together in a computer, is called a file management system Scrollbars allow you to move horizontally and vertically around the document Spelling and grammar checkers are commonly found as part of a database package Spelling and grammar checkers are commonly found as part of a word processor Spreadsheet programs allow a type of analysis called Spreadsheets, word processors, graphics programs, database software, and browser programs are applications option2 TRUE FALSE option1 TRUE FALSE option1 option2 option2 option4 option3 option1 option2 TRUE TRUE TRUE cartoons animations TRUE TRUE FALSE FALSE FALSE templates slide shows FALSE FALSE layouts templates animations copy runs option1 TRUE FALSE option2 TRUE FALSE option1 option4 option1 TRUE how much TRUE FALSE why not FALSE how many what-if ch2 ch2 ch2 ch2 ch2 ch2 ch2 ch2 ch2 ch2 ch2 ch2 ch2

Spreadsheets, word processors, graphics programs, database software, and browser programs are called power tools SQL is a language used to address commands to a database SQL is software used to address commands to a word processor SQL is used to allow communication with SQL stands for spreadsheet question language Templates are a feature that allows you to share information or page objects between files created in different applications The ______ contains buttons that are used as shortcuts commands that enhance the appearance of your documents The ______ contains buttons that are used as shortcuts to the most frequently used menu commands The ________ database is the most widely used database structure The bars along the side and sometimes the bottom of the screen that allow the user to see more of a large document are called The feature that can create crossreferenced information within a document is called a(n) __________ The feature that offers suggestions and options is called the __________ The formatting toolbar contains buttons that are used as shortcuts to commands that enhance the appearance of your documents option2 option1 option2 option2 option2

TRUE TRUE TRUE graphical programs. TRUE FALSE FALSE FALSE databases FALSE word processors. spreadsheets option2 TRUE FALSE option2 standard toolbar formatting toolbar menu toolbar options toolbar option1 option3 standard toolbar table formatting toolbar menu toolbar standard relational options toolbar general option2 zoom tools scroll bars arrow lines movement vectors option3 option4 interlink menu master integration point short cut hypertext link help inclusion Office Assistant option1 TRUE FALSE a hardware indicator a vertical bar or arrow ch2 The insertion point is often indicated by option3 a menu key an electronic menu ch2 ch2 ch2 ch2 ch2 ch2 ch2 ch2 ch2 ch2

The relational database is the most widely used database structure The spreadsheet is the most widely used database structure The standard toolbar contains buttons that are used as shortcuts to commands that enhance the appearance of your documents The standard toolbar contains buttons that are used as shortcuts to the most frequently used menu commands The term “integrated software package” and the term “software suite” mean the same thing The term “integrated software package” refers to a set of basic tools that can share data among themselves The term “integrated software package” refers to different versions of the same software like Word 4. 1, 4. 2, and 4. The term for the operation of finding a particular word and substituting another for it is Toolbars allow you to move horizontally and vertically around the document Values are often used to identify information in a worksheet option1 option2 TRUE TRUE FALSE FALSE option2 TRUE FALSE option1 TRUE FALSE option2 TRUE FALSE option1 TRUE FALSE option2 TRUE FALSE option3 option2 option2 hunt and peck TRUE TRUE pass and carry FALSE FALSE search and replace copy and paste ch2 What is a software suite? option4 All the business A set of different A single program software made by a versions of the same that provides the single vendor, like software package, like functionality of all the Microsoft Word 4. 0, 5. 0, and 6. 0. several programs. software. A collection of separate applications bundled together and sold as a group. ch2

What is an integrated package? option2 A set of software All the business like a financial A set of different A single program software made by a service and a versions of the same that provides the single vendor, like resource sharing software package, like functionality of all the Microsoft bulletin board Word 4. 0, 5. 0, and 6. 0. several programs. software. offered by a single vendor. ch2 ch2 ch2 ch2 ch2 ch2 ch2 ch2 ch2 ch2 ch2 ch2 ch2 Which of the following is not a popular option4 software suite? Which type of graphics is used to option1 communicate or persuade? With object ____, the object from the source file is added in the destination option1 document.

The files are not linked With object _____, a copy of the object from the source file is sent to the option4 destination file along with a link or tie back to the source file Word processors, database programs, spreadsheets, graphics packages, and option3 browsers are collectively called You are creating a presentation and need to have data from a spreadsheet incorporated in the presentation. The option1 presentation must be structured so that any changes made in the spreadsheet are also reflected in the presentation. What feature would you use? ____________ mark indicates the OPTION3 grammatical mistake in the document. A footnote can appear at any location in option2 the page. A spreadsheet programs enables creation of ocuments as efficiently as a word option2 processor. Adjustment of spacing between words in lines of a paragraph, so that all the lines appear aligned exactly one below another option1 to the right side of a paragraph also, is called justification. Alphabets having higher thickness are option2 called italics alphabets. Alphabets leaning on right side at their option2 top portion are called bold alphabets. Autocad is an excellent software made option1 for drawing engineering drawings. Microsoft Office presentation embedded Corel WordPerfect Lotus SmartSuite Suite drawing copying analytical pasting Netscape Navigator interactive linking embedded copying pasting linking specialized tools ominal tools. general-purpose applications. exceptional applications object linking object embedding object pasting object copying Green Line TRUE TRUE Red Line FALSE FALSE Green Wave Red Wave TRUE FALSE TRUE TRUE TRUE FALSE FALSE FALSE ch2 ch2 ch2 ch2 ch2 ch2 ch2 ch2 ch2 ch2 ch2 ch2 ch2 Both pie charts and bar charts show parts option2 as a fraction of whole. Breaking of a long word at the end of a line so that a part of word appears in one option1 line and the remaining part appears in the next line is called hyphenation. By default left margin is set as OPTION3 ____________ Clip board saves maximum OPTION3 __________________ objects at a time.

Ctrl+(down arrow) is used to move IOPTION2 beam __________ Draw programs built into a word processor are as good as the specially option2 made drawing programs. Even if the length of the last line of the paragraph is very short compared to the length available for the line in “forced option1 justification” the spacing between words is adjusted in such a way that last line is also aligned to the right side. File organization is the arrangement of option2 records within a particular file. First line indent means the blank space option1 kept at the beginning of a new paragraph. For computerized operations in a small bank data security is more important than option1 graphical user interface.

For text matter in Roman script ( used for English language ) the standard line option1 height is usually set to 1. 2 times the height of tallest letter in the typeface. Graphs produced from a database can option2 only be bar chart type. Header or Footer appear on each page of the document unless they are set to option1 appear otherwise. TRUE FALSE TRUE FALSE 0. 5 inch 8 one line below TRUE 1 inch 10 one paragraph below FALSE 1. 25 inch 12 one screen below 1. 5 inch 14 to the end of the file TRUE FALSE TRUE TRUE TRUE FALSE FALSE FALSE TRUE FALSE TRUE TRUE FALSE FALSE ch2 How can we add a Hyperlink to a Word OPTION2 Document? Select “Tools”; Select “Customize”; Select “Hyperlink”; ch2 How can we change the font of the text in OPTION3 a Word Document?

Select “Format”; Select “Insert”; Select “Edit”; Select Select “Insert Select “Hyperlink” “Hyperlink” hyperlink” Select the text; Select the text; Select the text; Select Select “View”; Select “Insert”; Select “Format”; “Tools”; Select “Font”; Select “Font”; Select Select “Font”; Select “Font”; Select Select the desired font; the desired font; Select the desired the desired font; Click “OK” Click “OK” font; Click “OK” Click “OK” Select “Data”; select “Find Word” Type the word in the formula bar. Select “Edit”; select Use the spell check “Find” type the word option in “View”. Press Ctrl + D Select “View”; Select “Date and Time” Select “Tools”; Select “Page Break” ch2 How can we find a particular word, in a OPTION3 MS-Excel Worksheet ? How can we insert the current date or time in a Word document? OPTION2 ch2 Select “Tools”; Select Select “Insert”; “Options”; Select “Date Select “Date and time” and time” ch2 How can we insert a page break in a MSOPTION2 Word document? Press Alt + Enter ch2

How can we view two parts of a Word document simultaneously? OPTION4 Select “View”; Select “Split Window”; Insert –> Header ch2 ch2 ch2 ch2 Identify the correct steps to insert Header OPTION3 & Footer in your document given below ? In a spreadsheet program if one has to move from cell A1 to CA4096 then the fastest way to do so is by using page option2 down key and then using mouse for horizontal scrolling. In Find and Replace dialog box, the match case check box is not selected. A OPTION4 search for word YCMOU finds___________ In justification even the last line of the paragraph is also justified even if it is option2 very short in length compared to the available length of the line.

Select “File”; Select Select “Insert”; “Page Setup”; Click Select “Break”; on “Layout” tab; Click on Page break Click on the Page option; break option; Select “Tools”; Select “Options”; Press Ctrl + W Select “Split Window” Insert –> Header & View –> Header & Footer Footer Select “Window”; Select “Split” Insert –> View –> Header & Footer TRUE FALSE YCMOU ycmou Ycmou All of above TRUE FALSE ch2 In most of the word processors the text option1 flows to next page when it fills one page. TRUE FALSE Select a cell where On “Drawing” you want a textbox; toolbar; double click rightclick on it; on textbox button select “Insert”; select “Textbox”. Select the entire Select “Format”; sheet; Right click increase the font on it; select “Closesize. Up”. characters. Spelling mistake. Select “Format”; Select “Ruler”. 5 characters. An underlined Word. None of the above. ch2 In MS- Excel, to insert a textbox into the OPTION1 worksheet : Click on the Textbox; on the “Drawing” toolbar, move your Select “Insert”; mouse pointer to the select “Textbox”. desired area in the worksheet. Click and drag to draw the textbox Select” View”; select “Full Screen”. 16 characters. Grammatical mistake. Select “Tools”; Select “Ruler”. Select ” View”; select “Zoom”. 256 characters. A highlighted Word. Select “View”; Select “Ruler”. ch2 In MS -Excel, to magnify or reduce the display of a worksheet : OPTION2 ch2 ch2 ch2

In MS Word, a document filename can OPTION2 have up to: In MS Word, a Word underlined with a OPTION3 wavy red line indicates: In MS Word, if the ruler is not displayed, OPTION2 to have it displayed you must: In MS Word, the backspace key: OPTION4 ch2 Deletes the character to Deletes a Word. the right of the cursor. Upper right corner of the Word window. Deletes the character Deletes the character where the cursor is to the left of the positioned. cursor. ch2 In MS Word, the minimize/maximize button is present on the: In MS Word, to change a sentence into Italics : OPTION1 Lower right corner Upper left corner of Lower left corner of of the Word the Word window. the Word window. window. Select the sentence; press alphabet ‘I’ on the keyboard. Select the word; right click on it and select “Change Case” ch2 OPTION1 ch2 In MS Word, to change the case of the word : OPTION3

Select the sentence; Select the sentence; Select the sentence; click on the button ‘I’ on click “Format” and right click on it and the “Formatting” select “Italics”. select “Italics”. toolbar. Select the word; Select the word; select Select the word; select “Format”, “Insert”, click on select “Tools”, click click on “Change “Change Case”. on “Change Case”. Case”. ch2 In MS Word, to change the font : OPTION2 ch2 In MS Word, to insert a Clipart or image :OPTION1 ch2 In MS Word, to make a sentence Bold : OPTION2 ch2 In MS Word, to set auto correct on is: OPTION2 ch2 In MS Word, to underline a word : OPTION2 ch2 In MS-Excel, “#NAME? ” occurs in a cell OPTION3 when :

Select the text and Select the text and select the font from click on “Format” Select the text; click the “Font” Drop menu and select “Tools”; click on Down menu on the “Style Gallery” and “Font”. “Formatting” select the font. toolbar. Select “Insert”; select Select “Insert”; Select “View” Select “Insert”; “Picture” ; select select “Object”; ;select “Picture” ; select “Files”; select “Clipart” and select the select “Clipart” and select “Clipart” and “Picture” and select image and click on select the image select the image and the image and click “OK”. and click on “OK”. click on “OK”. on “OK”. Select the sentence, Select the sentence; Select the button Select the sentence, Select the sentence, select “Edit” and select ‘B’ on the right click on it and press alphabet ‘B’ “Formatting” select “Bold”. n the keyboard. “Bold”. toolbar. Select “Tools”; Right click; click on Select “Format”; Select “Insert”; select select “Auto “Auto correct”. select select “Auto “Auto text”; select correct”. select the the “Replace text as correct”. select the “Auto correct”; select “Replace text as “Replace text as you you type” check the “Replace text as you you type” check type” check box. box. type” check box. box. Select the sentence; Select the word; Select the word; select click on the button Select the word; ‘U’ on the right click on it and press alphabet ‘U’ “Insert” and select select “Underline”. on the keyboard. “Underline”. “Formatting” toolbar. The formula. ontains A # sign is typed instead a formula contains A number/formula is numbers and text of equal to(=) sign in the a number that is too large to fit in a (I. e. MS- Excel does formula divided by 0 (zero). cell not recognize the text in a formula. ) Select the text and click on the button showing ‘F’ on the “Formatting” toolbar. Workpages The cell contains number/formula is not correct Worksheets Booksheets Blankpages ch2 In MS-Excel, a Workbook is made up or OPTION2 one or more : In MS-Excel, a cell shows the ###### sign when : OPTION2 ch2 The cell contains a The cell contains a The cell contains number, date, or number that has a characters instead of time that is wider negative value numbers. han the cell width ch2 In MS-Excel, by default, pressing the enter key moves a cell pointer from: OPTION4 Left to Right. Select cells; select “Format”; select “Merge” Bottom to Top. Right to Left. Top to Bottom. ch2 In MS-Excel, for merging two cells : OPTION2 Select the cells; on “Formatting” Select the cells; Select the cells; toolbar select select “Edit”; select Right click on it; “Merge and centre” “Merge” select “Merge” button (icon). Three One Four ch2 In MS-Excel, ‘Goal Seek’ tool allows you to adjust find a specific result by OPTION3 changing the value/values in ___________ cell/cells: In MS-Excel, how can we add a comment OPTION1 to a cell ?

In MS-Excel, how can we find a specific result for a cell by adjusting the value of OPTION3 only one other cell ? In MS-Excel, how can we give $ sign (currency symbol) for a number which is OPTION1 in a cell : In MS-Excel, how can we make the format of cell B5 similar to the format of OPTION1 the cell E3 ? Two Select the cells; Select “Insert”; select “Comment” ch2 ch2 ch2 ch2 ch2 In MS-Excel, how can we right align the OPTION2 text in a cell : ch2 In MS-Excel, how can we wrap the text in a cell ? OPTION2 Select “Insert”; Select the cells; Select the cells; Select “View”; Select “Edit”; select Select “Comment in a cell”. select “Comment” “Comment”.

Select “Insert”; Select “Tools”; Select “Tools”; select Select “Tools”; select “Seek “Solver” select “Auditing” Select “Goal Seek” Answer” Select the cell, on Select “View”; Select “Data”; select Select “Insert”; “Formatting” toolbar select “Currency”; “Formula”; select select “Currency”; select “$” button select “American” “$” select “American” Select E3; click on Select E3 and B5; Select E3 and B5; Select E3; right click “Copy” and “Format Painter” button click on “Format select “Format”; select “Same then select B5 right painter” on on Standard toolbar; Format” click “Paste” click on B5 Standard toolbar Select cell; select Select the cell; select “Align Right” Select the cell; select Select the cell; Right “Format”; select “Align button (icon) from “Edit”; select”Align click, select “Align Right” the “Formatting” Right” Right” in the cell toolbar Select cell; select “Format cells”; Select cell; select Select cell; select Select cell; increase the select “Wrap” on “Edit”; select height of the row “Alignment”; select formatting toolbar “Wrap” “wrap text” Select “Edit”, Select “Clear”. Select “Edit”, Select “Clear”, click All. Select “Edit”, Select None of These. “Clear Table” ch2

In MS-Excel, how can you clear an entire data table, including all formulas, input OPTION2 values, resulting values, formats, and comments. ch2 In MS-Excel, how can you hide the columns? OPTION3 Select the columns Select the columns that that you want to you want to hide; Select hide; Select “Window”; Select “View”; Select “Hide”; “Hide Column” Right click on the cell; Select the cell; select “View”. press # key. Select the columns that you want to hide; Select All of above “Format”; Select “Column”; Select “Hide”; Double click the Select “View”; select right boundary of “Actual Contents”. the column heading. Select the entire worksheet; right click on it; select “More Space”.

Select “View”; select “Full Screen”. ch2 In MS-Excel, How can you view the actual contents of the cell, if you see #### error in a cell ? OPTION3 ch2 In MS-Excel, how will you hide window elements to show more data on the OPTION4 screen? In MS-Excel, if Cell C5 contains 500, C6 contains 200 and C7 contains 300 what formula will you give to calculate the sum : In MS-Excel, pressing the “Tab” key moves a cell pointer from: In MS-Excel, the Formula given in a cell begins with : In MS-Excel, the short cut key to display the Office Assistant or Help is In MS-Excel, the workbook created has the default extension of Select “View”; select ” Double click on Zoom”. the worksheet . h2 OPTION1 =SUM(C5:C7) =SUM(C5 to C7) =SUM(C5&C6&C7)=ADD(C5,C6,C7) ch2 ch2 ch2 ch2 OPTION2 OPTION3 OPTION1 OPTION1 Top to Bottom. , (Comma) Press F1 key . xls file extension. Type “Header” in the first cell of the Worksheet and “Footer”in the last cell of the Worksheet. Select “Tools”; select “Add Toolbar” Left to Right. : (Colon) Press Ctrl+F1 . bmp file extension. Bottom to Top. = (Equal to ) Press Alt + F1 Right to Left. ‘(Apostrophe) Press F2 key . prj file extension. . exe file extension. Select ” View”; select “Header and Footer”. Specify a header or footer that you want. Select “View”; select “Toolbars”; select the necessary toolbar ch2

In MS-Excel, to add a header and a footer OPTION4 to the worksheet : ch2 In MS-Excel, to add a particular toolbar OPTION4 in the worksheet : Select the Click the “Header Worksheet; Right and Footer” icon click on it; click on on the “Drawing” “Header and toolbar. Footer”. Select “Insert”; Right click on select “Toolbars”; worksheet; select select the necessary “Insert toolbar” toolbar ch2 In MS-Excel, to change the font of the text in a cell : OPTION3 Select a cell; select “Format”; select “Change Font”. Select a cell; on the “Formating” toolbar Select a cell; right click on the drop click on it; select down list of the “Font” . “Font” button ; and select the font that you want.

On menu bar; select “Format”; Select “Font”; select the font that you want. ch2 In MS-Excel, to change the text in cell to OPTION1 Bold : ch2 In MS-Excel, to change the width of a particular column : OPTION2 Select cell; on Select cell; select Select cell; select “Formatting” toolbar “Edit”; select “Format”; select select button marked as “Bold” “Bold” ‘B’ Drag the boundary on the right side of Select any cell in Select “View”; the column heading select “Column column; right click on it; until the column is select “Change Width” Width” of the required width.. Select cell; select “Bold” on the “Standard” toolbar Select “Edit”; select “Width” ch2

In MS-Excel, to Check the Spelling of the OPTION2 entire Worksheet : Select Worksheet; Click the “Spelling” Select Worksheet; Select “Format”; Right click on it; select button (icon) on select “Data”; select select “AutoCheck”. “Spell-check”. standard toolbar. “Spell- Check”. Select chart; copy Select chart; copy it; it; select other chart Select chart; right click on it; select select other chart; select ; select “Edit”; “Move Format” “Paste” select “Paste Special” Select both the charts; select “Edit”; select “Copy Formats” ch2 In MS-Excel, to copy a charts formats to OPTION2 another chart : ch2 In MS-Excel, to copy the formula from one cell into a range of adjacent cells : OPTION1

Select cell with formula; Select cell with Select cell with drag the “Fill handle” Select “Edit”; select formula; drag it over formula; drag it over the range you want “Move Formula” the range you want when the arrow sign to copy to fill the Formula comes On “Formatting” toolbar: select Select “Edit”; select “Decrease “Decrease Decimal” Decimal” button (icon) Select the whole Select “Format”, select worksheet; press “sheet”, select “remove” delete Select “Data”; select Select “Format”; “Decimal”; select select “Decrease “Decrease Decimal” Decimal” Select “Edit”; select Select “Data”; select “Delete Sheet” “Delete Worksheet” ch2 In MS-Excel, to decrease decimal places :OPTION2 ch2 In MS-Excel, to delete a worksheet from OPTION3 the workbook: ch2 In MS-Excel, to give a manual page break : OPTION2 ch2 In MS-Excel, to insert a pie chart in a Worksheet : OPTION2 ch2 In MS-Excel, to insert a series of months starting from January and ending with OPTION2 December : ch2 In MS-Excel, to insert a series of numbers starting from 1 and ending with OPTION1 100 : ch2

In MS-Excel, to insert a series of week days starting from Monday and ending with Friday : OPTION1 ch2 In MS-Excel, to Keep row and column titles (labels) visible as you scroll : OPTION1 ch2 In MS-Excel, to make a same entry in a range of cells: OPTION3 Select “Insert”; Select “Format”; Select “Data”; select select “Page select “Page”; select “Page Break” Break”. “Break”. Select the data; Select “Chart Wizard” button Select the data; Select the whole Select the data; right (icon) on select “View”; click sheet; select “Insert”; “Standard” toolbar; click on it; select on “Pie Chart”; click on “Pie “Format Cells” click on Click on the select the required Chart”;select the Pie Option “Standard type” tab, chart. required chart. elect “Pie” option from the “chart type” Type ‘January’ in Type ‘January’ in Type “Calender” in any any cell; drag the any cell; click on Select “Insert”; cell; press Ctrl + Enter Fill handle till text and drag till select “Calender” ‘December’ appears ‘December’ appears Type 1 in a cell; Type 1 in a cell; select select the cell; drag cell; drag the “Fill the “Fill handle” Type “=(1:100)” in a Type “=(1 to 100) in handle” while pressing a cell while pressing ALT cell CTRL button till 100 button till 100 appears appears Type ‘Monday’ in Type ‘Monday’ word in Type any cell; drag the fill Type “=Monday + any cell; click on “=(Monday:Friday)” text and drag till handle till ‘Friday’ Friday” in any cell in a cell ‘Friday’ appears appears Click the cell below and Click the cell below to the right of the row or and to the right of Select the sheet; On Standard toolbar; column lables the row or column right click on it; select “Unscroll (titles);. Select lables (titles);Select select “Visible” Titles” “Windows”; select ” Windows”; select “Freeze Panes” “Split” Select cells in which Select the cells in Select the cells; you want to type which you want to Select cells; type data type data and click same entry; type type same entry; and double click on “Redo Button” data and Press Ctrl + type data and press on the toolbar Enter Enter Select “Edit”; select “Page Break”. ch2 In MS-Excel, to move the worksheet in the same workbook : OPTION4 Select “File”; select “Move”