Deck 6: Application Software: Desktop and Mobile Apps

Question 1

Paragraph formatting changes an entire paragraph at one time, such as specifying the line spacing for a particular paragraph.

Answer 1

True

Question 2

Most spreadsheet programs do not have built-in Web capabilities.

Answer 2

False

Question 3

The Cut command in Windows can be replaced by the keyboard shortcut [Ctrl]+[C].

Answer 3

False

Question 4

Typically data in a database is organized into fields, records, and files.

Question 5

When entering a formula or function into a cell, most spreadsheet programs require that you begin with some type of symbol, usually the asterisk character (*).

Question 6

Once an image is inserted into a document, it cannot easily be modified.

Question 7

For most software programs, the licensing agreement or terms of use agreement is usually displayed and must be agreed to by the end user at the beginning of the software installation.

Question 8

Public domain software is not copyrighted; instead, the ownership rights to the program have been donated to the public domain.

Question 9

Graphics software-also called digital imaging software-is used to create or modify images.

Question 10

To create presentation graphics, database software is used.

Question 11

Popular application programs such as Word or PowerPoint typically have mobile versions.

Question 12

Spreadsheet templates are available to help users quickly create common types of business documents, such as balance sheets, income statements, invoices, and purchase orders.

Question 13

The development rights of a software program specify the allowable use of the program.

Question 14

To retrieve information from a database, queries and reports are used.

Question 15

Microsoft Office is available for users of all operating systems.

Question 16

Font face refers to a named collection of text characters that share a common design, such as Calibri or Times New Roman.

Question 17

In spreadsheet programs, when absolute cell references are used, formulas are copied exactly as they are written.

Question 18

In a typical word processing program, a footer is text entered by the user that appears at the top of every page.

Question 19

Like any document created with software instead of paper and pencil, word processing documents can be retrieved, modified, and printed as many times as needed.

Question 20

To capture sound from a CD, ripping software is used.

Question 21

Transitions -special effects used between slides-can be applied to specific slides, or random transitions can be selected for the entire slide show. _________________________

Question 22

Regardless of the device being used, software typically falls into four basic categories of software: commercial software, shareware, freeware, and ____.

A) executable software
B) public domain software
C) advertising software
D) licensed software

Question 23

Typically, objects in  p ainting programs can be layered so, if you place one object on top of another, you can later separate the two images if desired. _________________________

Question 24

When a software program is purchased, the buyer is acquiring a(n) ____ that permits him or her to use the software.

A) software license
B) copyright
C) ownership right
D) software key

Question 25

Drawing programs typically create vector graphics, which use mathematical formulas to represent image content instead of pixels. _________________________

Question 26

A(n) wizard is a document that is already created and formatted to fit a particular purpose, such as a fax cover sheet, résumé, memo, calendar, invoice, newsletter, or Web page. _________________________

Question 27

Cloud software is delivered on demand via the Web to wherever the user is at the moment, provided he or she has an Internet connection. _________________________

Question 28

A type of sensitivity analysis (called what if in Microsoft Excel) involves having the spreadsheet compute the amount a constant value would need to be in order for the result of a particular formula to become a specified amount. _________________________

Question 29

O pen source software  are programs made up of source code that is available to the public. _________________________

Question 30

In addition to their full versions, some commercial software is available in a ____ or trial version.

A) batched
B) user-friendly
C) complimentary
D) demo

Question 31

Font size is measured in points . _________________________

Question 32

Most application programs that allow text editing have a(n) editing spot that looks like a blinking vertical line on the screen and shows where the next change will be made to the document currently displayed on the screen. _________________________

Question 33

The toolbar command button that pastes the last item copied or cut to the Clipboard to the current location can be replaced by the keyboard shortcut [Ctrl]+[P] . _________________________

Question 34

At its most basic level, word processing is used to do what was done on a typewriter before computers were commonplace. _________________________

Question 35

____ is freeware software.

A) Norton AntiVirus (antivirus program)
B) Image Shrinker (image optimizer)
C) Chrome (Web browser)
D) Lynx (text-based Web browser)

Question 36

In a worksheet, functions are words, column headings, and other nonmathematical data. _________________________

Question 37

____ is a shareware program.

A) Microsoft Office (office suite)
B) LibreOffice (office suite)
C) Quake 3 (game)
D) WinZip (file compression program)

Question 38

Most spreadsheet programs allow multiple worksheets to be saved together in a single spreadsheet file, called a(n) workbook . _________________________

Question 39

Web-based software must be installed on the device being used before it is run. _________________________

Question 40

Ownership rights for original creative works are referred to as software licenses . _________________________

Question 41

When typing text in a word processing program, you should only press ____ after a short line (like a title), at the end of a paragraph, and to leave a blank line between paragraphs.

A) Enter
B) Backspace
C) Insert
D) Esc

Question 42

Businesses and many individuals often use office suites, sometimes called ____, to produce written documents.

A) integral suites
B) productivity software suites
C) midrange suites
D) corporate suites

Question 43

The keyboard shortcut [Ctrl]+[Z] is used to ____ the last change to the document.

A) Confirm
B) Repeat
C) Save
D) Undo

Question 44

The ____ is a tool in versions of Microsoft Office starting with Office 2007 that consists of tabs, which contain groups of related command buttons for the program being used.

A) shortcut menu
B) menu bar
C) Ribbon
D) Wizard

Question 45

A(n) ____ is a named, preprogrammed formula, such as to compute the average of a group of cells or to calculate a mortgage payment amount.

A) argument
B) label
C) cell
D) function

Question 46

A single spreadsheet document is often called a ____.

A) cell
B) database
C) workbook
D) worksheet

Question 47

In spreadsheet programs, labels and constant values are always copied exactly to the new location; what happens to formulas when they are copied depends on whether they use relative cell referencing or ____.

A) total cell referencing
B) integral cell referencing
C) absolute cell referencing
D) full cell referencing

Question 48

In a worksheet, the intersection of a row and a column is called a ____.

A) pointer
B) table
C) footer
D) cell

Question 49

When selecting font size in a document, ____ points equals one-inch-tall text.

A) 36
B) 48
C) 60
D) 72

Question 50

____ can be used, copied, modified, and distributed to others without restrictions.

A) Shareware
B) Commercial software
C) Freeware
D) Public domain software

Question 51

Most ____ programs are available to try free of charge, but typically require a small fee if you choose to use the program regularly.

A) shareware
B) commercial
C) freeware
D) public domain

Question 52

The most common type of database used with personal computers today is a ____.

A) relational database
B) two-way database
C) one-dimensional database
D) concurrent database

Question 53

Many business software services are offered as ____, including applications geared for collaboration, scheduling, customer service, accounting, project management, and more.

A) download services
B) Software as a Service (SaaS)
C) Internet service providers (ISPs)
D) running services

Question 54

Some mobile apps are designed to be compatible with popular ____ such as Microsoft Office.

A) Web-based software
B) system utilities
C) desktop software
D) Internet utilities

Question 55

Word processing programs use a feature called ____, which means the insertion point automatically moves to the beginning of the next line when the end of the screen line is reached.

A) word wrap
B) character wrap
C) letter wrap
D) character overflow

Question 56

____ programs are software programs that are distributed on the honor system.

A) Commercial
B) Freeware
C) Shareware
D) Public domain

Question 57

A ____ is a group of values and other data organized into rows and columns, similar to the ruled paper worksheets traditionally used by bookkeepers and accountants.

A) document
B) cell
C) spreadsheet
D) block

Question 58

Related software programs (such as a group of graphics programs, utility programs, or office-related software) are sometimes sold bundled together as a ____.

A) software suite
B) software thread
C) software bank
D) software base

Question 59

Charts are inserted into an Excel spreadsheet using the commands in the Charts group on the ____ tab on the Ribbon.

A) Format
B) Insert
C) Tools
D) Data

Question 60

Most application programs have a built-in help feature, typically available through a(n) ____ button.

A) Tool
B) Window
C) Help
D) Advanced

Question 61

One of the most common painting programs is ____.

A) Macromedia's Dreamweaver
B) Adobe's Acrobat
C) Microsoft Paint
D) IBM's Storyboard

Question 62

____________________ is software that is developed and sold for a profit.

Question 63

____________________ consists of programs designed to perform specific tasks or applications.

Question 64

Case-Based Critical Thinking Questions Case 6-1 When Mary started college, her parents bought her a new computer that came loaded with the bare essentials in terms of software applications. She is now looking into purchasing additional software. Mary needs word processing software for her classes, but she has to budget her resources carefully this semester. She might consider using ____.

A) Office 365
B) Office Online
C) Corel Office
D) WordPerfect Office

Question 65

____________________ programs are software programs that are given away by the author for others to use free of charge.

Question 66

A ____ is an image designed to enhance a presentation (such as an electronic slide show or a printed report) visually, typically to convey information more easily to people.

A) projector
B) presentation graphic
C) Trojan horse
D) phish

Question 67

Case-Based Critical Thinking Questions Case 6-2 Bryan has just started an internship in which he uses a database frequently. The database contains information about the company's employees. Bryan's supervisor senses that he is anxious about using the database and drops by to give him a short tutorial. Bryan's supervisor explains that to retrieve information from the database, Bryan needs to use a ____.

A) query
B) form
C) presentation
D) formula

Question 68

A presentation graphics program contains an assortment of tools and operations for creating and editing slides, including preformatted ____ containing placeholders for the various elements in the slide.

A) wizards
B) charts
C) slide clips
D) slide layouts

Question 69

A ____ is a question, or, in database terms, a request for specific information from the database.

A) report
B) query
C) form
D) cell

Question 70

____ refers to using a personal computer to combine and manipulate text and images to create attractive documents that look as if they were created by a professional printer.

A) Computer-aided design (CAD)
B) Desktop publishing
C) Project management software
D) Personal productivity

Question 71

Popular drawing programs include ____, CorelDRAW, and Corel Painter.

A) Harvard Graphics
B) Adobe Illustrator CC
C) Corel Paint Shop Pro
D) IBM Storyboard

Question 72

____ are programs designed to play audio and video files.

A) Media players
B) Media boxes
C) iPods
D) Real players

Question 73

Case-Based Critical Thinking Questions Case 6-2 Bryan has just started an internship in which he uses a database frequently. The database contains information about the company's employees. Bryan's supervisor senses that he is anxious about using the database and drops by to give him a short tutorial. The supervisor explains that each employee's information forms a separate ____.

A) field
B) record
C) table
D) file

Question 74

Presentation slides can be advanced at predetermined intervals, by clicking or tapping on the screen, or by ____.

A) right-clicking the mouse
B) pressing the esc key
C) pressing the backspace key
D) pressing the spacebar

Question 75

Case-Based Critical Thinking Questions Case 6-1 When Mary started college, her parents bought her a new computer that came loaded with the bare essentials in terms of software applications. She is now looking into purchasing additional software. Mary enjoys taking digital photos and would like software that would allow her to perform tasks such as correct brightness or contrast, eliminate red eye, crop, resize, etc. In order to have this functionality on her computer, she needs a photo ____ program.

A) dramatization
B) embedding
C) formatting
D) editing

Question 76

Businesses that need to install software on multiple computers or need to have the software available to multiple users over a network can usually obtain a site license or ____________________ for the number of users needed.

Question 77

Case-Based Critical Thinking Questions Case 6-2 Bryan has just started an internship in which he uses a database frequently. The database contains information about the company's employees. Bryan's supervisor senses that he is anxious about using the database and drops by to give him a short tutorial. Bryan is told by the supervisor that to create a database, he first needs to create the database ____ itself, and then he can create the necessary database objects.

A) table
B) field
C) record
D) file

Question 78

____ refers to organizing the content to be transferred to DVD, such as importing video clips, creating the desired menu structure, and so forth.

A) DVD authoring
B) Video editing
C) Video ripping
D) DVD ripping

Question 79

____ is used to plan, schedule, track, and analyze the tasks involved in a project, such as the construction of a building or the schedule for preparing a large advertising campaign for a client.

A) Computer-aided design (CAD)
B) Desktop publishing
C) Project management software
D) Personal productivity

Question 80

For some server software used within a virtual environment, Microsoft computes the number of users based on a(n) ____________________ instance; that is, the number of software instances (installed or virtual) being used at any given time.