Repaso: Shelly - Chapter 3: Application Software 1 de 8 MULTIPLE CHOICE 1. Application software is used to ____. a. facilitate communications b. assist with graphics and multimedia projects c. support home, personal, and educational tasks d. all of the above 3. ____ performs functions specific to a business or industry. a. Freeware c. Custom software b. Packaged software d. Shareware 4. Open source software ____. a. is provided for use, modification, and redistribution b. has no restrictions from the copyright holder c. usually can be downloaded from the Web at no cost d. all of the above 5. ____ is copyrighted software that is distributed at no cost for a trial period. a. Shareware c. Packaged software b. Custom software d. Public-domain software 6. ____ is copyrighted software provided at no cost to a user by an individual or a company. a. Custom software c. Public-domain software b. Packaged software d. Freeware 7. ____ is free software, but it has been donated for public use and has no copyright restrictions. a. Shareware c. Freeware b. Public-domain software d. Packaged software 8. Each time a user starts a computer, the operating system is ____ (copied) from the computer’s hard disk into memory. a. Printed c. loaded b. Scrolled d. saved 12. A file is ____. a. an on-screen work area that has a graphical user interface b. a named collection of stored data, instructions, or information c. an instruction that causes a program to perform a specific action d. a horizontal space that contains a window’s title 13. A ____ is a special window that provides information, presents available options, or requests a response. a. command box c. dialog box b. shortcut menu d. submenu 14. ____ includes programs such as word processing, spreadsheet, database, presentation graphics, personal information manager software, PDA business software, software suites, accounting, and project management. a. Business software b. Graphics and multimedia software c. Software for home, personal, and educational use d. Communications software 15. A feature of word processing software called ____ allows users to type words in a paragraph continually without pressing the ENTER key at the end of each line. a. replace c. wordwrap b. search d. collaboration Repaso: Shelly - Chapter 3: Application Software 2 de 8 16. A macro is a ____. a. document that contains the formatting necessary for a specific document type b. sequence of keystrokes and instructions that a user records and saves c. small image on the screen that represents a program or document d. collection of drawings, diagrams, and photographs that can be inserted into a document 18. A template is a ____. a. document that contains the formatting necessary for a specific document type b. sequence of keystrokes and instructions that a user records and saves c. small image on the screen that represents a program or document d. collection of drawings, diagrams, and photographs that can be inserted into a document 19. When computer users ____ a document, they enter text or numbers, insert graphical images, and perform other tasks using an input device. a. create c. print b. format d. save 20. To ____ a document means to make changes to its existing content. a. format c. edit b. save d. print 21. To cut involves removing a portion of a document and storing it in a temporary storage location, sometimes called a ____. a. dialog box c. template b. clipboard d. submenu 23. A single point is about ____ of an inch in height. a. 1/9 c. 1/36 b. 1/18 d. 1/72 24. When computer users ____ a document, the computer transfers the document from memory to a storage medium. a. save c. format b. edit d. print Figure 3-4 Repaso: Shelly - Chapter 3: Application Software 3 de 8 27. Most spreadsheet software like that shown in Figure 3-4 includes a(n) ____ analysis feature, where users can change certain values in a spreadsheet to reveal the effects of those changes. a. concatenation c. what-if b. functional d. application 28. Using the ____ =SUM(B10:B14) totals the contents of cells B10 through B14 in a worksheet. a. label c. index b. value d. function Figure 3-1 29. Figure 3-1 illustrates a spreadsheet feature called ____, which depicts data in graphical form. a. querying c. recalculating b. scrolling d. charting 30. A ____, such as that in Figure 3-1, shows a trend during a period of time, as indicated by a rising or falling line. a. column chart c. pie chart b. line chart d. scatter chart 31. A ____, such as that in Figure 3-1, displays bars of various lengths to show the relationship of data. a. column chart c. pie chart b. line chart d. scatter chart 32. A ____, such as that in Figure 3-1, has a round shape cut into slices and shows the relationship of parts to a whole. a. column chart c. pie chart b. line chart d. scatter chart 33. In a database, each row, called a ____, contains data about a given person, product, object, or event. a. record c. form b. cell d. field 34. Using database software, you can ____. a. add, change, and delete data c. create forms and report b. sort and retrieve data d. all of the above 35. Users with an artistic ability can create their own graphics using paint/image editing software and then ____ (bring in) the graphics into a presentation graphics software slide. a. transport c. deport b. import d. export Repaso: Shelly - Chapter 3: Application Software 4 de 8 36. On a Tablet PC, the primary input device is a ____. a. digital pen c. mouse b. keyboard d. microphone 38. Two of the more commonly used ____ are Microsoft Office and Sun StarOffice. a. personal information managers c. clip art/image galleries b. software suites d. application service providers 39. ____ enables users to write and print checks, track checking account activity, and update and reconcile balances on demand. a. Legal software c. Entertainment software b. Reference software d. Accounting software 46. An e-mail program allows ____. a. real-time exchange of messages or files with another online user b. geographically separated people to transfer audio and video c. transmission of messages and files via a network such as the Internet d. users to access and view Web pages on the Internet 49. A(n) ____ restricts access to specified Web sites. a. antivirus program c. pop-up blocker b. anti-spam program d. Web filter 50. A(n) ____ protects a computer by identifying and removing any viruses found in memory, on media, or in files. a. antivirus program c. pop-up blocker b. anti-spam program d. Web filter 53. ____ is the delivery of education at one location while the learning takes place at other locations. a. Extended training (ET) c. Remote teaching (RT) b. Faraway schooling (FS) *d. Distance learning (DL) 54. ____ software serves as the interface between the user, the application software, and the computer’s hardware. a. System c. Maintenance b. Management d. Operational 55. A(n) ____ is a graphical element that a user activates to cause a specific action to take place. a. button c. menu b. icon d. title bar 56. A(n) ____ contains a list of commands from which a user makes selections. a. dialog box c. window b. icon d. menu 57. A(n) ____ is an instruction that causes a program to perform a specific action. a. dialog box c. command b. window d. title bar 58. A(n) ____ is a rectangular area of the screen that displays data and information. a. frame c. workspace b. box d. window 59. The top of a window has a(n) ____, which is a horizontal space that contains the window’s name. a. view bar c. frame name b. title bar d. dialog box Repaso: Shelly - Chapter 3: Application Software 5 de 8 60. A(n) ____ is a window that provides information, presents available options, or requests a response. a. menu bar c. style manager b. management frame d. dialog box 61. ____ is the process of moving different portions of a document on the screen into view. a. Sheeting c. Scrolling b. Surfing d. Loading Figure 3-2 62. A font ____, such as bold, italic, and underline in Figure 3-2, adds emphasis to a font. a. style c. face b. point d. weight 63. ____ software is software that allows users to organize data in rows and columns and perform calculations on the data. a. Database c. Spreadsheet b. PIM d. PDA 64. When using spreadsheet software, the rows and columns collectively are called a(n) ____. a. workbook c. worksheet b. workspace d. worksheet 65. A(n) ____ is the intersection of a column and row in a worksheet. a. link c. nexus b. cell d. grid 66. The text, or ____, entered in a cell identifies the worksheet data and helps organize the worksheet. a. filename c. cell text b. key text d. label 67. A(n) ____ is a predefined formula that performs common calculations such as adding the values in a group of cells. a. algorithm c. problem set b. function d. label 68. ____ software is a sophisticated type of application software that assists a professional user in creating engineering, architectural, and scientific designs. a. DTP c. CBT b. CAD d. WBT Repaso: Shelly - Chapter 3: Application Software 6 de 8 70. DTP software includes a color ____, which is a standard set of colors used by designers and printers to ensure that colors will print exactly as specified. a. glossary c. library b. reference d. indexed set 71. ____ software is software that allows users to draw pictures, shapes, and other graphical images with various on-screen tools such as a pen, brush, eyedropper, and paint bucket. a. Photo editing c. DTP b. CBT d. Paint 75. Application software often includes an image ____, which is a collection of clip art and photographs. a. master file c. gallery b. column d. clipset 77. A(n) ____ provides functions related to file and disk management. a. Web browser c. FTP client b. file manager d. spyware remover 78. A(n) ____ utility shrinks the size of a file(s). a. concatenation c. FTP b. file compression d. integrated Modified Multiple Choice 3. Spreadsheet software’s ability to recalculate data makes it an effective ____ tool. a. formatting c. budgeting b. forecasting d. decision making 4. Examples of editing tasks are ____. a. changing fonts c. inserting text b. deleting text d. underlining text 5. ____ is an example of a font style. a. Helvetica c. Arial b. Bold d. Italic 6. Common formatting tasks include ____. a. changing the font c. changing font size b. inserting text d. deleting text 7. A ____ is a window that provides information, presents available options, or requests a response. a. title bar c. menu bar b. frame manager d. dialog box 8. ____ programs usually have fewer capabilities than retail programs. a. Shareware c. Freeware b. Public-domain d. Custom 9. In addition to clip art, many clip art/image galleries provide ____. a. Fonts c. sounds b. video clips d. audio clips Repaso: Shelly - Chapter 3: Application Software 7 de 8 10. Application software, such as ____, often includes Web page authoring features. a. TurboTax c. Word b. Excel d. Microsoft Money TRUE/FALSE 1. The four categories of software are mutually exclusive; that is, software listed in one category may not be used in other categories. 2. To use application software, a computer must be running system software, specifically, an operating system. 3. While a computer is running, the operating system remains in memory. 6. When colors are used for characters in a word processing document, they will print as black or gray unless users have a color printer. 7. If you type text that extends beyond the right page margin, the word processing software automatically positions text at the beginning of the next line. 8. A major advantage of using word processing software is that users easily can change what they have written. 9. Word processing software usually includes public-domain clip art. 10. The search feature, in combination with the replace feature, allows users of word processing software to substitute existing characters or words with new ones. 11. The spelling checker included with word processing software compares words in a document with an electronic dictionary that is part of the operating system. 12. During the process of creating, editing, and formatting a document, the computer holds it on a storage medium. 13. When you save a document, the computer transfers the document from a storage medium to memory. 14. One of the benefits of word processing software is the ability to print the same document many times, with each copy looking just like the first. 15. Spreadsheet software is a rarely used type of application software. 16. Because of the logical approach that spreadsheet software has for organizing data, many people use this software to organize and present nonfinancial data, as well as financial data. Repaso: Shelly - Chapter 3: Application Software 8 de 8 Figure 3-4 17. As shown in Figure 3-4, all of a worksheet’s columns and rows are displayed on the screen at one time. 18. One of the more powerful features of spreadsheet software is its capability of recalculating the rest of the worksheet when data in a worksheet changes. 19. With a computerized database, the computer stores the data in an electronic format on a storage medium such as a hard disk. 20. Presentation graphics software provides a variety of layouts for each individual slide. 21. Presentation graphics software allows users to apply special effects to the transition between each slide. 23. With a personal information manager’s address book, users can schedule activities for a particular day and time. 36. Application software, such as Word and Excel, seldom include Web page authoring features. 38. The programs in software suites for personal use usually can be purchased individually. 39. The programs in software suites for personal use typically have all the capabilities of business applications. 40. Most personal finance software offers a variety of online services, which require access to the Internet. 45. Some operating systems include video and audio editing software. 48. Educational software seldom includes games or content to make the learning experience more fun. 49. A file compression utility identifies and fixes operating system and disk problems. 50. Utility programs are considered application software because they assist a user with performing business activities.