Update ) Exploring Data
| Review Guide Questions and
Answers | Grade A | 100% Correct
(Verified Solution) - WGU
Question:
A way of selecting a sample from a population so that every possible type of
the sample has an equal chance of being chosen
Answer:
Random sampling
Question:
A collection of two or more cells in a spreadsheet
Answer:
Range
,Question:
A collection of related data in a data table, usually synonymous with row
Answer:
Record
Question:
When the same piece of data is stored in two or more places
Answer:
Redundancy
Question:
The process of restating a problem or challenge, then redirecting it toward a
potential resolution
Answer:
Reframing
Question:
A rule that says the values in a table must match a prescribed pattern
Answer:
Regular expression (RegEx)
,Question:
A database that contains a series of tables that can be connected to form
relationships
Answer:
Relational database
Question:
A question that has significance to the problem to be solved
Answer:
Relevant question
Question:
A spreadsheet tool that automatically searches for and eliminates duplicate
entries from a spreadsheet
Answer:
Remove duplicates
Question:
A static collection of data periodically given to stakeholders
Answer:
Report
, Question:
A formula that uses the metrics of investment and profit to evaluate the
success of an investment
Answer:
Return on investment (ROI)
Question:
The total amount of income generated by the sale of goods or services
Answer:
Revenue
Question:
A function that returns a set number of characters from the right side of a text
string
Answer:
RIGHT