Chapter 3: Application Software

____ programs allow you to edit and modify digital photographs

Image editing

Select all the types of graphic programs

Image editors Desktop publishing Illustration programs Video editors

Match each spreadsheet component with the corresponding description.

Label -> text entry Formula -> an instruction to perform a calculation Function -> a prewritten formula Cell -> can contain labels, numbers, formulas, and functions

In a software program, a ____ provides a list of options or commands.

Menu

Select the example of an office suite.

Microsoft Office

A bitmap image is made up of tiny dots called ____. These form bitmap images.

Pixels

Select all the components of a graphical user interface.

Pointer Window Icon

Select all of the popular online office suites

Zoho Google Docs Microsoft Office 365 Office for iPad

The ____ interface enables the user and the computer to interact

user

Analyzing the effect of a rate change in your car loan may be referred to as ____.

what-if-analysis

Each column in a table.

field

Calibri, Impact, Cambria, and Broadway are all examples of ____.

fonts

In a database, a ____ is used to enter and edit data and may have a paper version that looks similar.

form

=A1+A2 is an example of a ____.

formula

An instruction to perform a specific calculation is a ____.

formula

Select all of the common editing features in a word processor.

Alignment Spell checker Fonts and font size Grammar checker Character effects

____ replace menus and toolbars by organizing commonly used commands into a set of tabs.

Ribbons

____ are used to animate how the presentation moves from one slide to the next

Transitions

Select all the advanced features that allow you to add action to text and graphics and apply special effects to how the presentation moves from one slide to the next.

Transitions Animations

T/F: A WYSIWYG web authoring program allows you to build a web page without knowing HTML.

True

T/F: Desktop publishing programs are used to create publications that have unique page design and layout.

True

T/F: Sheet names make a workbook easy to navigate.

True

Select all the examples of image editors.

Windows Photo Gallery Adobe Photoshop Corel Paint Shop Pro

One advantage to a cloud suite over an office software suite is it is ____.

available from any computer that has internet access

An image that consists of pixels

bitmap

Toolbars include small graphic elements called ____ that provide shortcuts for quick access to commonly used commands.

buttons

A newspaper editor would use a(n) ____ program to create articles and layout pages.

desktop publishing

____ suites are stored on a server on the Internet and are available anywhere you can access the Internet.

Cloud

A newspaper editor would use a(n) ____ program to create article and layout pages.

Desktop publishing

Professional graphic artists would use ____ programs, also called page layout programs to create documents such as brochures, newsletters, newspapers, and textbooks.

Desktop publishing

____ provide additional information and request user input.

Dialog boxes

T/F: A software suite is a collection application programs available to purchase separately.

False

T/F: Specialized applications are widely used in nearly every profession.

False

Select all the examples of web authoring programs.

Microsoft Expression Web Adobe Dreamweaver

____ are those that are installed on your smartphone.

Mobile apps

_____ are add-on programs from mobile devices including smartphones and tablets.

Mobile apps

In a table, this field makes each record unique and is used to join a table to another related table.

Primary key

____ suites commonly include a word processor, spreadsheet, database manager, and a presentation application.

Productivity

Select all the examples that would be a good use of a DBMS.

Storing employee data Recording student grades Looking up criminal records

An amateur can take a video on a smartphone and then enhance the quality and appearance using a(n) ____.

Video editor.

____ software is available for anyone to design a game, develop characters and an environment.

Video game design

A ____ provides additional options and shows the effect of choosing the option.

gallery

The most widely used DBMS designed for microcomputers is Microsoft ____.

Access

The most widely used DBMS designed for microcomputers is Microsoft _____.

Access

Select all the examples of video editors.

Adobe Premier Microsoft Story Remix Apple iMovie

A(n) _____ is a web site that you can use to download mobile applications.

App store

Select all the types of documents that can be created by a word processor.

Flyer Letter Report

Select all the common features of application software that works with text documents.

Fonts and font sizes Alignment Spellchecker

Most applications use a ____ that displays windows, icons, and menus.

GUI

____ applications include word processors, spreadsheets, presentation software, and database management systems.

General-purpose

Select all the types of specialized applications.

Graphics Web authoring

_____ editors are programs used in web design.

HTML

____ programs, also known as drawing programs, use a combination of vector objects instead of bitmaps to create an image.

Illustration

Select all of the appropriate uses of presentation software.

In-class presentation Present marketing strategies

Select all the other popular word processing alternatives to Microsoft Word.

OpenOffice Writer Apple Pages Google Docs

____ programs allow you to edit and modify bitmap images.

Photo editing

Select all the examples of desktop publishing programs.

QuarkXPress Adobe InDesign Microsoft Publisher

Each row in a table.

Record

Select all the categories of application software.

Specialized General-purpose Mobile apps

In a relational database, a ____ is the most basic structure consisting of records and fields.

Table

In a presentation, predefined styles, layouts and suggested content are included in a(n) ____.

Template

A ____ includes buttons that provide quick access to commonly used commands.

Toolbar

The ____ interfaces is the portion of the application that allows you to control and interact with the program.

User

____ images use geometric shapes or objects to create an image.

Vector

The process of creating a web site would be referred to as ____.

Web authoring

_____ create text-based documents.

Word processors

The capability to add action to text and graphics on a slide is called ____.

animation

In a ribbon GUI tabs are used to divide the ribbon into amor activity areas. Each tab is then organized into ____.

groups

A software suite that is narrowly focused, such for graphics or financial planning, is called a ____ suite

specialized

In a word processor, the ____ looks for misspelled words.

spell checker

____ divide the ribbon into major activity areas.

Tabs

____ software is described as end-user software used to accomplish a variety of tasks.

Application

Select all the examples of character effects

Bold Color

Select all of the examples of illustration programs.

CorelDRAW Inkscape Adobe Illustrator

A _____ is a collection of related data.

Database

A ____ is a program that sets up a database and provides tools to enter, edit, and retrieve data from a database.

Database management system.

Select all the examples of general-purpose application software.

Database management systems Presentation software Spreadsheets

____ programs allow you to mix text and graphics and provide flexibility on page design and layout to create publications of professional quality.

Desktop publishing

Match each specialized application with the corresponding description.

Quickbooks -> record and report financial operations Quicken -> track personal expenses and investments Microsoft Project -> coordinate and plan projects

Which of the following would be the first step in creating a chart to present data in a spreadsheet program?

Select the cells containing the data.

____ analyze users' needs and create application software

Software engineers

Select all of the common editing features in a word processor.

Spell checker Alignment Character effects Fonts and font size Grammar checker

A department manager should use a ____ to analyze sales and create departmental budgets.

Spreadsheet

_____ are used to analyze sales, graph trends, and calculate averages.

Spreadsheets

_____ organize, analyze, and graph numeric data.

Spreadsheets

Match each database term with the corresponding descriptions.

Table -> makes up the basic structure of a relational database with columns containing filed data and rows containing record information Primary key -> unique identifier Form -> a mechanism to enter, edit and view data Record -> each row in a table Field -> a column in a table

Select the characteristics of blogs.

They are sometimes used by individuals as online diaries. They are published on the Internet.

Programs designed to make computing easier and safer, such as Norton System Works and Norton Internet Security Suite, are called ____ suites.

Utility

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

cell

In a ribbon GUI, a ____ tab only appears if it is needed.

contextual

A prewritten formula provided for you is called a ____.

function

An interface which uses ribbons, tabs, and galleries is an example of a ____.

ribbon GUI

A worksheet is a rectangular grid of ___

rows and columns