Exam DA0-001 topic 1 question 5 discussion

Sorting allows the data to be arranged in a specified order.

Sorting in ascending or descending order does exactly what it is required

Grouping? not sorting , why??

D. Sorting is the function that will allow the data analyst to organize the table in the desired manner. Sorting allows the data analyst to arrange the data in a specific order, either in ascending or descending order, based on one or multiple columns. In this case, the analyst can sort the table by Age from high to low by clicking on the Age column and selecting "Sort Descending". They can then sort the table by Income in alphabetic order by clicking on the Income column and selecting "Sort A to Z". Sorting is a simple and efficient way to organize large data sets, making it easier for the analyst to analyze and present the data.

Sorting is the process of organizing a table by rearranging the rows based on the values in one or more columns. In this case, the data analyst can use the sorting function to organize the table by sales from high to low, and then by state in alphabetic order. To do this, the data analyst would select the sales column and then choose the "sort largest to smallest" option, and then select the state column and choose the "sort A to Z" option. This will rearrange the rows of the table so that the rows are first sorted by sales from high to low, and then within those groups, the rows are sorted by state in alphabetic order. The other options (conditional formatting, grouping, and filtering) are not related to organizing the table in this manner.

D: Sorting