31. Which of the following tasks would a data analyst perform during the analyze phase of the data analysis process? Select all that apply.
32. You write the SQL query below. However this query is incorrect. What is wrong with it?
WHERE billing_city = “Chicago”
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?
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.