TEST 1

Question 1

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

Answer 1

use DFunctions

Question 2

A characteristic or quality describing an entity is called an

Answer 2

attribute

Question 3

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

Answer 3

use an absolute reference

Question 4

are used to make difficult computations easier to calculate

Answer 4

Functions

Question 5

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

Answer 5

single row

Question 6

duplicate data in multiple files

Answer 6

data redundancy

Question 7

An Excel file that contains one or more worksheets is a

Answer 7

Workbook

Question 8

intangible property created by individuals or corporation

Answer 8

Intellectual property

Question 9

designed to support organization-wide process coordination and integration

Answer 9

Enterprise applications

Question 10

Return of a Stock Investment formula

Answer 10

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

Question 11

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

Answer 11

systems analyst

Question 12

Collects data from different firm functions and stores data in single central data repository

Answer 12

Enterprise Systems

Question 13

Could reduce labor costs but could also eliminate jobs.

Answer 13

Implementing new information systems

Question 14

Formulas and functions must begin with an

Answer 14

equal sign (=)

Question 15

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

Answer 15

Pivot Table

Question 16

requires arguments for logical test, value if true, and value if false

Answer 16

IF function

Question 17

created during a Website visit it is stored on the visitor’s computer.

Answer 17

A cookie

Question 18

type of database management approach that can handle multimedia

Answer 18

Object-Oriented DBMS

Question 19

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

Answer 19

Grouping worksheets

Question 20

To compare two values use a

Answer 20

comparison operator

Question 21

require database, field, and criteria arguments

Answer 21

Database Functions

Question 22

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

Answer 22

Relational DBMS

Question 23

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

Answer 23

Decision-Support Application

Question 24

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

Answer 24

Database Functions

Question 25

Basic concepts for ethical analysis

Answer 25

responsibility, accountability, liability and due process

Question 26

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

Answer 26

Vlookup

Question 27

Four major applications

Answer 27

Enterprise systems, Supply Chain Management Systems, Customer Relationship Management Systems, Knowledge Management Systems

Question 28

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

Answer 28

Copyright

Question 29

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

Answer 29

profiling

Question 30

A specific category of information systems serving middle management functions.

Answer 30

Management Information Systems

Question 31

refers to a cell by its fixed position in a worksheet and does not change when the formula/function is copied is an absolution cell reference

Answer 31

Cell reference

Question 32

Name that you can use to define a cell range

Answer 32

Range Name

Question 33

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

Answer 33

Executive support systems