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