MIS test 2

Question 1

Data hierarchy

Answer 1

The structure and organization of data (involves fields, records & files)

Question 2

Database management system (DBMS)

Answer 2

Software for creating, storing, maintains and accessing database files

Question 3

Database

Answer 3

A collection of related data that is stored in a central location or in multiple locations

Question 4

Sequential access file structure

Answer 4

Records in files organized and processed in numerical or sequential order

Question 5

Physical view

Answer 5

How data is stored on and retrieved from storage media (ex.hard disks, CD’s)

Question 6

Values

Answer 6

Very subjective beliefs

Question 7

Morals

Answer 7

Subjective standard that are greater than a single individual, usually a organization of people, a collective set of beliefs but not as objective as ethics

Question 8

Ethics

Answer 8

A way for us to study human behavior, that are objective and can study subjective

Question 9

Code of ethics

Answer 9

Manuals, code of ethics, a guide to guide your behavior

Question 10

Golden rule

Answer 10

Treat others the way you would like to be treated

Question 11

Immanuel Kanye categorical imperative

Answer 11

If an action is not right for everyone to take, it is not right for anyone

Question 12

Descartes rule of change

Answer 12

If an action cannot be taken repeatedly it is not right to take at all

Question 13

Game of thrones is the most:

Answer 13

Pirated movie on the planet with costs of 58 billion a year which leads to job losses and lost taxes

Question 14

Solutions to pirates on the web

Answer 14

Algorithms
Crawlers
New products and services to compete with the appeal of pirated content

Question 15

What creates a ripple effect

Answer 15

New technology that is created

Question 16

Basic concepts for ethical analysis

Answer 16

• responsibility
• accountability
• liability
• due process

Question 17

Logical function

Answer 17

Returns result, based on true or false condition

Question 18

Preview the data and use IF functions

Answer 18

=IF(logical_test, [value_if_true], [value_if_false])

IF(C5<=0, “scratch golfer”, “handicapped Golfer”)

Question 19

IF functions, nested IF function, and conjunction functions supports:

Answer 19

Decision making by selecting and filtering data that meet criteria

Question 20

Conditional statistical and math functions will:

Answer 20

Select data based on a criteria to aggregate data by counting, averaging, or summing

Question 21

LOOKUP functions use arguments to specify:

Answer 21

the location of data within table arrays

Question 22

MATCH, INDEX, and INDIRECT functions are:

Answer 22

used to locate data throughout the worksheet

Question 23

The INFFERIOR functions helps:

Answer 23

You isolate and eliminate errors in formulas

Question 24

Know ranges vs. data tables

Sort vs. filter

Pivot tables & pivot charts

Answer 24

Z

Question 25

What best describes the effect new information technology has on society?

Answer 25

It has a ripple effect and raises new ethical, social and political issues

Question 26

A mouse is an example of

Answer 26

an input and peripheral device

Question 27

Gottfried Leibniz created

Answer 27

The bianary number system

Question 28

In II cavallo “won’t you please reconsider” is truly a polite request?

Answer 28

False

Question 29

In Gravity kills me, was Judith Elsen the first woman to ever go into space?

Answer 29

No

Question 30

In Gravity kills me, the purpose of delta is

Answer 30

A generate profits for stock holders

Question 31

A _________ is a computer program designed to perform a group of coordinated functions, tasks, or activities for the benefit of the user

Answer 31

Operating system software

Question 32

What/who did people refer to as a “computer” before 1935?

Answer 32

People who performed calculations

Question 33

Which of the following refers to the ability of a computer, product, or system to expand to serve a larger number of users without breaking down

Answer 33

Scalability

Question 34

Beginning in the 1970’s personal computers stated depending on

Answer 34

Integrated circuits

Question 35

His team built the first general purpose computer:

Answer 35

John Von Neumann

Question 36

____ functions enable evaluation and choices to be interested into an excel spreadsheet

Answer 36

Logical

Question 37

What are common logical functions

Answer 37

IF, OR, AND, NOT

Question 38

Data that is manually calculated is known as

Answer 38

Static data

Question 39

True statements about the IF function

Answer 39

• the [value_if_false] argument may be omitted from the IF function
• the IF function is the most common logical function
• the TRUE argument of the IF function is optional

Question 40

Examples of statistical functions

Answer 40

COUNTIFS

AVERAGEIF

AVERAGEIFS

Question 41

___\is the name used for a collection of related sets of info that are composed of separate elements

Answer 41

Data sets

Question 42

____are interactive tables that extract, organize and summarize data

Answer 42

Pivot tables

Question 43

When creating pivot table , fields from the pivot table field list entries can be dragged and dropped to what quadrant areas?

Answer 43

• column labels
• row labels
• values

Question 44

The _______ feature of excel greatly increases user efficiency by enabling actions such as data entry to be performed on multiple worksheets at one time

Answer 44

Grouping

Question 45

References that address data across multiple worksheets are called

Answer 45

3-D references

Question 46

Validation _______ limit what worksheet users are allowed to enter into a particular cell

Answer 46

Criteria

Question 47

Macros:

Answer 47

• recording macros is generally considered an activity for worksheet developers
• as with cell references in formulas, cell references in macros can be absolute or relative
• macros are recorded with absolute references by default