Test 4 consists of 40 questions drawn from the following Mercer County Community College Computer Concepts Test 4 Covers Chapters 4 and 5 for IST101 IST102 and IST103 all sections 1 OpenOffice includes all of the following components EXCEPT A Writer B Calc C Impress D Access 2 The default file format for saving a document in Writer is A htm B odt C doc D wrt 3 Which of the following is a free image editing program A Adobe Photoshop B GIMP C NVU D Eudora 4 Which statement about Eudora is FALSE A Eudora can filter e mail messages B A calendar is included with Eudora e mail C Eudora is a free e mail alternative to Microsoft Outlook D Eudora does not contain all the components included with Outlook 5 Which of the following OS X programs is similar to the Task Manager and is used to analyze the performance of a Mac A System Preferences B Activity Monitor C Control Panel D Sidebar 6 Which of the following is the automated backup utility in Mac OS Leopard A Time Capsule B Spotlight C Time Machine D Dashboard 7 A Web query is A an Excel tool that allows you to search the Web from within a spreadsheet B an Excel tool that allows you to import Web data and chart information into a spreadsheet C an Excel tool that allows you to import the Google query tool into a spreadsheet D an Excel tool that interacts with the query language of Microsoft Access 8 Web queries are useful because A Web data is entered manually B Web data is updated easily C Web analysis tools can be used to analyze the Excel data D They only require that you know HTML 9 Which of the following statements about Web queries is FALSE A You can use sample Web queries included with Excel B Web queries can be exported C You must manually refresh the data each time a spreadsheet is opened D Web queries can be imported MCCC Computer Concepts Test Study Guide 1 10 Which of the following statements about Web queries is FALSE A A query can be imported into a workbook B You can import data directly from a Web page using a browser C Web queries can be set to automatically refresh periodically D Web queries can only be saved in XHTML format 11 When importing Web query data from a Web page data that can be imported is indicated with a n A dashed border B red border C plus sign D arrow 12 When importing Web query data from a Web page data that has been selected for import is indicated with a n A check box B arrow C blinking border D plus sign 13 If a Web site contains too much data to highlight you can create a Web query using A copy and paste B the file import Web data tool C the Export feature D Select All 14 Excel Web queries have been available since A Excel 97 B Excel 2002 C Excel XP D Excel MX 15 Imported data in a Web query can be refreshed A only when the workbook is opened B only at specific time intervals C only when the workbook is closed D when the workbook is opened or at specific time intervals 16 To create a Web query A you must have knowledge of Web page design B you should be a programmer C you need to create an Excel macro D you need no knowledge of Web page design or programming 17 Software that runs the computer and coordinates instructions is called A application software B system software C device software D utility software 18 Software you use to create a budget is called A spreadsheet software B graphics software C utility software D word processing software MCCC Computer Concepts Test Study Guide 2 19 In a spreadsheet the columns and a rows form individual boxes called A intersects B addresses C worksheets D cells 20 The cell address F7 indicates that the cell A contains a label value of F7 B is at row F column 7 of the worksheet C is at row 7 column F of the worksheet D is performing a function involving a variable called F 21 In a spreadsheet equations you build yourself using values and cell references are called A functions B formulas C calculations D values 22 To save an existing file with a new name or to a new location you use the command 23 In a database a table is a collection of related A data B worksheets C records D files 24 Which type of software is used to keep track of appointments to do lists and telephone numbers A database software B presentation software C PIM software D word processing software 25 Forms that provide the basic structure for a particular kind of document are known as A patches B wizards C templates D macros 26 Microsoft Works is an example of a n A software suite B personal information manager C limited software edition D integrated software application package 27 Microsoft Office and Corel WordPerfect Office are examples of A open source products B freeware products C personal information management applications D software suites 28 Which type of software lets you dictate letters e mails and voice commands A Audio editing software B Content delivery software C Speech recognition software D Course management software MCCC Computer Concepts Test Study Guide 3 29 Apple QuickTime and Microsoft Media Player are examples of software 30 CD ripping refers to A stealing songs off the Internet B encoding CDs to MP3 format C creating your own CDs from your MP3 collection D erasing content on a CD 31 The organization responsible for rating computer games is the A U S Gaming Commission B Motion Picture Rating Board C Entertainment Software Rating Board D Entertainment Game Rating Board 32 QuickBooks and Peachtree are examples of A business accounting software B educational software C course management software D gaming software 33 QuarkXPress and Adobe InDesign are examples of software 34 Macromedia Dreamweaver is an example of A business accounting software B educational software C Web page authoring software D desktop publishing software 35 QuarkXPress and Adobe InDesign are examples of software 36 Software designed for a specific industry is known as software 37 Integrated help means A help is available on a CD B help is available in a user s manual C help is available on the Web D the documentation for the product is built directly into the software 38 Web based application software is software that A allows you to create Web pages B is installed by the computer manufacturer C is hosted on a Web site D does NOT need an Internet connection 39 Which of the following is an example of discounted software A Educational versions of software B A software suite C Beta versions of software D Web based application software A 40 What is the most common type of compatibility that a software