5. Analyze Data To Updated Actual Questions And Correct Answers

5. ANALYZE DATA TO UPDATED ACTUAL QUESTIONS
AND CORRECT ANSWERS

Question:
1. During which analysis phase does an analyst sort and
filter data?
1. Transform
2. Get input from others
3. Format and adjust
4. Organize

Answer:
3. Format and adjust

Question:
2. You ask volunteers at a theater production which tasks
they have already completed and add that data to a
spreadsheet containing all required tasks. You will use the
information provided by the volunteers to figure out
which tasks still need to be done. This is an example of
which phase of analysis?
1. Organize data (into a dataset)
2. Format and adjust data
3. Get input from others
4. Transform data

Answer:
3. Get input from others

Question:
3. You are working with three datasets about voter turnout
in your county. First, you identify relationships and
patterns between the datasets. Then, you use formulas
and functions to make calculations based on your data.
This is an example of which phase of analysis?
1. Transform data
2. Organize data (into a dataset)
3. Get input from others
4. Format and adjust data

Answer:
1. Transform data

,Question:
4. You are working with a dataset from a local community
college. You sort the students alphabetically by last
name. This is an example of which phase of analysis?
1. Transform data
2. Get input from others
3. Format and adjust data
4. Organize data (into a dataset)

Answer:
3. Format and adjust data

Question:
5. ________ involves arranging data into a meaningful order to
make it easier to understand, analyze, and visualize.
1. Filtering
2. Organizing
3. Sorting
4. Prioritizing

Answer:
3. Sorting

Question:
6. To narrow the scope of a query, a data analyst filters by a
particular criteria. This type of filtering must be done one
variable at a time.
1. True
2. False

Answer:
2. False

Question:
7. A data analyst uses ________ to decide which data is relevant
to their analysis and which data types and variables are
appropriate.
1. database relationships
2. database references
3. database normalization
4. database organization

Answer:
4. database organization

, Question:
8. A data analyst wants to organize a database to show only
the 100 most recent real estate sales in stamford,
Connecticut. How can they do that?
1. The data analyst should add a filter to return only sales
in Stamford, Connecticut, then sort the most recent sales
at the top of their list
2. The data analyst should filter out sales in Stamford,
Connecticut, then sort the least recent sales at the top of
their list
3. The data analyst should add a filter to return only sales
in stamford, Connecticut, then sort the least recent sales
at the top of their list
4. The data analyst should filter out sales in stamford,
Connecticut, then sort the most recent sales at the top of
their list

Answer:
1. The data analyst should add a filter to return only sales in Stamford,
Connecticut, then sort the most recent sales at the top of their list

Question:
9. When you use the menu function Sort Range, nothing in
your spreadsheet gets rearranged except for the fields in
the specified range.
1. True
2. False

Answer:
1. True

Question:
10. Which menu sort function is used to keep data together
across rows?
1. Sort Sheet
2. Sort Column
3. Sort Row
4. Sort Range

Answer:
1. Sort Sheet