Exam 2- Final

Question 1

The VBA Environment

Answer 1

P. 141

Question 2

What does VBA stand for?

Answer 2

Visual basics for applications p. 141

Question 3

What are the 2 types of coding mistakes?

Answer 3

Syntax errors and logic errors. p. 143

Question 4

Which kind of coding mistake is less often caught by the syntax checker?

Answer 4

logical mistakes p. 144

Question 5

Dim is short for

Answer 5

dimension

Question 6

Why should you avoid the variant data type?

Answer 6

It increases processing time because the interpreter must take extra steps to figure out what type of data is stored in the variable. p. 147

Question 7

T/F You must use Dim as for each variable you declare

Answer 7

True
You can do 
Dim J,K,L as long
It has to be
Dim J as long, K as long, L as long
p. 148

Question 8

What does typing option explicit at the top of your module do?

Answer 8

Forces you to declare variables. (Helps you avoid errors)

p. 148

Question 9

Workbook Navigation

Answer 9

p. 162

Question 10

What are the 2 types of objects?

Answer 10

Data-centric objects
Tool-centric objects
p. 162

Question 11

What is the difference between data-centric objects and tool-centric objects?

Answer 11

Data-centric objects contain data and a set of predefined methods that manipulate the data. (Range of cells, worksheet, a cell)
Tool-centric objects are tools with specific functionality that can be added to a workbook (button, text box)
p.162

Question 12

In workbook navigation, what are methods?

Answer 12

A set of predefined actions that can be performed on the data contained in the object. p. 162

Question 13

In workbook navigation, what are properties?

Answer 13

Characteristics of an object. p.162

Question 14

What 2 kinds of databases are there?

Answer 14

operational and analytical

BI slides

Question 15

Which kind of database is used for daily business process, accounting, reports?

Answer 15

operational

BI slides

Question 16

What is data mining?

Answer 16

Predicting the future

BI slides

Question 17

What is the difference between a data warehouse and a data mart?

Answer 17

A data warehouse has an enterprisewide organizational focus, while a data mart focuses on a subset of information for a given business unit such as finance
BI Slides

Question 18

What are the 2 primary tools to summarize data and characterize present status in BI?

Answer 18

Cubes
Dashboards
BI slides

Question 19

What is the common term for the representation of multidimensional information?

Answer 19

Cubes

BI slide 10

Question 20

What is a small scale, offline version of a data cube?

Answer 20

Excel pivot tables?

BI slide 11

Question 21

___ allow users (typically managers) to get a high level overview of the organization’s “health” or current status—as told by the data being gathered.

Answer 21

Dashboards

BI slide 12

Question 22

The data points included in the dashboard are referred to as

Answer 22

Key performance indicators

BI slide 12

Question 23

Common forms of data-mining analysis capabilities include (5)

Answer 23

Cluster analysis
Association detection
Statistical analysis
Key influencers analysis
Time series forecasts

Bi Slide 13

Question 24

___ is a technique used to divide an information set into mutually exclusive groups such that the members of each group are as close together as possible to one another and the different groups are as far apart as possible

Answer 24

Cluster analysis

Bi slide 15

Question 25

___ reveals the degree to which variables are related and the nature and frequency of these relationships in the information

Answer 25

Association detection | BI slide 16

Question 26

___ analyzes such items as Web sites and checkout scanner information to detect customers’ buying behavior and predict future behavior by identifying affinities among customers’ choices of products and services

Answer 26

Market basket analysis | BI slide 16

Question 27

___ are the factors that can significantly predict (to some degree between 0-100%) or explain the variance in another factor.

Answer 27

key influencers | Bi slide 17

Question 28

___ is a process that weeds out and fixes or discards inconsistent, incorrect, or incomplete info

Answer 28

Data cleaning | Bi slide 21

Question 29

A ___ process is program code that is executed at specified intervals (every minute, hour, day, week, month) to Copy the data from operational DBs and external sources Clean the data Insert it into the data warehouse

Answer 29

ETL | BI slide 22