Analyze Data to Answer Questions Module 1-4 Challenge Answers

Analyze Data to Answer Questions Module 1 Challenge Answers

A data professional at a finance company sorts spreadsheet data. They sort all data by ranking in the Financial Performance column, keeping together all data across rows. What spreadsheet tool are they using?

• Sort Sheet
• Sort Column
• Sort Together
• Sort Rows

Fill in the blank: To filter for all items in the Products table that are currently in stock, a data professional uses the _ clause in SQL.

• WHERE
• LIMIT
• FILTER
• EXCEPT

A junior data analyst performs several calculations on a dataset. What phase of analysis is the analyst in?

• Transform data
• Organize data
• Format and adjust data
• Get input from others

Which of the following statements accurately describe sorting and filtering? Select all that apply.

• Filtering involves showing data that meets a specified criteria while hiding the rest.
• Sorting can be performed in spreadsheets, but not SQL databases.
• Data professionals sort data to make it easier to understand, analyze, and visualize.
• Sorting can be used to group similar data together by a classification.

Fill in the blank: During an analysis project, _ might involve creating new columns in order to prepare the dataset for analysis.

• organizing data
• transforming data
• getting input from others
• formatting and adjusting data

Which query will return a list of all construction businesses that have made more than $8 million, in order from the largest number of employees to the fewest?

• SELECT * FROM ‘Company_data’ WHERE Business = ‘Construction’ AND Revenue > 8000000 ORDER BY number_of_employees DESC
  
  
• SELECT * FROM ‘Company_data’ WHERE Business = ‘Construction’ WHERE Revenue < 8000000 ORDER BY number_of_employees DESC
  
  
• SELECT * FROM ‘Company_data’ WHERE Business = ‘Construction’, Revenue < 8000000 ORDER BY number_of_employees ASC
  
  
• SELECT * FROM ‘Company_data’ WHERE Business = ‘Construction’ AND Revenue > 8000000 ORDER BY number_of_employees ASC

A data professional in human resources is tasked with identifying appropriate staff members to manage upcoming projects. In the analyze phase of the data analysis process, what activities might this involve? Select all that apply.

• Prepare a report for the stakeholders
• Organize an employee dataset by skills and experience
• Get input from other HR data professionals
• Format the data to filter for keywords relevant to the upcoming projects

Which function sorts a spreadsheet range between cells K1 and L80 in ascending order by the first column, Column K?

• =SORT(K1:L80, 1, FALSE)
• =SORT(K1:L80, 1, TRUE)
• =SORT(K1:L80, A, FALSE)
• =SORT(K1:L80, A, TRUE)