Table of Content
- 1 Analyze Data to Answer Questions Module 1 Challenge Answers
- 1.1 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?
- 1.2 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.
- 1.3 A junior data analyst performs several calculations on a dataset. What phase of analysis is the analyst in?
- 1.4 Which of the following statements accurately describe sorting and filtering? Select all that apply.
- 1.5 Fill in the blank: During an analysis project, _ might involve creating new columns in order to prepare the dataset for analysis.
- 1.6 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?
- 1.7 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.
- 1.8 Which function sorts a spreadsheet range between cells K1 and L80 in ascending order by the first column, Column K?
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)