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