Question: A data analyst is using the menu of a spreadsheet to sort their data. As they examine their dataset, they notice that one column appears

A data analyst is using the menu of a spreadsheet to sort their data. As they examine their dataset, they notice that one column appears to be incorrect. It is sorted in alphabetical order, but the cells are no longer associated with the row they're in. What is the most likely cause of this problem?
They sorted the sheet by column but sorted by the wrong column.
They sorted only the data in the column, rather than sorting the sheet by row.
They sorted the sheet by row instead of column.
They sorted only the data in the column, rather than sorting the sheet by that column.
 A data analyst is using the menu of a spreadsheet to

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!