The Analyze Phase

Question 1

It is the process to make sense of the data collected?

Answer 1

Analysis

Question 2

Allows you to control what can and can’t be entered in your worksheet?

Answer 2

Data Validation

Question 3

It means collecting or gathering many separate pieces into a whole?

Answer 3

Aggregation

Data Aggregation
-multiple sources combined into a single summarized collection

Question 4

A function that converts a text string that represents a number into a numerical number?

Example: two = 2

Answer 4

VALUE Function

Question 5

A function that searches for a certain value in a column to return a corresponding piece of information?

Answer 5

VLOOKUP