31. Which of the following tasks would a data analyst perform during the analyze phase of the data analysis process? Select all that apply.
- Getting input from others
- Organizing data into understandable sections
- Visualizing the data with charts
- Preparing a report for the stakeholders
32. You write the SQL query below. However this query is incorrect. What is wrong with it?
SELECT *
FROM invoice
WHERE billing_city = “Chicago”
ORDER total
- Line 4 is missing column = between ORDER and total.
- SELECT, FROM, WHERE, and ORDER are capitalized.
- Line 4 is missing the BY between ORDER and total.
- In line 3, “Chicago” has quotation marks.
33. A data analyst is analyzing sales data to identify trends and relationships. What phase of the data analysis process does this describe?
- Analyze
- Act
- Process
- Prepare
34. A data analyst sorts a spreadsheet range between cells A15 and G71. They sort in ascending order by the second column, Column B. What is the syntax they are using?
- =SORT(A15:G71, 2, FALSE)
- =SORT(A15:G71, 2, TRUE)
- =SORT(A15:G71, B, FALSE)
- =SORT(A15:G71, B, TRUE)
35. A data analyst is using the spreadsheet tool Sort Range. What purpose does this tool serve?
- It allows the analyst to sort the data in a spreadsheet by a specific sorted column.
- It allows the analyst to sort a specific selection of cells only.
- It sorts all of the data in a spreadsheet by a specific sorted row.
- It sorts all of the data in a spreadsheet by the ranking of a specific sorted row.
36. A data analyst sorts a spreadsheet range between cells F19 and G82. They sort in ascending order by the second column, Column G. What is the syntax they are using?
- =SORT(F19:G82, B, FALSE)
- =SORT(F19:G82, 2, TRUE)
- =SORT(F19:G82, B, TRUE)
- =SORT(F19:G82, 2, FALSE)
