hich of the following statements accurately describe sorting and filtering? Select all that apply.1 pointSorting can be performed in spreadsheets, but not SQL databases.Sorting can be used to group similar data together by a classification. Filtering involves showing data that meets a specified criteria while hiding the rest.Data professionals sort data to make it easier to understand, analyze, and visualize.

Which one of the following construct is used for sorting the data in the result set of SQL queries?

Question 4In what way is the SQL WHERE clause similar to filtering in spreadsheets?1 pointBoth the WHERE clause and spreadsheet filters enable data professionals to remove duplicate columns.Both the WHERE clause and spreadsheet filters enable efficient sorting of data.Both the WHERE clause and spreadsheet filters can be used to create pivot tables.Both the WHERE clause and spreadsheet filters return a subset of data based on specified criteria.

Fill in the blank: A data analyst uses a SQL query to retrieve information from a database. They add a WHERE statement to _____ the data based on certain conditions.filtersortcategorizecopy

Question 1A data analyst at a high-tech manufacturer sorts inventory data in a spreadsheet. They sort all data by ranking in the Order Frequency column, keeping together all data across rows. What spreadsheet tool are they using? 1 pointSort SheetSort TogetherSort RowsSort Column

1.Question 1Which menu function sorts all spreadsheet data by the ranking of a specific sorted column?1 pointSort sheet Sort by rankSort range Sort data