Application Software Chapter 2 7th Edition Test Bank

Visualizing Technology Complete, 9e (Geoghan)

Chapter 2 Application Software

1) The intersection of a row and a column in a spreadsheet is called a ________.

A) text

B) cell

C) record

D) field

Diff: 1

Objective: 2.1 Identify Types and Uses of Business Productivity Software

2) In addition to performing calculations, ________ organize data that can be sorted and filtered, making the data functional for lists and schedules.

A) pie charts

B) graphics

C) spreadsheets

D) documents

Diff: 2

Objective: 2.1 Identify Types and Uses of Business Productivity Software

3) In a database, related records are organized into one or more ________.

A) macros

B) fields

C) tables

D) queries

Diff: 3

Objective: 2.1 Identify Types and Uses of Business Productivity Software

4) A(n) ________ is a single piece of information in a record in a database.

A) object

B) table

C) field

D) cell

Diff: 2

Objective: 2.1 Identify Types and Uses of Business Productivity Software

5) A(n) ________ contains information about a single entry in a database.

A) object

B) record

C) field

D) cell

Diff: 2

Objective: 2.1 Identify Types and Uses of Business Productivity Software

6) The most common way to enter data into a database, is to use a(n) ________.

A) object

B) form

C) query

D) report

Diff: 2

Objective: 2.1 Identify Types and Uses of Business Productivity Software

7) A ________ enables you to manage your email, calendar, contacts, and tasks–all in one application.

A) spreadsheet

B) document management system

C) personal information manager

D) database

Diff: 2

Objective: 2.1 Identify Types and Uses of Business Productivity Software

8) A(n) ________ allows someone to use software for a monthly or yearly fee.

A) retail license

B) proprietary software license

C) subscription

D) open source software license

Diff: 2

Objective: 2.4 Compare Various Ways of Obtaining Software

9) A(n) ________, also known as a hotfix, addresses individual software problems as they are discovered.

A) patch

B) service pack

C) update

D) upgrade

Diff: 2

Objective: 2.6 Install, Uninstall, and Update Software

10) A ________ helps you to complete projects, keep within your budget, stay on schedule, and work with others.

A) personal information manager

B) document management system

C) word processor

D) project management software

Diff: 1

Objective: 2.1 Identify Types and Uses of Business Productivity Software

11) ________ contains the tasks and dates for a project and shows the schedule and progress of the project in a graphic.

A) WordArt

B) A Gantt chart

C) SmartArt

D) A flowchart

Diff: 2

Objective: 2.1 Identify Types and Uses of Business Productivity Software

12) Which of the following applications is not part of an office application suite?

A) Spreadsheet

B) Financial

C) Database

D) Presentation

Diff: 3

Objective: 2.1 Identify Types and Uses of Business Productivity Software

13) ________ software can be copied, modified, and redistributed without paying a fee.

A) Shareware

B) Open source

C) Trialware

D) Retail

Diff: 2

Objective: 2.2 Identify Types and Uses of Personal Software

14) Which of the following is not part of Microsoft Office Online web apps?

A) OneNote

B) Excel

C) Access

D) PowerPoint

Diff: 3

Objective: 2.2 Identify Types and Uses of Personal Software

15) Making money through in-app purchases is common in ________ software.

A) freemium

B) shareware

C) subscription

D) donationware

Diff: 2

Objective: 2.4 Compare Various Ways of Obtaining Software

16) Which is not a modern source of installing software?

A) Web

B) CD/DVD

C) Flash drive

D) Floppy drive

Diff: 2

Objective: 2.6 Install, Uninstall, and Update Software

17) When you purchase software in a box, reading the ________ is important to know if the software will function properly.

A) system requirements

B) shareware requirements

C) EULA

D) SaaS

Diff: 1

Objective: 2.3 Assess a Computer System for Software Compatibility

18) A computer can be a flexible and powerful tool by using what type of software?

A) Operating system

B) Application

C) Utility

D) Server

Diff: 2

Objective: 2.1 Identify Types and Uses of Business Productivity Software

19) Sophia heard about some media software with a free trial download. She thought it would be a good idea to try it before buying. She is using which type of proprietary software?

A) Donationware

B) Freeware

C) Openware

D) Shareware

Diff: 2

Objective: 2.4 Compare Various Ways of Obtaining Software

20) An end user license agreement represents which of the following?

A) Agreement between the user and the store where the software was purchased

B) System requirements needed for downloading the software

C) Agreement between the user and the software publisher

D) Hardware specifications for the computer

Diff: 2

Objective: 2.4 Compare Various Ways of Obtaining Software

21) ________ can be used at no cost for an unlimited period of time.

A) Shareware

B) Freeware

C) Donationware

D) Open source software

Diff: 2

Objective: 2.4 Compare Various Ways of Obtaining Software

22) ________ is a form of freeware, where the developers accept contributions for themselves or for nonprofit organizations.

A) Donationware

B) Retail software

C) Malware

D) Open source software

Diff: 2

Objective: 2.4 Compare Various Ways of Obtaining Software

23) The term "cloud" in cloud computing refers to ________.

A) extra storage files located on the computer

B) free financial software

C) websites for creating documents

D) the Internet

Diff: 1

Objective: 2.5 Discuss the Importance of Cloud Computing

24) Which of the following is not a cloud service provider?

A) Salesforce

B) Amazon

C) Google

D) Intel

Diff: 3

Objective: 2.5 Discuss the Importance of Cloud Computing

25) What is not true about analytics?

A) It detects patterns in data.

B) It can help a business make decisions.

C) It comes standard in Project Management software.

D) It can raise profits.

Diff: 3

Objective: 2.1 Identify Types and Uses of Business Productivity Software

26) ________ involves the delivery of applications – web apps – over the Internet.

A) Software-as-a-Service (SaaS)

B) Programming-as-a-Service (PaaS)

C) Business-as-a-Service (BaaS)

D) Information-as-a-Service (IaaS)

Diff: 3

Objective: 2.5 Discuss the Importance of Cloud Computing

27) ________ provides a programming environment to develop, test, and deploy custom web applications.

A) Software-as-a-Service (SaaS)

B) Platform-as-a-Service (PaaS)

C) Business-as-a-Service (BaaS)

D) Information-as-a-Service (IaaS)

Diff: 3

Objective: 2.5 Discuss the Importance of Cloud Computing

28) Which of the following is an example of a personal Software-as-a-Service (SaaS)?

A) Intuit Quicken

B) Amazon

C) Google Drive

D) eBay

Diff: 3

Objective: 2.5 Discuss the Importance of Cloud Computing

29) A(n) ________ is a larger, planned update that addresses multiple problems or adds multiple features.

A) service pack

B) patch

C) upgrade

D) hotfix

Diff: 2

Objective: 2.6 Install, Uninstall, and Update Software

30) Web apps which will run on any device with a supported browser and Internet access are called platform-________.

A) neutral

B) dependent

C) specific

D) apps

Diff: 2

Objective: 2.4 Compare Various Ways of Obtaining Software

31) Which software application is best for creating and formatting text documents?

A) Word processor

B) Spreadsheet

C) Database

D) Presentation

Diff: 1

Objective: 2.1 Identify Types and Uses of Business Productivity Software

32) What is not true about Customer Relations Management systems?

A) It helps you complete projects.

B) It can be cloud-based or locally hosted.

C) It maintains customer information and connections.

D) It can be used to gain information about marketing, sales, and customer service.

Diff: 2

Objective: 2.1 Identify Types and Uses of Business Productivity Software

33) What is the best application for organizing and using a lot of information?

A) Database

B) Spreadsheet

C) Word processor

D) Presentation

Diff: 1

Objective: 2.1 Identify Types and Uses of Business Productivity Software

34) What is not a part of Project management software?

A) A database of customer contacts

B) A timeline

C) Team-planning capability

D) Portfolio manager

Diff: 2

Objective: 2.1 Identify Types and Uses of Business Productivity Software

35) A database is a collection of information organized in a useful way.

Diff: 1

Objective: 2.1 Identify Types and Uses of Business Productivity Software

36) PowerPoint is an example of presentation software.

Diff: 2

Objective: 2.1 Identify Types and Uses of Business Productivity Software

37) In a database, a report is used to easily enter data.

Diff: 1

Objective: 2.1 Identify Types and Uses of Business Productivity Software

38) Apache OpenOffice is a free, open source alternative office suite available in Windows, Mac, and Linux versions.

Diff: 2

Objective: 2.2 Identify Types and Uses of Personal Software

39) Microsoft SharePoint is an example of a document management system (DMS).

Diff: 2

Objective: 2.1 Identify Types and Uses of Business Productivity Software

40) Microsoft Office Online web apps are full-featured versions of the Microsoft Office applications.

Diff: 2

Objective: 2.2 Identify Types and Uses of Personal Software

41) System requirements only list hardware specifications for the computer.

Diff: 2

Objective: 2.3 Assess a Computer System for Software Compatibility

42) Queries allow you to pull out records from a table that meet specific criteria.

Diff: 2

Objective: 2.1 Identify Types and Uses of Business Productivity Software

43) The use of queries adds flexibility to database programs.

Diff: 1

Objective: 2.1 Identify Types and Uses of Business Productivity Software

44) Jane purchased some financial software at the local office store. She brought it home and installed it on her computer. She actually owns the software program now because she purchased it from a local merchant.

Diff: 2

Objective: 2.4 Compare Various Ways of Obtaining Software

45) Apache OpenOffice is offered for only a small fee based on the number of computers on which you want to install it.

Diff: 3

Objective: 2.2 Identify Types and Uses of Personal Software

46) Shareware is also referred to as trialware.

Diff: 2

Objective: 2.4 Compare Various Ways of Obtaining Software

47) Proprietary software licensing restricts the user from distributing or duplicating the software.

Diff: 2

Objective: 2.4 Compare Various Ways of Obtaining Software

48) Freeware can be used at no cost for an unlimited period of time.

Diff: 1

Objective: 2.4 Compare Various Ways of Obtaining Software

49) Cloud computing moves storage off your desktop and business hardware and puts it on the Internet.

Diff: 1

Objective: 2.5 Discuss the Importance of Cloud Computing

50) A benefit to cloud service providers is that they can operate from remote places.

Diff: 1

Objective: 2.5 Discuss the Importance of Cloud Computing

51) Web mail is an example of SaaS.

Diff: 2

Objective: 2.5 Discuss the Importance of Cloud Computing

52) You can use File Explorer to begin installation of a new software program.

Diff: 1

Objective: 2.6 Install, Uninstall, and Update Software

53) A bug is a flaw in programming of a software application.

Diff: 1

Objective: 2.6 Install, Uninstall, and Update Software

54) A hotfix is never included in a service pack; they are only available as separate, stand-alone fixes.

Diff: 2

Objective: 2.6 Install, Uninstall, and Update Software

55) A desktop application has a built-in operating system.

Diff: 2

Objective: 2.4 Compare Various Ways of Obtaining Software

56) Customers pay a fee to use retail software.

Diff: 1

Objective: 2.1 Identify Types and Uses of Business Productivity Software

57) In database applications, reports are created to display selected information.

Diff: 1

Objective: 2.1 Identify Types and Uses of Business Productivity Software

58) Application software is what makes a computer a flexible and powerful tool.

Diff: 2

Objective: 2.1 Identify Types and Uses of Business Productivity Software

59) A hotfix and a patch are two different ways to update software.

Diff: 2

Objective: 2.6 Install, Uninstall, and Update Software

60) Updates and new versions are free with subscription-based software.

Diff: 2

Objective: 2.4 Compare Various Ways of Obtaining Software

61) Databases contain one or more tables.

Diff: 1

Objective: 2.1 Identify Types and Uses of Business Productivity Software

62) A(n) ________ is an application used to create, edit, and format text documents.

Diff: 1

Objective: 2.1 Identify Types and Uses of Business Productivity Software

63) A(n) ________ is a software application that creates electronic worksheets organized into rows and columns.

Diff: 1

Objective: 2.1 Identify Types and Uses of Business Productivity Software

64) In a database, a person's email address is an example of a(n) ________.

Diff: 2

Objective: 2.1 Identify Types and Uses of Business Productivity Software

65) In a database, the combination of the name, address, email, and phone for one person is an example of a(n) ________.

Diff: 2

Objective: 2.1 Identify Types and Uses of Business Productivity Software

66) You would use a(n) ________ to manage your email, calendar, contacts, and tasks–all in one place.

Diff: 2

Objective: 2.1 Identify Types and Uses of Business Productivity Software

67) A(n) ________ enables a business to save, share, search, and audit electronic documents.

Diff: 2

Objective: 2.1 Identify Types and Uses of Business Productivity Software

68) You can copy, modify, and redistribute ________ software without paying a fee.

Diff: 2

Objective: 2.2 Identify Types and Uses of Personal Software

69) You would use ________ software to organize and play music, videos, and podcasts on your computer.

Diff: 2

Objective: 2.2 Identify Types and Uses of Personal Software

70) A Customer ________ Management system is a system for maintaining customer information and connections.

Diff: 2

Objective: 2.1 Identify Types and Uses of Business Productivity Software

71) A(n) ________ is a self-contained program usually designed for a single purpose.

Diff: 2

Objective: 2.4 Compare Various Ways of Obtaining Software

72) EULA stands for ________.

Diff: 2

Objective: 2.4 Compare Various Ways of Obtaining Software

73) Rajiv purchased some great gaming software and wants to make copies for all his friends. Rajiv is restricted from making copies of the software for his friends because it has a(n) ________ software license.

Diff: 2

Objective: 2.4 Compare Various Ways of Obtaining Software

74) Richard just purchased a new computer. During the initial setup, he noticed he was given Microsoft Office. Most likely, this is a free trial for Richard known as ________.

Diff: 3

Objective: 2.4 Compare Various Ways of Obtaining Software

75) ________ is a form of freeware, where the developers accept contributions for themselves or for nonprofit organizations.

Diff: 2

Objective: 2.4 Compare Various Ways of Obtaining Software

76) ________ is a type of software that can be used at no cost for an unlimited period of time.

Diff: 2

Objective: 2.4 Compare Various Ways of Obtaining Software

77) ________ software requires the user to pay a fee for it.

Diff: 2

Objective: 2.4 Compare Various Ways of Obtaining Software

78) Amazon and Google deliver cloud services to users and are known as ________ providers.

Diff: 2

Objective: 2.5 Discuss the Importance of Cloud Computing

79) ________-as-a-Service provides users with a system server offsite, instead of maintaining and purchasing one at the place of business.

Diff: 2

Objective: 2.5 Discuss the Importance of Cloud Computing

80) Jacob checks his email using web mail. Jacob is using the cloud as a(n) ________-as-a-Service.

Diff: 2

Objective: 2.5 Discuss the Importance of Cloud Computing

81) ________-as-a-Service provides a programming environment in which custom web applications can be developed, tested, and deployed.

Diff: 3

Objective: 2.5 Discuss the Importance of Cloud Computing

82) Instead of purchasing and maintaining its own cloud-based servers, a company could use a(n) ________-as-a-Service provider.

Diff: 3

Objective: 2.5 Discuss the Importance of Cloud Computing

83) A(n) ________ or patch addresses individual problems with software as they are discovered.

Diff: 2

Objective: 2.6 Install, Uninstall, and Update Software

84) A(n) ________ is a flaw in programming.

Diff: 2

Objective: 2.6 Install, Uninstall, and Update Software

85) A(n) ________ is a large, planned update that addresses multiple problems or adds multiple features.

Diff: 2

Objective: 2.6 Install, Uninstall, and Update Software

86) Businesses use ________ to help make decisions to improve customer service.

Diff: 2

Objective: 2.1 Identify Types and Uses of Business Productivity Software

87) In a spreadsheet, the intersection of a row and column is called a(n) ________.

Diff: 2

Objective: 2.1 Identify Types and Uses of Business Productivity Software

88) The cloud refers to the ________.

Diff: 2

Objective: 2.5 Discuss the Importance of Cloud Computing

89) A(n) ________ application is installed on a PC and requires an operating system.

Diff: 1

Objective: 2.1 Identify Types and Uses of Business Productivity Software

90) Earning money through in-app purchases is known as ________.

Diff: 1

Objective: 2.4 Compare Various Ways of Obtaining Software

91) Applications that run in browsers are known as platform-________.

Diff: 2

Objective: 2.4 Compare Various Ways of Obtaining Software

92) The most commonly used application software in business is an office application ________.

Diff: 2

Objective: 2.1 Identify Types and Uses of Business Productivity Software

93) Match each of the following applications to its purpose:

I. office application suite

II. word processor

III. database

IV. spreadsheet

V. personal information manager

A. includes several applications that are designed to work together

B. handles email, calendar, contacts, and tasks–all in one place

C. application used to create, edit, and format text documents

D. collects information that is organized in a useful way

E. can be used for budgeting, grade books, and inventory

Diff: 3

Objective: 2.1 Identify Types and Uses of Business Productivity Software

94) Match each of the following terms to its meaning:

I. cell

II. field

III. report

IV. query

V. table

A. single piece of information in a record

B. pulls out records that meet specific criteria

C. organization of records

D. generated to display selected information

E. intersection of a row and column

Diff: 2

Objective: 2.1 Identify Types and Uses of Business Productivity Software

95) Match each of the following terms to its meaning:

I. bug

II. hotfix

III. service pack

IV. cloud

V. open source

A. programming flaw

B. addresses individual problems as they are discovered

C. code is that is published and made available to the public

D. planned update that addresses multiple problems

E. refers to the Internet

Diff: 3

Objective: Multiple objectives in the chapter

96) Match each of the following terms to its example:

I. database management

II. media management

III. photo editing software

IV. cloud service provider

V. presentation software

A. Keynote

B. Access

C. iTunes

D. Google Photos

E. Google

Diff: 3

Objective: Multiple objectives in the chapter

97) Match each of the following terms to its meaning:

I. proprietary software

II. open source software

III. donationware

IV. shareware

V. retail software

A. software offered in trial form or for a limited period

B. end user has the right to modify and redistribute the software

C. software for which developers accept contributions for themselves or nonprofit organizations

D. user pays a fee to use the software

E. ownership remains with the software publisher

Diff: 2

Objective: 2.4 Compare Various Ways of Obtaining Software