INFSYS2800 Test 1 Multiple Choice

To calculate Sums, Averages, etc in an Excel database, use

DFunctions

Decisions that are unique, rapidly changing and not easily specified in advance are best served by a

Decision Support Application

are designed to support organization-wide process coordination and integration

Enterprise Applications

are information systems that support the long-range planning activities of senior management

Executive Support Systems

Are used to make difficult computations easier to calculate

Functions

designates a specific category of information systems serving middle management functions

Management Information Systems

the type of database management approach that can handle multimedia

Object-Oriented DBMS

the type of logical database model that treats data as if they were stored in two-dimensional tables

Relational DBMS

a function to find a specific entry in an Excel list or table

Vlookup

An Excel file that contains one or more worksheets is a

Workbook

A cell reference that refers to a cell by its fixed position in a worksheet, and does not chance when the formula/function is copied is an

absolute cell reference

To ensure that the reference to a specific cell does not change use

absolute referencing

Formulas and functions must begin with

an equal sign

A characteristic or quality describing an entity is called

attribute

To compare two values use a

comparison operator

the legal mechanism to protect the owners of intellectual property from having their work copied by others

copyright

duplicate data in multiple files

data redundancy

functions that perform some method on records in a database that match the criteria

database functions

database functions require

database,field, and criteria arguments

a method of making a change on multiple worksheets at the same time

grouping worksheets

intangible property created by individuals or corporation

intellectual property

The IF function requires arguments for

logical test, value if true, and value if false

The obligations that individuals and organizations have concerning rights to intellectual property fall within the

moral dimension of property rights and obligations

is a method of viewing data from a different viewpoint by changing the field layout of the data

pivot table

The use of computers to combine data from multiple sources and create electronic dossiers of detailed information is called

profiling

is a name that you can use to define a cell range

range name

is equal to (current value of the stock-original cost of the stock) divided by the original cost of the stock

return of a stock investment

In a table for customers, the information about a single customer would reside is a

single row

The principal liaison between the information systems group and the rest of the organization is the

systems analyst

When a cookie is created during a web site visit, it is stored on the

visitor's computer