Application Software

Question 1

A _______ is a collection of interrelated files in a computer system.

Answer 1

database

[Explanation]

Database files are organized according to common elements to simplify retrieval.

Question 2

A structured file uses a _______ format to store data for each person or thing in the file.

Answer 2

uniform

[Explanation]

Databases use structured files to organize data.

Question 3

The most common type of database used on PCs is the __________ database in which data is organized into related tables.

Answer 3

relational

[Explanation]

Relational databases organize data in rows and columns. Access (included with Microsoft Office) is an example of a popular Windows-based relational database application.

Question 4

Paint, photo editing, and drawing software are all examples of ________ software.

Answer 4

graphics

[Explanation]

Graphics software is designed to help users manipulate and print graphics.

Question 5

In a relational database, a ___ field is used to sort data.

Answer 5

key

[Explanation]

This can also be called a sort key, index, or keyword. Most database applications allow for multiple keys so that users can sort records in different ways.

Question 6

In a relational database, the primary key holds a ______ value for each record.

Answer 6

unique

[Explanation]

If we were using a database containing employee records, the primary key might be the employee ID number or social security number. The primary key could be a unique series of numbers or characters; it doesn’t have to be meaningful–just unique.

Question 7

A database _____ contains a list of keys and each key provides a pointer to the record that contains the rest of the fields related to that key.

Answer 7

index

[Explanation]

A database index can be used to organize data in alphabetical or numerical order.

Question 8

In a relational database, information is organized in rows and columns. ____ are called records.

Answer 8

Rows

Question 9

In a relational database, information is organized in rows and columns. The ______ are called fields.

Answer 9

columns

Question 10

A field contains the smallest unit of meaningful data and can therefore be called the basic ________ block for a structured file or database.

Answer 10

building

[Explanation]

Examples of fields include name, address, social security number, etc.. A collection of fields make up a record.

Question 11

With a relational database, users _____ records to locate and display them.

Answer 11

query

[Explanation]

This action of calling up specific records in the database is called “querying”.

Question 12

____ processing software is used to create, edit, print, format and store text.

Answer 12

Word

Question 13

The ______ is a marker on the monitor which indicates where the next character will appear.

Answer 13

cursor

[Explanation]

The cursor is often a blinking rectangle and its location is called the insertion point.

Question 14

Spelling and _______ checkers flag unrecognized words, misspelled words, and incorrect grammar with different color squiggly lines.

Answer 14

grammar

Question 15

In word processing, the formatting for a ________ refers to the way text, graphics, headings, and page numbers appear on a page.

Answer 15

document

[Explanation]

The format for a document refers to the way the document looks.

Question 16

A ________ is a preformatted document often provided with word processing software.

Answer 16

template

[Explanation]

Examples of popular word processing templates include invoices, FAX cover sheets, and letterheads.

Question 17

A ________ allows users to enter data in rows and columns to create financial schedules and tables arranged as a grid on a display.

Answer 17

spreadsheet

[Explanation]

In addition to displaying information in rows and columns, spreadsheet software can perform calculations on inputted data. Examples of uses for this feature include grade books, budgets, project costs, expenses, etc..

Question 18

________ column headings appear across the top frame of the spreadsheet.

Answer 18

Lettered

[Explanation]

Column headings are used to select an entire column with a mouse click.

Question 19

Numbered ___ headings appear down the left frame of the spreadsheet.

Answer 19

row

[Explanation]

Row headings are used to select an entire row with a mouse click.

Question 20

The location on a spreadsheet where a row and a column intersect is called a ____.

Answer 20

cell

Question 21

A group of adjacent cells on a spreadsheet is called a _____.

Answer 21

range

[Explanation]

An example of specifying a range is “C1 to C17”.

Question 22

Harvard Graphics and MS PowerPoint are examples of ____________ graphics software.

Answer 22

presentation

[Explanation]

Typically, presentations created with this software are used in live presentations, but they may also be printed or presented over the web.

Question 23

Spreadsheet instructions for calculations are called ________.

Answer 23

formulas

[Explanation]

A formula works behind the scenes to instruct the spreadsheet on how to use the contents of cells in calculations. For example, a user might create a formula to add the contents of a range of cells.

Question 24

A spreadsheet _____ is any number used in a calculation.

Answer 24

value

[Explanation]

Values are the actual numbers or dates entered into cells. Examples of values include dollars, percentages, grade points and temperatures.

Question 25

A spreadsheet ________ is a built-in formula which performs common calculations.

Answer 25

function [Explanation] For example, a function might count up the results of a range of cells.

Question 26

A _____ is a single keystroke or command used to automatically issue a longer, predefined series of keystrokes or commands.

Answer 26

macro [Explanation] A macro, or keyboard shortcut, is useful when a user has to type the same pattern of keystrokes over and over.

Question 27

A _______ analysis allows a user to change the contents of a spreadsheet cell and find out how that would change the outcome of the calculation.

Answer 27

what-if [Explanation] An example of a what-if analysis would be a spreadsheet created to compare the costs of various mortgages. The user could change variables like interest rate, points, or principal amount and then compare the outcomes.

Question 28

An _____ system is an interactive computer program that helps users solve problems.

Answer 28

expert [Explanation] MYCIN, PROSPECTOR, CARES, CLUES and CLIPS are all examples of expert systems.

Question 29

The software that controls the search of the expert systems knowledge base and produces a conclusion is called the _________ engine.

Answer 29

inference

Question 30

Multimedia authoring software combines video, text, animation, graphics and sound to create standalone _________ applications.

Answer 30

multimedia [Explanation] Multimedia authoring software is popular with educational businesses, websites, and business training centers.

Question 31

In MS PowerPoint, the _______ view helps you organize the content of your material.

Answer 31

outline

Question 32

In MS PowerPoint, the slide sorter view displays __________ of each slide, allowing you to change the order of your presentation.

Answer 32

miniatures

Question 33

In PowerPoint, the __________ view presents the slides in the order in which the audience will view them.

Answer 33

slide show [Explanation] This allows you to practice your presentation.

Question 34

_________ software allows users to track income and expenses, manage checkbooks, create reports, and record tax information

Answer 34

Financial [Explanation] Examples of personal finance manager software include Quicken and Microsoft Money.

Question 35

Analytical graphics are graphical forms that make _______ data easier to analyze.

Answer 35

numeric [Explanation] Analytical graphics are also called business graphics and make sales figures and economic trends easier to understand.

Question 36

Settings automatically used by a program unless changed by the user are called _______ settings.

Answer 36

default

Question 37

__________________ software has reduced the time needed to create professional looking printed projects.

Answer 37

Desktop publishing [Explanation] Desktop publishing software (DTP) is used to create high quality materials for commercial printing. Examples of DTP software include MS Publisher and PageMaker.

Question 38

__________________ software allows scheduling of events, management of costs and allocation of resources associated with a project.

Answer 38

Project management [Explanation] Usually, project management software allows the user to break a project down into a series of goals or events which are organized as a timeline. Depending on the software, it will also allow management of a lot of the other details related to the project.

Question 39

Personal Information Management software helps users organize and manage daily ________ activities.

Answer 39

business [Explanation] Examples of information managed by PIM software include addresses, phone numbers, appointments, and to-do lists.

Question 40

Recalculation is the process of recomputing values in a ___________.

Answer 40

spreadsheet [Explanation] When data is changed in one cell, data in other cells is automatically recalculated.

Question 41

Word ____ is a special feature that automatically continues text on the next line when the user reaches the right margin.

Answer 41

Wrap

Question 42

__________ is the process of moving up, down, or sideways through the text or other screen display.

Answer 42

Scrolling

Question 43

The _______ displays menus and icons of commonly used commands and options.

Answer 43

toolbar [Explanation] In MS Windows, the toolbar is located at the top of the window below the menu bar.

Question 44

CAD software is used to ______ products, maps, structures and civil engineering drawings.

Answer 44

design [Explanation] Drawings created with CAD (Computer Aided Design) software are 3D and can be rotated to view all sides.

Question 45

What does CAD stand for?

Answer 45

Computer Aided Design

Question 46

Dreamweaver, Macromedia Flash and MS FrontPage are all examples of web page ______ software.

Answer 46

design [Explanation] Web page design software allows users to create sophisticated web pages with multimedia features.

Question 47

A ___________ is software that enables a user to find and access the various parts of the Internet.

Answer 47

web browser [Explanation] Popular web browsers include MS Internet Explorer, Netscape Navigator, and Mozilla Firefox.

Question 48

Examples of graphics file _______ include BMP, GIF, JPEG, TIFF, and PNG.

Answer 48

formats

Question 49

TIFF is a ________ file format used on both PCs and Macs for high quality printable files.

Answer 49

graphics

Question 50

JPEG is a popular graphics file format used in applications such as web pages where flexibility in _________ is important.

Answer 50

file size [Explanation] The JPEG graphics format has built-in compression that can be adjusted by the user. Modifying the compression allows the user to control the resulting file size.